Transfer Delay: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Julie replied in email, integrated answer here.
removed details from here since the two concepts have evolved apart again
 
(29 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Data_element
== More Info ==
| field_name = Transfer Delay
* Transfer Delay is reported as one of the following [[Indicators]], see those pages for how specifically it is used there.  
| element_description =  '''Transfer Delay''' is the difference between [[Dispo_DtTm]] and [[Transfer_Ready_DtTm]] in decimal days.
** [[Transfer Delay (Critical Care)]]
| in_table = Created_variables_common table
** [[Transfer Delay (Medicine)]]
| data_type = number
| datafield_length = single
| program_collecting = Med and CC
| created_raw = Created
| data_element_sort_index = 7
| data_element_start_date = 1999-01-15}}
 
It's is calculated by [[created_variables_common_maker query|''created_variables_common_maker'' query]] and stored in [[created_variables_common table |''created_variables_common'' table]] in [[CFE]].
 
We report the following in days:
*'''Transfer Delay Over 2 hours for Critical Care''' (ie subtract 2 hrs from transfer delay)
*'''Transfer Delay Over 4 hours for Medicine''' (ie subtract 2 hrs from transfer delay)
 
==Start Date==
* ICU  (see infobox)
* Medicine - Oct 1, 2003
 
== data use ==
* Quarter and Fiscal Year Reports of both Critical Care and Medicine Programs
* Medicine [[Overstay]] Project
* Critical Care Vital Sign Monitor Project
* Critical Care Quality Improvement Team
* [[Avoidable Days in ICU]]
 
== IICU and H6 Reporting ==
For the ICU annual and quarter  reports, the transfer ready delay to the IICU and to [[HSC H6]] (LTV)  will be reported separately from the transfer delay to the other Wards and home.  This imply that in addition to the total transfer delay, there will be two more derived delay variables, namely:
# to HSC IICU/H6, and
# to other wards/Home (including nursing home/long term care facility)
The 'discharge to location' will be used to define the destination. As per Dr. Garland & Dr.Paunovic.  
 
== Calculation when transfer time missing ==
The following definitions are used by Julie in reporting from SAS, and by [[centralized_data_front_end.accdb]] to calculate the created_variables query.
 
For Critical Care
    if discharge time  < 1000 HR then dummy=0001 HR (12:01 am),
    else if discharge time  >=  1000 HR dummy=1000HR  (10:00 am)
 
This is based on [[:Category:CCVSM|Critical Care Vital Monitor rule]].
 
For Medicine,
    if discharge time  < 1200 HR then dummy=0001 HR (12:01 am) ,
    else if discharge time  >=  1200 HR dummy=1200HR  (12:00 noon)
 
This is as per approval by  Dr. Roberts .
 
== Data Integrity Checks ==
{{Data Integrity Check List}}
 
== related fields ==
* [[Arrive_DtTm]]  
* [[Dispo_DtTm]]
* [[LOS]]
* [[Transfer Delay]]


== Related Articles ==
== Related Articles ==
Line 61: Line 8:




[[Category: Reporting]]
[[Category:Reporting]]
[[Category: Admit/Discharge]]
[[Category:Admit/Discharge]]
[[Category: Transfer Ready]]
[[Category:Transfer Ready]]
[[Category: CCVSM]]
[[Category:Dispo]]
[[Category: Dispo]]
[[Category:2016 Time and Place changes]]
[[Category: 2016 Time and Place changes]]
[[Category:Length of stay]]
[[Category: Length of stay]]
[[Category:Created Variables]]

Latest revision as of 08:33, 20 April 2023