CCMDB Wiki

Transfer Ready DtTm field: Difference between revisions

← Older edit
summarized, please have a look to make sure I didn't delete something vital
m Text replacement - "[[Category: " to "[[Category:"
 
(97 intermediate revisions by 12 users not shown)
Line 1: Line 1:
'' see [[Transfer time rule]] for the unrelated rules around patients transferring between wards we collect data on
{{Data element
|field_name=Transfer_Ready_DtTm
|CCMDB_label=Transfer Ready DtTm
|CCMDB_tab=Dispo
|in_table=L_Log table
|data_type=date
|program_collecting=Med and CC
|created_raw=Raw
|data_element_start_date=1999-06-01
|data_element_end_date=2020-10-15
|data_element_sort_index=47
|element_description=Date and time the '''intent to discharge''' a patient to a lower level in the [[Level of care hierarchy]] was documented.
}}
See [[Transfer Ready DtTm tmp entry]]
 
The data in this field will be retained in [[Centralized_data.accdb]]'s [[L_Log table]] since it doesn't follow the same pattern as the new entry. The field no longer exists in [[CCMDB data.mdb]].
 


{{Data_element
| field_name = Transfer_Ready_DtTm
| CCMDB_label = Transfer Ready DtTm
| CCMDB_tab = Dispo
| element_description = Date and time the '''intent to discharge''' a patient to a lower level in the [[#hierarchy of levels of care]] was documented.
| in_table = L_Log
| data_type = date
| program_collecting = Med and CC
| created_raw = Raw
| data_element_start_date = 2016-07-01
| data_element_sort_index = 47
}}
See [[#hierarchy of levels of care]] for meaning of "lower level of care".


== Purpose ==
See [[Transfer Ready DtTm tmp entry]] for what this field is about, or see the history of this page for how it has been used at different times before moving to the new field.  
The purpose is to determine the avoidable days or bed wasted by patients who are deemed ready  to leave the unit or ward and then either move to a lower level of care or leave the hospital.  Bed wasted or avoidable days are being derived from  Transfer Ready DtTm and Discharge Date_time (or Dispo Dt_Tm).


== Collection Instruction ==
== Collection Instruction ==
=== Entering a Transfer Ready DtTm ===
Follow the instructions in [[Transfer Ready DtTm tmp entry]].
{{Collapsable
| always= Before 2020-10-15
| full= 
For each patient,  
For each patient,  
* if a [[#status changing back and forth first]] date/time of '''intent''' to transfer to lower level in the [[#hierarchy of levels of care]] is documented, enter it into the Transfer Ready Date and Time Field
* enter the first date/time of '''intent''' to transfer to lower level in the [[Level of care hierarchy]] is documented into the Transfer Ready Date and Time Field; see [[#status changing back and forth]]
** if a patient '''arrives transfer-ready''' enter the same date into [[Transfer Ready DtTm field]] as in [[Arrive_DtTm field]].
** if a patient '''arrives transfer-ready''' to a [[Level of care hierarchy | lower level]] of care '''than ''the current'' ward''' enter the same date into [[Transfer Ready DtTm field]] as in ''Arrive_DtTm field''.
* if not available because the patient was '''clearly not transfer ready''', leave the date/time '''empty''' and enter "'''not transfer ready'''" into the "'''[[TR info status field]]'''"
* if not available because the patient was '''clearly not transfer ready''', leave the date/time '''empty''' and enter "'''not transfer ready'''" into the "'''[[TR info status field]]'''"
* if not available but the patient probably was transfer ready and it just wasn't documented, enter '''"not available"''' into the "'''[[TR info status field]]'''"  
* if not available but the patient probably was transfer ready and it just wasn't documented, leave the date/time '''empty''' and enter '''"not available"''' into the "'''[[TR info status field]]'''"  
This entry is about the time of an '''intent''', nothing to do with what '''actually happened''' to the patient after.
This entry is about the time of an '''intent''', nothing to do with what '''actually happened''' to the patient after.
 
}}
=== what is transfer ready? ===
=== What is transfer ready? ===
Any of:
moved to [[Transfer Ready DtTm tmp entry#Transfer Ready]]
* "medically stable" written anywhere in the chart
* care is stepped down e.g. vital signs decreased, off monitor, IV meds changed to PO meds
* patient is made ACP-C in ICU, regardless of whether they or not they are still intubated and ventilated
* date and time that the IICU consult is written for patient going to [[HSC_IICU]]
 
* A deconditioned patient may still be medically stable if they can re-condition elsewhere; use your judgement.


=== Hierarchy of levels of care ===
=== Hierarchy of levels of care ===
We require an entry in this field when the transfer is from higher to lower level of care:
We require an entry in this field when the intent is to transfer from higher to lower level of care. See [[Level of care hierarchy]] for a list.
* WRHA ICU
* WRHA IICU
* WRHA HOB ward
* WRHA teaching ward
* WRHA nonteaching ward / EMIP
* ward outside WRHA
* PCH or home
 
=== ACP C ===
*A patient is transfer ready on Medicine or ICU once they become ACP-C  (decided at Task Group Meeting on Jan 18, 2016).
 
=== status changing back and forth ===
If a patient changes from being transfer ready back to not being transfer ready, collect the '''first''' transfer ready dttm.  


There used to be different instructions for Medicine and Critical Care but they are being unified with the move to the new fields as discussed with Dr. Garland, Dr. Roberts and Randy Martin.
=== Collection Start Dates ===
* Critical Care: all units on board June 1, 1999
* Medicine : all wards on board Jan 1, 2005
** Temporary Stopped Date in all wards: May 1, 2010 to Nov 30, 2011


== Data Use ==
== Cross Checks ==
Used to generate [[Transfer_Delay]], which is used in [[Overstay]] and several reports, see also [[Transfer_Delay#data use]].
{{Data Integrity Check List}}
 
== {{CCMDB Data Integrity Checks}} ==
* [[Function Dispo Chronological()]]
* function ''Panelling_admit_transfer_same(Pat_ID)'': a record is an error if both
** [[Primary Admit Diagnosis]] = [[Panelling or Discharge Planning]] (90601 or 90602)
** ([[Transfer Ready DtTm]]) <> ([[Arrive DtTm]])
* query ''check_dispo_lower_acuity_than_location'' and function ''Transfer_Ready_DtTm_vs_Location_vs_Dispo'' check for patients going to lower level of care but without Transfer Ready Date; Check will launch an error but allow no date, ie it's just a reminder, see [[#hierarchy of levels of care]].


== Legacy ==
== Legacy ==
Line 67: Line 52:
Resp. field names L_Log.R_TRDate and L_Log.R_TRTime
Resp. field names L_Log.R_TRDate and L_Log.R_TRTime


[[Category: 2016 Time and Place changes]]
== Related Articles ==
[[Category: Admit/Discharge]]
{{Related Articles}}
[[Category: Transfer Ready]]
 
[[Category: Data Collection Guide]]
[[Category:2016 Time and Place changes]]
[[Category: Registry Data]]
[[Category:Admit/Discharge]]
[[Category: Transfer Ready|*]]
[[Category:Transfer Ready]]
[[Category:Registry Data]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Transfer_Ready_DtTm_field"