Transfer Delay (Critical Care)

From CCMDB Wiki
Jump to navigation Jump to search

Transfer Delay is the difference between Dispo_DtTm and #Transfer Ready DtTm in use at different times in decimal days.

Indicators
Indicator: Transfer_Delay_CC
Created/Raw: created
Program: Critical Care and Medicine
Start Date: 1999-01-15
End Date:
Reports: Critical Care Program Quality Indicator Report, Directors Quarterly and Annual Report (Critical Care), HSC ICUs Data by Patient


  • Cargo


  • SMW:
    • "created" is not in the list (Created, Raw) of allowed values for the "IndicatorCreatedRaw" property.
  • Categories
  • Default form:

There is a similar concept in medicine, Transfer Delay (Medicine).

It is stored in the Transfer_Delay_CC field in Created_Variables_CC_2021 table.

Use

Transfer Ready DtTm in use at different times

Admit DtTm or Dispo DtTm < 2020-10-01 00:00

Calculation for reporting when transfer time missing

Before Oct 1,2020 -The following definitions are used by Julie in reporting from SAS, and by centralized_data_front_end.accdb to calculate the created_variables query.

  • if discharge time < 1000 HR then dummy=0001 HR (12:01 am),
  • else if discharge time >= 1000 HR dummy=1000HR (10:00 am)

This was based on Critical Care Vital Sign Monitor.

This is as per approval by Dr. Dan Roberts.

Starting Oct 1,2020, transfer ready time is always present.

  • Discussed with Julie that we will actually update these in the data rather than do these updates at reporting time. The query below should do it. Pagasa, could you apply it when you get a chance and update here when done? Thanks! Ttenbergen 09:46, 2022 June 29 (CDT)
    • Emailed reminder to Pagasa. Ttenbergen 10:52, 2022 September 8 (CDT)
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Not tested yet, but the code to update this would be something like

Update L_Log
SET L_Log.Transfer_Ready_DtTm = [Transfer_Ready_DtTm]+IIf(TimeValue([Dispo_DtTm])<#12/30/1899 10:0:0#,#12/30/1899 12:1:0#,#12/30/1899 10:0:0#)
WHERE (((TimeValue(Nz([Transfer_Ready_DtTm],#12/30/1899 0:1:0#)))=#12/30/1899#));

Admit DtTm or Dispo DtTm >= 2020-10-01 00:00

Background

Why collect per boarding loc when we only report per admission?

To make it easier for data collectors. This way, collectors don't have to try and go back and figure out if there was or was not a transfer ready in a prior location. They only need be concerned about the notes and orders from THIS boarding loc.

Reporting of Transfer Delays

  • Include all cases with transfer ready dttm (who went to same/lower/higher level of care or died).
  • Refer to the following indicators:
  1. Avoidable Days
  2. Beds occupied by transferrable patients

IICU and H6 Reporting

For the ICU annual and quarter reports, the transfer ready delay to the IICU and to HSC H6 (LTV) are reported separately from the transfer delay to the other Wards and home. Thus two derived delay variables, namely:

  1. to HSC IICU/H6, and
  2. to other wards/Home (including nursing home/long term care facility)

The Dispo location will be used to define the destination. As per Dr. Garland & Dr. Paunovic.

SAS Program

  • S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\logphi_TR.sas
    • macro %CC_tready
  • S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer.sas (macro %boardtransf)

Data use

Data Integrity Checks (automatic list)

 AppStatus
Query check long transfer delayCCMDB.accdbneeds review

related fields

Related Articles

Related articles:

Legacy

Legacy Content

This page contains Legacy Content.
  • Explanation: xxx
  • Successor: No successor was entered