HSC ICUs Data by Patient: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
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 = [[Dispo DtTm]], [[Transfer Delay]], [[Previous Location]], [[Dispo]]
| DataDependencies = see below
| SASFiles = <path for SAS files>
| 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
{{Discuss | who = Julie | question=
|-
* What is the field "HospitalLocation"
! Variable      !!Description!! Data Field !! Data type
* What is the field "NextArrival"
|-
* Do we have pages yet for "Readmit48hrs", "Readmit72hrs"
|| 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
 
  • 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)