CCMDB Wiki

Transfer Ready DtTm field: Difference between revisions

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(132 intermediate revisions by 13 users not shown)
Line 1: Line 1:
''This field is currently being implemented, please check the instructions and put a discussion for anything that isn't clear. ''
{{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]].  


The [[Transfer Ready DtTm field]] contains the date and time that the '''intent to discharge''' a patient to a lower level in the [[#hierarchy of levels of care]] was documented. A "lower level of care" would be from an ICU to a ward, or from ward/ICU to hospital out of town, PCH, care facility or home.
== Purpose ==
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 ==
For each patient,
* if a 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
** if a patient '''arrives transfer-ready''' 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 but the patient probably was transfer ready and it just wasn't documented, enter '''"not available"''' into the "'''TR info status'''" field
This entry has nothing to do with what actually happened to the patient after.


=== hierarchy of levels of care ===
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.
from higher to lower:
* WRHA ICU
* WRHA IICU
* WRHA teaching ward
* WRHA nonteaching ward
* ward outside WRHA
* PCH or home


=== status changing back and forth ===
== Collection Instruction ==
If a patient changes from being transfer ready back to not being transfer ready, collect the '''first''' transfer ready dttm.  
=== Entering a Transfer Ready DtTm ===
Follow the instructions in [[Transfer Ready DtTm tmp entry]].  


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.
{{Collapsable
| always= Before 2020-10-15
| full= 
For each patient,
* 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''' 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 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.
}}
=== What is transfer ready? ===
moved to [[Transfer Ready DtTm tmp entry#Transfer Ready]]


== Data Use ==
=== Hierarchy of levels of care ===
Used to generate [[Transfer_Delay]], which is used in [[Overstay]] and several reports, see also [[Transfer_Delay#data use]].
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.


== {{CCMDB Data Integrity Checks}} ==
=== Collection Start Dates ===
Need to be implemented:
* Critical Care: all units on board June 1, 1999
* Function ''ADT_Chronological()''
* Medicine : all wards on board Jan 1, 2005
* when is it mandatory (not died and not AMA and certain destinations...)
** Temporary Stopped Date in all wards: May 1, 2010 to Nov 30, 2011
** scheduled to discuss at next task meeting. {{discuss@task}} Ttenbergen 16:47, 2016 May 25 (CDT)


== Implementation ==
== Cross Checks ==
no comments
{{Data Integrity Check List}}


== Legacy ==
== Legacy ==
Similar to the old [[Transfer Ready date and time]], but we eliminated special cases and differences between medicine and critical care. Going forward the entry will be collected even if pt dies or goes to ER etc. It's the intent that counts, not what ended up happening.  
Similar to the old [[Transfer Ready date and time]], but we eliminated special cases and differences between medicine and critical care. Going forward the entry will be collected even if pt dies or goes to ER etc. It's the intent that counts, not what ended up happening.  
Resp. field names L_Log.R_TRDate and L_Log.R_TRTime
== Related Articles ==
{{Related Articles}}


[[Category: 2016 Time and Place changes]]
[[Category:2016 Time and Place changes]]
[[Category: Admit/Discharge]]
[[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"