Healthcare settings
In this task, you will use a scenario and hypothetical data in a spreadsheet to identify and analyze trends from a healthcare setting. You will also create a memo that summarizes all your findings.
The purpose of this task is to recognize the impact of healthcare IT systems on healthcare infrastructure and to examine healthcare information systems and the role healthcare information systems have in converting data to organizational knowledge.
Scenario
Management of the health information management (HIM) department at Felder Hospital is requesting a report on records waiting to be dropped from the discharge not final billed (DNFB). These patient accounts cannot be coded and billed due to delinquencies like missing reports, missing signatures, or outstanding physician queries. The chief financial officer (CFO) is regularly asking the HIM director why records are outstanding on the DNFB report. HIM management needs this information to share with the CFO to show that a certain number of the records are waiting for physician documentation. The report will include patient demographics, payor types, reimbursement amount, number of days since discharge, clinical specialty, whether the patient was a readmit, and attending physician.
An HIM systems analyst 1 has pulled the relevant data into the attached “Records Waiting to be Dropped from DNFB” spreadsheet from the EHR and used this data to identify several different trends regarding payor type, hospital unit, and physician.
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may
not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Refer to the attached “Records Waiting to be Dropped from DNFB” spreadsheet and use a data sort to do the following:
1. Describe a trend related to the health information management (HIM) department.
2. Identify the
two physicians with the highest pending dollar amount.
3. Explain the relationship between readmits and diagnosis codes.
Note: The explanation must be supported using data from the spreadsheet.
4. Analyze the financial impact that the findings from parts A1, A2, and A3 have on the hospital.
B. Create a memo addressed to the CFO that summarizes your findings from parts A1, A2, and A3.
C. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized.
D. Demonstrate professional communication in the content and presentation of your submission.
