HSC ICUs Data by Patient: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
(3 intermediate revisions by one other user not shown) | |||
Line 7: | Line 7: | ||
| Recipients = <names> | | Recipients = <names> | ||
| MailingList = <Outlook list if applicable> | | MailingList = <Outlook list if applicable> | ||
| DataDependencies = | | 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 = | | 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= | {{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? | ||
}} | }} | ||
For Decision Support HSC Dashboard ( incomplete and still in progress ) | |||
{| 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|| [[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 || {{discuss | [[Boarding Loc]]? || | |||
|- | |||
|| ICU_AdmissionDate || ICU Admission Date_time || {{Discuss| 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 || {{Discuss | is that [[Pre-admit Inpatient Institution]] or [[Previous Location]] or what? }} || | |||
|- | |||
|| 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 || {{Discuss | [[Admit Type for APACHE II]]? || | |||
|- | |||
|| 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 || || | |||
|- | |||
|| 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]]|| | |||
-} |
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 |
|
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 |
| ||
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 |
| ||
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 |
-} |