HSC ICUs Data by Patient

From CCMDB Wiki
Revision as of 22:14, 2021 April 29 by Ttenbergen (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:
  • simply putting "see below" in the Data Dependencies field will break the links to the indicators, ie if we want to know what will unravel if we change something there will be no connection. I will try to add the links now so this will work, please edit as needed.
  • SMW


  • Cargo


  • Categories
  • SMW


  • Cargo


  • Categories

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
  • SMW


  • Cargo


  • Categories
||
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
based on DC Treatment, ICD10 Palliative care or what? 
  • SMW


  • Cargo


  • Categories
||
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) 72hr Readmission Rate to ICU

-}