Unformatted Attachment Preview
HIT 226 Course Project: Hospital Data Analysis and Reporting
The data below is from General Hospital. Calculate the turnaround time for each request. Assume that the acceptable turnaround time is
Release of Information Report for January 2015
#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Date Received
01/01/15
01/04/15
01/05/15
01/09/15
01/10/15
01/11/15
01/11/15
01/15/15
01/17/15
01/18/15
01/20/15
01/21/15
01/21/15
01/21/15
01/25/15
01/25/15
01/27/15
01/28/15
01/31/15
01/31/15
Client Name
Jones, Johnny
King, Samantha
Piazza, Anthony
Legend, Mary
Stepnowski, Joseph
Largent, Khalif
Williams, Michael
Teller, Aiden
Hower, Layla
Cartwright, Renee
Perez, Stacey
Santoso, Susan
Williams, William
Abrams, Jonah
Stern, Kimberly
Sran, Timothy
Berger, Mark
Romano, Maria
Smith, Jennifer
Martinez, Alonso
Requestor Name
PCP
St. Lawrence
PCP
Attorney
Robert Wood Johnson
Mother
PCP
PCP
Bayonne Medical Center
Robert Wood Johnson
PCP
Attorney
St. Lawrence
St. Lawrence
Robert Wood Johnson
PCP
PCP
Attorney
St. Lukes
PCP
Info Disclosed
H&P
D/C Summary
D/C Summary
D/C Summary
X-rays
D/C Summary
H&P
D/C Summary
D/C Summary
Lab reports
X-rays
X-rays
D/C Summary
D/C Summary
H&P
Lab reports
X-rays
D/C Summary
D/C Summary
D/C Summary
Purpose of Disclosure
Continuity of Care
Continuity of Care
Continuity of Care
Litigation
Continuity of Care
Individual
Continuity of Care
Continuity of Care
Continuity of Care
Continuity of Care
Continuity of Care
Litigation
Continuity of Care
Continuity of Care
Continuity of Care
Continuity of Care
Continuity of Care
Litigation
Continuity of Care
Continuity of Care
t the acceptable turnaround time is 21 days.
Date Disclosed
01/11/15
01/24/15
02/04/15
02/18/15
01/11/15
03/02/15
01/17/15
01/20/15
02/26/15
02/01/15
03/05/15
03/01/15
01/28/15
04/05/15
01/31/15
02/05/15
02/09/15
02/01/15
03/03/15
05/04/15
5 points
Records Offsite Staff ID # Turnaround Time
N
14571
N
14571
N
25148
Y
25148
N
25148
N
14571
N
14571
N
25148
N
14571
Y
14571
Y
25148
N
14571
N
14571
N
25148
N
25148
N
25148
N
25148
N
14571
N
14571
Y
25148
HIT 226 Course Project: Hospital Data Analysis and Reporting
The data below is from General Hospital. Calculate the turnaround time for each order. Assume that the acceptable turnaround time is 0
Physician Order Report for January 2015
Physician : Dr. Jones
Client Medical Record #: 123456
Date of Admission: 1/6/15
Date of Discharge: 1/9/15
Date of Order
Date Signed
01/06/15
01/06/15
01/06/15
01/06/15
01/06/15
01/07/15
01/07/15
01/08/15
01/07/15
01/07/15
01/08/15
01/08/15
2 points
Turnaround Time
Physicians: Dr. Huffman
Client Medical Record #: 654789
Date of Admission: 1/10/15
Date of Discharge: 1/15/15
Date of Order
Date Signed
01/10/15
01/10/15
01/10/15
01/10/15
01/10/15
01/11/15
01/10/15
01/11/15
01/11/15
01/11/15
01/12/15
01/12/15
01/12/15
01/14/15
01/12/15
01/14/15
01/12/15
01/14/15
3 points
Turnaround Time
HIT 226 Course Project - Data Analysis and Identification of Noncompliance - Due in Week 6, day 7 (Sunday midnight)
The data below is from General Hospital. Assume the acceptable turnaround (TAT) for dictating the H&P is 0 day and signing is 1 day.
History and physical dictation (how many days it took to dictate the H&P for each admission — subtract date of admission from the date o
History and physical signature (how many days it took to sign the H&P — subtract date of admission from the date signed)
History and Physical Report for January 2015
5 points
#
MR #
Physician Date of Admission Date Dictated Date Transcribed Date Signed Dictated TAT
1
789321 Leiberman
01/04/15
01/04/15
01/04/15
01/04/15
2
456321 Huffman
01/04/15
01/05/15
01/05/15
01/06/15
3
741852 Patrikus
01/06/15
01/07/15
01/08/15
01/08/15
4
963321 Johns
01/07/15
01/08/15
01/07/15
01/09/15
5
144558 Huffman
01/10/15
01/10/15
01/11/15
01/10/15
6
695852 Leiberman
01/10/15
01/10/15
01/10/15
01/10/15
7
124536 Huffman
01/12/15
01/12/15
01/12/15
01/12/15
8
379152 Leiberman
01/15/15
01/16/15
01/16/15
01/16/15
9
685982 Jones
01/16/15
01/16/15
01/16/15
01/17/15
10 558844 Jones
01/17/15
01/17/15
01/17/15
01/18/15
11 415287 Johns
01/20/15
01/22/15
01/22/15
01/24/15
12 919125 Patrikus
01/20/15
01/20/15
01/20/15
01/22/15
13 744445 Patrikus
01/21/15
01/21/15
01/21/15
01/25/15
14 111111 Patrikus
01/21/15
01/21/15
01/21/15
01/22/15
15 145281 Huffman
01/26/15
01/26/15
01/27/15
01/27/15
16 144417 Leiberman
01/26/15
01/26/15
01/26/15
01/27/15
17 695833 Patrikus
01/27/15
01/27/15
01/27/15
01/31/15
18 335588 Johns
01/28/15
01/31/15
01/31/15
02/02/15
19 457924 Jones
01/31/15
01/31/15
01/31/15
02/01/15
20 414519 Huffman
01/31/15
01/31/15
01/31/15
02/01/15
unday midnight)
&P is 0 day and signing is 1 day.
t date of admission from the date of dictation)
om the date signed)
5 points
Signed TAT
HIT 226 Course Project - Data Analysis and Identification of Noncompliance - Due in Week 6, day 7 (Sunday midnight)
The data below is from General Hospital. Assume the acceptable turnaround (TAT) for dictating the discharge summary is 14 days and sign
Discharge summary completion (how many days it took to dictate the DC for each admission — subtract date of discharge from the date o
Discharge summary signature (how many days it took to sign the DC — subtract date of discharge from the date signed)
Discharge Summary Report for January 2015
5 points
#
MR #
Physician
Date of Discharge Date Dictated Date Transcribed Date Signed Dictated TAT
1 789321 Leiberman
01/07/15
02/01/15
02/01/15
02/15/15
2 456321 Huffman
01/08/15
01/28/15
01/30/15
02/13/15
3 741852 Patrikus
01/10/15
01/25/15
01/18/15
02/12/15
4 963321 Johns
01/28/15
02/07/15
02/08/15
02/10/15
5 144558 Huffman
01/12/15
01/17/15
01/29/15
02/28/15
6 695852 Leiberman
01/11/15
01/11/15
01/31/15
02/12/15
7 124536 Huffman
01/18/15
02/15/15
02/15/15
02/21/15
8 379152 Leiberman
01/17/15
02/07/15
02/08/15
03/01/15
9 685982 Jones
01/19/15
01/19/15
01/20/15
01/21/15
10 558844 Jones
01/18/15
01/25/15
01/25/15
01/28/15
11 415287 Johns
01/21/15
01/24/15
01/25/15
01/31/15
12 919125 Patrikus
01/26/15
01/31/15
02/01/15
02/15/15
13 744445 Patrikus
01/24/15
02/04/15
02/04/15
02/06/15
14 111111 Patrikus
01/23/15
01/26/15
01/26/15
01/31/15
15 145281 Huffman
01/28/15
01/31/15
01/31/15
03/08/15
16 144417 Leiberman
01/31/15
02/28/15
02/28/15
03/04/15
17 695833 Patrikus
02/01/15
02/15/15
02/15/15
02/21/15
18 335588 Johns
02/01/15
02/15/15
02/15/15
02/19/15
19 457924 Jones
02/10/15
02/10/15
02/11/15
02/12/15
20 414519 Huffman
02/06/15
02/07/15
02/07/15
04/01/15
ge summary is 14 days and signing is 21 days.
e of discharge from the date of dictation)
5 points
Signed TAT
HIT 226 Course Project - Data Analysis and Identification of Noncompliance - Due in Week 6, day 7 (Sunday midnight)
The data below is from General Hospital. Assume the acceptable turnaround (TAT) for dictating the operative report is 0 days, transcribing
Operative report completion (how many days it took to dictate the OP report for each admission — subtract date of surgery from the date
Operative report signature (how many days it took to sign the OP report — subtract date of admission from the date signed)
Operative Report for January 2015
5 points
#
MR #
Physician Date of Operation Date Dictated Date Transcribed Date Signed Dictated TAT
1 789321 Leiberman
01/04/15
01/04/15
01/04/15
01/06/15
2 456321 Huffman
01/05/15
01/05/15
01/05/15
01/07/15
3 741852 Patrikus
01/06/15
01/07/15
01/07/15
01/07/15
4 963321 Johns
01/08/15
01/09/15
01/09/15
01/09/15
5 144558 Huffman
01/10/15
01/10/15
01/10/15
01/10/15
6 695852 Leiberman
01/10/15
01/10/15
01/10/15
01/10/15
7 124536 Huffman
01/13/15
01/13/15
01/13/15
01/13/15
8 379152 Leiberman
01/15/15
01/17/15
01/17/15
01/19/15
9 685982 Jones
01/16/15
01/17/15
01/17/15
01/20/15
10 558844 Jones
01/18/15
01/20/15
01/20/15
01/27/15
11 415287 Johns
01/21/15
01/22/15
01/22/15
01/22/15
12 919125 Patrikus
01/20/15
01/21/15
01/21/15
01/21/15
13 744445 Patrikus
01/22/15
01/22/15
01/22/15
01/23/15
14 111111 Patrikus
01/21/15
01/21/15
01/21/15
01/21/15
15 145281 Huffman
01/27/15
01/27/15
01/27/15
01/27/15
16 144417 Leiberman
01/26/15
01/31/15
01/31/15
02/02/15
17 695833 Patrikus
01/28/15
01/28/15
01/28/15
01/29/15
18 335588 Johns
01/28/15
01/29/15
01/29/15
01/29/15
19 457924 Jones
01/31/15
01/31/15
01/31/15
02/10/15
20 414519 Huffman
02/01/15
02/01/15
02/01/15
02/02/15
Sunday midnight)
perative report is 0 days, transcribing is 1 day, and signing is 1 day.
ubtract date of surgery from the date of dictation)
n from the date signed)
5 points
Signed TAT
HIT226 Course Project: Hospital Data Analysis and Reporting
The data below is from General Hospital. Populate columns I, J, and K. Evaluate each measure to determine whether it is better or worse.
Core Measure Report for January 2015 - MI & CHF (Myocardial Infarction & Congestive Heart Failure)
Heart Attach Care
Average number of minutes before outpatients with chest
pain or possible heart attack who needed specialized care
were transferred to another hospital
General Hospital
57
National Average
59
Average number of minutes before outpatients with chest
pain or possible heart attack got an ECG
9
7
Outpatients with chest pain or possible heart attack who got
drugs to break up blood clots within 30 minutes of arrival
43%
57%
Outpatients with chest pain or possible heart attack who got
aspirin within 24 hours of arrival
95%
96%
Heart attack patients given fibrinolytic medication within 30
minutes of arrival
37%
58%
Heart attack patients given PCI within 90 minutes of arrival
94%
96%
Heart Failure Care
Heart Failure patients given discharge instructions
Heart Failure patients given an evaluation of left ventricular
systolic (LVS) function
Heart Failure patients given an ACE inhibitor or ARB for left
ventricular systolic dysfunction (LVSD)
General Hospital
94%
100%
75%
National Average
94%
99%
97%
sure to determine whether it is better or worse.
5 points
Minimum Expected
60
5 points
General Hospital's Results
10
50%
90%
50%
80%
Minimum Expected
80%
80%
80%
General Hospital's Results
5 points
Comment on areas that need improvement
Comment on areas that need improvement
...