Deaths and Readmissions Review

Deaths and Readmissions Import Specification

MEDILOGIK provide a facility to import deaths and readmissions data from healthcare PAS / PMS systems into MEDILOGIK EMS for review against performed endoscopy procedures and wish to review correlated data within MEDILOGIK EMS.

The attached Import Specification document has been prepared for use by healthcare IT and / or business intelligence staff.

MEDILOGIK EMS - Deaths and Readmissions Import Specification

Deaths and Readmissions Review

Summary Overview
Based on parameters selected

Position	Column	Description
1	Record Type	Not Reviewed Probable Possible Unlikely Unknown
2	Totals	Totals of each type of Record Type based on date parameters selected

Note: The Extract Report will display display ALL data based on selected parameters

Summary Detail Report
Based on parameters selected

Position	Column	Description
1	Unit	Site where the procedure is to be performed
2	Room	Room where the procedure is to be performed
3	Hospital Identifier	Local patient identifier (e.g. Hospital Number)
4	National Identifier	National patient identifier (e.g. NHS or CHI Number)
5	Patient Name	Patient’s Full Name
6	Gender	Patient’s gender
7	Date of Birth	Patient’s date of birth
8	Age at Procedure	Patient’s Age on the date the procedure is to be performed
9	Procedure Date	Date when procedure was performed
10	Procedure	Procedure performed
11	Endoscopists	Name of Endoscopist (s)
12	List Type	Service / Training
13	Referral Source	Source of referral (e.g. Day case, In-patient)
14	Therapeutics	Details of Therapeutic procedures performed
15	Follow Up	Details of Follow Up recorded
16	Adverse Events	Recorded Event recorded in pathway stage Immediate Post Procedure Post Discharge
17	Date of readmission	Date of readmission to hospital
18	Ward	Name of readmission location – if provided
19	Consultant	Name of Consultant responsible for patient’s readmission – if provided
20	PAS speciality code	PAS speciality code – if provided
21	Procedure or OPCS4 code	Procedure or OPCS4 code – if provided
22	Date of Discharge	Recorded Date of Discharge
23	Discharged to	Location of discharge
24	Date of Death	Recorded Date of Death for patient
25	Date Reviewed	Date of review
26	Reviewed by	Name of person reviewing record
27	Review Comments	Details of Review Comments recorded (EMS)
28	Procedure Related	Recorded details at review (EMS) Probable Possible Unlikely Unknown
29	Procedure Appropriateness	Recorded appropriateness at review (EMS) Appropriate Uncertain Inappropriate
30	EUG Agreed Action	Space for EUG comments once report has been extracted to Excel

Report Parameters

Position	Column	Description
1	Unit	Select from ALL or individual sites where procedures are to be performed (in case of multiple site organisations)
2	From	Date from which the report will interrogate the data – defaults to current date
3	To	Date to which the report will interrogate the data – defaults to 8 weeks into the future
4	Type	Select from All 30-day Mortality 8-day Readmission
5	Procedure Related	Select from Not Reviewed Probable Possible Unlikely Unknown Multiple selections permitted