CCMDB Wiki

Transfer Ready DtTm field: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{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]]
See [[Transfer Ready DtTm tmp entry]]


{{Todo
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]].
| who = Tina
| question =
Once the following query comes up empty this field should be removed from view in [[CCMDB.accdb]]
<code>
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm, Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020# AS filter
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete") AND ((Nz([Accept_DtTm],Nz([arrive_dttm],#1/1/1900#))<=#10/15/2020#)=True)); </code>


* 2021-09-07 - checked query, still 4 profiles
| todo_added = 2021-04-14
| todo_action = 2021-10-01
}}


{{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 [[Level of care hierarchy]] was documented.
| in_table = L_Log table
| data_type = date
| program_collecting = Med and CC
| created_raw = Raw
| data_element_start_date = 2016-07-01
| data_element_end_date = 2020-10-15
| data_element_sort_index = 47
}}


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.  
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.  
Line 40: Line 29:
For each patient,  
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]]
* 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 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, leave the date/time '''empty''' and 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]]'''"  
Line 50: Line 39:
=== Hierarchy of levels of care ===
=== Hierarchy of levels 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.
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.
=== 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


== Cross Checks ==
== Cross Checks ==
Line 61: Line 55:
{{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]]
[[Category:Registry Data]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Transfer_Ready_DtTm_field"