HSC ICUs Data by Patient

From CCMDB Wiki
Revision as of 16:53, 2021 April 29 by JMojica (talk | contribs)
Jump to navigation Jump to search
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
 
  • Cargo


  • Categories
  • Default form:

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)