HSC ICUs Data by Patient: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
| Program = Critical Care | | Program = Critical Care | ||
| StartDtTm = Aug 2018 | | StartDtTm = Aug 2018 | ||
| EndDtTm = | | EndDtTm = June 2021 | ||
| Frequency = monthly | | Frequency = monthly | ||
| ContactPerson= Barbara Osorio | | ContactPerson= Barbara Osorio | ||
| Recipients = <names> | | Recipients = <names> | ||
| MailingList = <Outlook list if applicable> | | MailingList = <Outlook list if applicable> | ||
| DataDependencies = | | DataDependencies = 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 | | SASFiles = S:\MED\MED_CCMED\Julie\CC Projects\2021\04_HSC_Osorio | ||
}} | }} | ||
For Decision Support HSC Dashboard | This is not a regularly scheduled report, it is done ad-hoc, but when it is provided one quarter of data is included (unless a specific timeframe is requested). | ||
For Decision Support HSC Dashboard ( incomplete and still in progress ) | |||
{| class="wikitable" border=1 | {| class="wikitable" border=1 | ||
|- | |- | ||
! Variable | ! 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 || [[Service/Location]] || | ||
|- | |- | ||
|| ICU_AdmissionDate || ICU Admission Date_time || || | || ICU_AdmissionDate || ICU Admission Date_time || [[Service tmp entry]] dt/tm || | ||
|- | |- | ||
|| 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 | || TransferDelay || [[Transfer Delay]] - Difference between ICU Discharge Date_time and Transfer Ready Date_time || [[Transfer Delay]] || | ||
|- | |- | ||
|| PreInpatientLocation || | || PreInpatientLocation || Previous Inpatient location prior to ICU admission if applicable/available || [[Pre-admit Inpatient Institution]] || | ||
|- | |- | ||
|| 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 || {{DJ| [[Admit Type for APACHE II]]? || | ||
|- | |- | ||
|| PalliativePatient || Palliative Patient binary code (1-yes, 0-no) - if yes then | || PalliativePatient || Palliative Patient binary code (1-yes, 0-no) - if yes then Readmits48hrs/Readmits72hrs =0 || [[Palliative care]] | ||
|- | |- | ||
|| NextFromLocation || Previous physical location of the Next ICU admission || || | || NextFromLocation || [[Previous Location |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) || [[Readmission Rate to ICU]] || | ||
|- | |- | ||
|| 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) || [[Readmission Rate to ICU]] | ||
-} | |||
Latest revision as of 10:21, 2023 June 12
| Reports | |
| Report: | HSC ICUs Data by Patient |
| StartDtTm: | Aug 2018 |
| EndDtTm: | June 2021 |
| 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 |
This is not a regularly scheduled report, it is done ad-hoc, but when it is provided one quarter of data is included (unless a specific timeframe is requested).
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 | Service/Location | |
| ICU_AdmissionDate | ICU Admission Date_time | Service tmp entry dt/tm | |
| 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 | Pre-admit Inpatient Institution | |
| 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 Readmits48hrs/Readmits72hrs =0 | Palliative care | |
| 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) | Readmission Rate to ICU | |
| Readmits72hrs | Readmission to ICU within 72 hours after ICU discharged? binary code (1-yes, 0-no) | Readmission Rate to ICU
-} |