HSC ICUs Data by Patient: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (removed a question that is now addressed differently, and that had broken links.) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 7: | Line 7: | ||
| Recipients = <names> | | Recipients = <names> | ||
| MailingList = <Outlook list if applicable> | | MailingList = <Outlook list if applicable> | ||
| DataDependencies = LOS; Transfer Ready DtTm tmp entry; Transfer Delay; Previous Location; Dispo; Dispo_DtTm; Boarding Loc; Service tmp entry; | | DataDependencies = LOS; Transfer Ready DtTm tmp entry; Transfer Delay; Previous Location; Dispo; Dispo_DtTm; Boarding Loc; Service tmp entry; Readmission Rate to ICU | ||
| SASFiles = S:\MED\MED_CCMED\Julie\CC Projects\2021\04_HSC_Osorio | | SASFiles = S:\MED\MED_CCMED\Julie\CC Projects\2021\04_HSC_Osorio | ||
}} | }} | ||
Line 62: | Line 58: | ||
|| PalliativePatient || Palliative Patient binary code (1-yes, 0-no) - if yes then readmission=0 || {{Discuss | based on [[DC Treatment]], ICD10 [[Palliative care]] or what? }} || | || PalliativePatient || Palliative Patient binary code (1-yes, 0-no) - if yes then readmission=0 || {{Discuss | based on [[DC Treatment]], ICD10 [[Palliative care]] or what? }} || | ||
|- | |- | ||
|| NextFromLocation || Previous physical location of the Next ICU admission || || | || NextFromLocation || [[Previous Location |Previous physical location]] of the Next ICU admission || || | ||
|- | |- | ||
|| Readmits48hrs || Readmission to ICU within 48 hours after ICU discharged? binary code (1-yes, 0-no) || || | || Readmits48hrs || Readmission to ICU within 48 hours after ICU discharged? binary code (1-yes, 0-no) || [[Readmission Rate to ICU]] || | ||
|- | |- | ||
|| Readmits72hrs || Readmission to ICU within 72 hours after ICU discharged? binary code (1-yes, 0-no) || [[ | || Readmits72hrs || Readmission to ICU within 72 hours after ICU discharged? binary code (1-yes, 0-no) || [[Readmission Rate to ICU]] | ||
-} | -} |
Revision as of 08:55, 2021 July 14
Reports | |
Report: | HSC ICUs Data by Patient |
StartDtTm: | Aug 2018 |
EndDtTm: | |
Contact Person : | Barbara Osorio |
Recipients: | <names> |
Frequency: | monthly |
MailingList: | <Outlook list if applicable> |
Data Dependencies : | LOS • Transfer Ready DtTm tmp entry • Transfer Delay (Critical Care) • Pre-admit Inpatient Institution • Previous Location • Dispo • Dispo DtTm • Boarding Loc • Service tmp entry • Readmission Rate to ICU |
SASFiles: | S:\MED\MED_CCMED\Julie\CC Projects\2021\04_HSC_Osorio |
For Decision Support HSC Dashboard ( incomplete and still in progress )
Variable | Description | Data Field | Data type | |
---|---|---|---|---|
D_ID | Unique Record ID | created | ||
Person_ID | Unique Patient ID (computer generated) | created | ||
RecordStatus | Vetted | |||
LOS | Difference between ICU Discharge Date_time and ICU Admission Date_time | LOS | created | |
CC_Unit_Startdate1 | StartDate1 on the first ICU service | |||
CC_Unit_Startdate2 | StartDate1 on the second ICU service | |||
CC_Unit1 | The first ICU service the patient stayed in a continuous ICU episode | |||
CC_Unit2 | The second ICU service the patient stayed in a continuous ICU episode | |||
HospitalLocation | Current Hospital and Unit | Boarding Loc? | ||
ICU_AdmissionDate | ICU Admission Date_time | first Service tmp entry? | ||
ICU_DischargeDate | ICU Discharge Date_time | Dispo DtTm | ||
ICU_TransferReadyDate | Transfer Ready Date_time if available | Transfer Ready DtTm tmp entry | ||
TransferDelay | Transfer Delay - Difference between ICU Discharge Date_time and Transfer Ready Date_time | Transfer Delay | ||
PreInpatientLocation | Previous Inpatient location prior to ICU admission if applicable/available |
| ||
AdmitFromLocation | Previous physical location prior to ICU admission | Previous Location | ||
DischToLocation | Location patient went at discharge | Dispo | ||
NextArrival | Next ICU Admission Date_time if available | |||
Difference | Difference Between ICU Discharge Date_time and Next Arrival Date_time | |||
NextHospitalLocation | Location of the Next ICU Admission | |||
PlannedSurgery | Planned Surgery binary code (Y-yes, N-No) - if yes then readmission=0 | Admit Type for APACHE II? | ||
PalliativePatient | Palliative Patient binary code (1-yes, 0-no) - if yes then readmission=0 |
| ||
NextFromLocation | Previous physical location of the Next ICU admission | |||
Readmits48hrs | Readmission to ICU within 48 hours after ICU discharged? binary code (1-yes, 0-no) | Readmission Rate to ICU | ||
Readmits72hrs | Readmission to ICU within 72 hours after ICU discharged? binary code (1-yes, 0-no) | Readmission Rate to ICU
-} |