HSC ICUs Data by Patient: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 7: Line 7:
| Recipients = <names>
| Recipients = <names>
| MailingList = <Outlook list if applicable>
| MailingList = <Outlook list if applicable>
| DataDependencies = see below
| DataDependencies = LOS; Transfer Ready DtTm tmp entry; Transfer Delay; Previous Location; Dispo; Dispo_DtTm; Boarding Loc; Service tmp entry; 72hr Readmission Rate to ICU
| SASFiles = S:\MED\MED_CCMED\Julie\CC Projects\2021\04_HSC_Osorio
| SASFiles = S:\MED\MED_CCMED\Julie\CC Projects\2021\04_HSC_Osorio
}}
{{discuss | who = Julie | question =
* 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.
}}
{{Discuss | who = Julie | question =
* before we duplicate a bunch of things... some of is also addressed in [[Readmission]], some more in [[Mortality and readmission report]]. There seems to be a difference in the concept and exclusions for CC and Med, would it make most sense to have a [[Readmissions in Medicine]] and a [[Readmissions in Critical Care]] page, or are they further uniquely defined per report?
}}
}}


Line 14: Line 22:
{| class="wikitable" border=1  
{| class="wikitable" border=1  
|-  
|-  
! Variable       !!Description!! Data Field !! Data type
! Variable !!Description!! Data Field !! Data type
|-  
|-  
|| D_ID || Unique Record ID || || created
|| D_ID || Unique Record ID || || created
|-  
|-  
|| Person_ID ||Unique Patient ID (computer generated) || || created
|| Person_ID || Unique Patient ID (computer generated) || || created
|-  
|-  
|| RecordStatus || Vetted ||  ||  
|| RecordStatus || Vetted ||  ||  
|-  
|-  
|| 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|| [[LOS]] || created
|-  
|-  
|| CC_Unit_Startdate1 || StartDate1 on the first ICU service|| ||
|| CC_Unit_Startdate1 || StartDate1 on the first ICU service|| ||
|-  
|-  
|| CC_Unit_Startdate2 ||StartDate1 on the second 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_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 || ||
|| CC_Unit2 || The second ICU service  the patient stayed in a continuous ICU episode || ||
|-  
|-  
|| HospitalLocation || Current Hospital and Unit || ||
|| HospitalLocation || Current Hospital and Unit || {{discuss | [[Boarding Loc]]? ||
|-
|-
|| ICU_AdmissionDate || ICU Admission Date_time || ||
|| ICU_AdmissionDate || ICU Admission Date_time || {{Discuss| first [[Service tmp entry]]? ||
|-
|-
|| ICU_DischargeDate || ICU Discharge Date_time ||[[Dispo DtTm]]  ||
|| ICU_DischargeDate || ICU Discharge Date_time || [[Dispo DtTm]]  ||
|-
|-
|| ICU_TransferReadyDate || Transfer Ready Date_time if available || ||
|| ICU_TransferReadyDate|| Transfer Ready Date_time if available || [[Transfer Ready DtTm tmp entry]]||
|-
|-
|| TransferDelay || Difference Between ICU Discharge Date_time and Transfer Ready Date_time ||[[Transfer Delay]]  ||
|| 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 || ||
|| PreInpatientLocation || Previous Inpatient location prior to ICU admission if applicable/available || {{Discuss | is that [[Pre-admit Inpatient Institution]] or [[Previous Location]] or what? }} ||
|-
|-
|| AdmitFromLocation || Previous physical location  prior to ICU admission ||[[Previous Location]] ||
|| AdmitFromLocation || Previous physical location  prior to ICU admission || [[Previous Location]] ||
|-
|-
|| DischToLocation || Location patient went at discharge ||[[Dispo]] ||
|| DischToLocation || Location patient went at discharge || [[Dispo]] ||
|-
|-
|| NextArrival || Next ICU Admission Date_time if available || ||
|| NextArrival || Next ICU Admission Date_time if available || ||
|-
|-
|| Difference || Difference Between  ICU Discharge Date_time and Next Arrival Date_time || ||
|| Difference || Difference Between  ICU Discharge Date_time and Next Arrival Date_time || ||
|-
|-
|| NextHospitalLocation || Location of the Next ICU Admission ||  ||
|| NextHospitalLocation || Location of the Next ICU Admission ||  ||
|-
|-
|| PlannedSurgery || Planned Surgery binary code (Y-yes, N-No) - if yes then readmission=0 || ||
|| PlannedSurgery || Planned Surgery binary code (Y-yes, N-No) - if yes then readmission=0 || {{Discuss | [[Admit Type for APACHE II]]? ||
|-
|-
|| PalliativePatient || Palliative Patient binary code (1-yes, 0-no) - if yes then readmission=0 || ||
|| PalliativePatient || Palliative Patient binary code (1-yes, 0-no) - if yes then readmission=0 || {{Discuss | based on [[DC Treatment]], ICD10 [[Palliative care]] or what? }} ||
|-
|-
|| NextFromLocation || Previous physical location of the Next ICU admission || ||
|| 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) || ||
|| 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) || ||
|| Readmits72hrs || Readmission to ICU within 72 hours after ICU discharged?  binary code (1-yes, 0-no) || [[72hr Readmission Rate to ICU]]||
-}

Revision as of 22:14, 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:
  • 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

-}