HSC ICUs Data by Patient: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
| Recipients = <names> | | Recipients = <names> | ||
| MailingList = <Outlook list if applicable> | | MailingList = <Outlook list if applicable> | ||
| DataDependencies = | | DataDependencies = see below | ||
| SASFiles = | | SASFiles = S:\MED\MED_CCMED\Julie\CC Projects\2021\04_HSC_Osorio | ||
}} | }} | ||
For Decision Support HSC Dashboard | For Decision Support HSC Dashboard | ||
{| class="wikitable" border=1 | |||
{ | |- | ||
! 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 Location|| || | |||
|- | |||
|| CC_Unit_Startdate2 ||StartDate1 on the second ICU Location || || | |||
|- | |||
|| CC_Unit1 || The first ICU location the patient stayed in a continuous ICU episode || || | |||
|- | |||
|| CC_Unit2 || The second ICU location 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) || || |
Revision as of 16:53, 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 Location | ||
CC_Unit_Startdate2 | StartDate1 on the second ICU Location | ||
CC_Unit1 | The first ICU location the patient stayed in a continuous ICU episode | ||
CC_Unit2 | The second ICU location 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) |