HSC ICUs Data by Patient: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 24: | Line 24: | ||
|| LOS || Difference between ICU Discharge Date_time and ICU Admission Date_time|| || created | || LOS || Difference between ICU Discharge Date_time and ICU Admission Date_time|| || created | ||
|- | |- | ||
|| CC_Unit_Startdate1 || StartDate1 on the first ICU | || CC_Unit_Startdate1 || StartDate1 on the first ICU service|| || | ||
|- | |- | ||
|| CC_Unit_Startdate2 ||StartDate1 on the second ICU | || CC_Unit_Startdate2 ||StartDate1 on the second ICU service || || | ||
|- | |- | ||
|| CC_Unit1 || The first ICU | || CC_Unit1 || The first ICU service the patient stayed in a continuous ICU episode || || | ||
|- | |- | ||
|| CC_Unit2 || The second ICU | || CC_Unit2 || The second ICU service the patient stayed in a continuous ICU episode || || | ||
|- | |- | ||
|| HospitalLocation || Current Hospital and Unit || || | || HospitalLocation || Current Hospital and Unit || || | ||
Revision as of 16:57, 2021 April 29
| 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
| 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 | 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 | ||
| ICU_AdmissionDate | ICU Admission Date_time | ||
| ICU_DischargeDate | ICU Discharge Date_time | Dispo DtTm | |
| ICU_TransferReadyDate | Transfer Ready Date_time if available | ||
| TransferDelay | 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 | ||
| 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) | ||
| Readmits72hrs | Readmission to ICU within 72 hours after ICU discharged? binary code (1-yes, 0-no) |