Query Readmission Analysis Associate HAK1044.4

Knowledge Activity: Query - Readmission Analysis
(Associate)
Prerequisites
1. It is highly recommended the following activities are completed prior to this activity:
 Query – Basic Orientation (Informatics)
 Query – Advanced Orientation (Informatics)
Student instructions
1. If you have questions about this activity, please contact your instructor for assistance.
2. You will use the EHR Go queries tool to complete this activity. Your instructor has
provided you with a link to the Query - Readmission Analysis (AS) activity. Click on 2:
Launch EHR to launch the queries tool and begin this activity.
3. You’ve been granted access to certain data in the EHR to complete this activity. The
approved data has already been linked to the queries tool in the EHR.
4. Document your answers directly on this activity document as you complete the activity.
When you are finished, you will save this activity document to your device and upload
this activity document with your answers to your Learning Management System (LMS).
The activity
Reducing unnecessary hospital admissions and readmissions is a key component of healthcare
quality improvement (Forum, 2017). A readmission is classified as an unintended readmission
to the hospital within thirty (30) days of discharge. Certain diagnoses are known to have higher
readmission rates and can be used to assess the overall quality of the healthcare provided
during an admission.
The General Hospital is doing a self-assessment of readmissions and would like you to prepare a
report with data on the following selected discharge diagnoses: gangrene, heart failure,
unspecified kidney failure, and sickle cell disorders. Compare the findings to the readmission
rate across all other admissions.
Access the EHR queries tool and corresponding dataset under 2: Launch EHR. Click the New
Session button to launch the EHR.
EHR Go Knowledge Activity: Query - Readmission Analysis (Associate) HAK1044.4

Archetype Innovations LLC ©2022 1
Generate various queries to answer the questions in the next section. An example query for
one of the diagnoses (gangrene) is provided below. Hint: Just repeat the same steps for the
additional diagnoses.
Gangrene Analysis
On the Queries tab, select New to initiate a new query.
Enter the following then Query.

Name: Gangrene discharges
Query Rules: ‘Discharge Diagnosis’ equal ‘I96 Gangrene’
2
After running the query, select Close. Repeat the steps for the additional new queries for the
gangrene discharge diagnosis.
Name: Gangrene not readmitted

AND (select +Add rule)
‘Readmission Status’ equal ‘Not readmitted <30 days’
Name: Gangrene readmissions

AND (select +Add rule)
‘Readmission Status’ equal ‘Readmitted <30 days’
3
Repeat these same queries for the additional discharge diagnoses (heart failure, unspecified
kidney failure, sickle cell disorders, and all other admissions). Once finished, go to the Queries
tab summary view, which you will see after closing out of the last query you run, and note the
Total Record(s) for each resulting query. Use those numbers to answer the questions below.
Questions
1. What are the total number of gangrene discharges? -39
2. What are the number of gangrene discharges not readmitted? -28
3. What are the number of gangrene discharges readmitted? -11
4. Using a calculator or other resource, what is the readmission rate for gangrene? Hint:
divide your answer for question 3 by your answer for question 1. Convert to a
percentage. Round to the nearest tenth. 28.2%
5. What are the total number of heart failure discharges? -54
6. What are the number of heart failure not readmitted? -36
7. What are the number of heart failure readmitted? -18
8. Using a calculator or other resource, what is the readmission rate for heart failure? Hint:
divide your answer for question 7 by your answer for question 5. Convert to a
percentage. Round to the nearest tenth. -33.3%
9. What are the total number of unspecified kidney failure discharges? -34
10. What are the number of unspecified kidney failure not readmitted? -27
11. What are the number of unspecified kidney failure readmitted? -7
4
12. Using a calculator or other resource, what is the readmission rate for unspecified kidney
failure? Hint: divide your answer for question 11 by your answer for question 9. Convert
to a percentage. Round to the nearest tenth. -20.6%
13. What are the total number of sickle cell disorders discharges? -22
14. What are the number of sickle cell disorders not readmitted? -17
15. What are the number of sickle cell disorders readmitted? -5
16. Using a calculator or other resource, what is the readmission rate for sickle cell
disorders? Hint: divide your answer for question 15 by your answer for question 13.
Convert to a percentage. Round to the nearest tenth. -22.7%
17. What are the total number of all other admissions discharges? -112
18. What are the number of all other admissions not readmitted? -104
19. What are the number of all other admissions readmitted? -8
20. Using a calculator or other resource, what is the readmission rate for all other
admissions? Hint: divide your answer for question 19 by your answer for question 17.
Convert to a percentage. Round to the nearest tenth. -7.1%
21. Which discharge diagnosis has the highest readmission rate? Heart failure
22. Besides ‘all other admissions’, which discharge diagnosis has the lowest readmission
rate? -Sickle Cell Disorders
23. Excluding the ‘all other admissions’ discharge diagnosis, what is the readmission rate for
the remaining 4 discharge diagnoses? Round to the nearest tenth. (Hint: to calculate,
divide the number of total readmissions for the remaining 4 discharge diagnoses by the
number of total discharges for those diagnoses.) - 26.2%
Submit your work

Document your answers directly on this activity document as you complete the activity. When
you are finished, save this activity document to your device and upload this activity document
with your answers to your Learning Management System (LMS). If you have any questions
about submitting your work to your LMS, please contact your instructor.
Learning objectives
1. Apply health informatics concepts to the management of health information (3)
2. Utilize technologies for health information management (3)
3. Calculate statistics for health care operations (3)
4. Manage data within a database system (5)
5
References
Forum, N. Q. (2017). All-Cause Admissions and Readmissions 2017. Washington D.C.:
Department of Health and Human Services.

Query Readmission Analysis Associate HAK1044.4

Uploaded by

Copyright:

Available Formats

Query Readmission Analysis Associate HAK1044.4

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Query Readmission Analysis Associate HAK1044.4

Uploaded by

Copyright:

Available Formats

Knowledge Activity: Query - Readmission Analysis

EHR Go Knowledge Activity: Query - Readmission Analysis (Associate) HAK1044.4

Enter the following then Query.

Name: Gangrene not readmitted

Name: Gangrene readmissions

Submit your work

You might also like