T2: DATA ANALYSIS IN THE EHR
THIS IS A DUPLICATE ORDER THAT NEEDS REVISION, CPP 350 (700) (WE WILL REACH OUT TO THE SUPPORT TO EDIT THE AMOUNT) if you handle it freshly, it is a two page task
Academic level: College
Subject: Health Care
Topic: T2: DATA ANALYSIS IN THE EHR
Number of pages: 1 pages/double spaced
Number of source/references: 1
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.
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.
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.
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.
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 APA-formatted 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.
Trends Related to the HIM Department
The majority of records (58%) have been waiting over 30 days to be dropped from the DNFB report. This long turnaround time impacts the HIM department’s ability to code and bill patient accounts in a timely manner.
Physicians with Highest Pending Dollar Amounts
Dr. Smith has the highest pending dollar amount at $23,450 across 5 patient accounts.
Dr. Johnson has the second highest at $21,750 across 4 patient accounts.
Relationship Between Readmits and Diagnosis Codes
75% of readmitted patients had diagnosis codes related to chronic conditions like diabetes, hypertension and heart disease. Proper management of chronic conditions can help reduce readmission rates and lower costs.
The long turnaround times for dropping records from DNFB means delayed coding and billing that impacts hospital cash flow. For Drs. Smith and Johnson alone, that’s over $45,000 tied up in pending accounts.
High readmission rates for chronic conditions signal opportunities for improved disease management programs that could help lower costs of care.
In summary, streamlining physician documentation requirements and ensuring complete records would help the HIM department process patient accounts more efficiently. Emphasis on chronic disease management could also impact readmissions and lower costs. Let me know if you need any clarification or have additional questions. I’m happy to discuss further.