CCMDB Wiki

Transfer Ready DtTm field: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(11 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>


* 2022-04-19 pt is on Brynn's laptop; Lisa agreed that Brynn would look into thinned chart to see if we can clear this up
* 2022-04-14 checked again, still there; H7_HSC_IICU-3097 was discharged over a year ago, emailed Lisa
* 2022-02-10 checked, one record left and it has dispo dttm H7_HSC_IICU-3097; something seems odd about that one, so look into if still present in a month
| todo_added = 2021-04-14
| todo_action = 2022-03-10
}}


{{Todo
| who = Tina
| todo_added = 2022-04-26
| todo_action = 2022-04-26
| question =  _dev_CCMDB_sending
* remove from sending, and then from 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 [[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 60: 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 71: 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"