Transfer Ready DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Text replacement - "[[Category: " to "[[Category:"
 
(63 intermediate revisions by 5 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 table
| 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 ==
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).


At the 11Sept2017 Steering Committee meeting, it was clarified that what is being sought here is the INTENT to send someone to a lower level of care only. Thus, it doesn’t matter what actually happened after this intent occurs (e.g. patient getting sicker and the transfer intent cancelled).
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.  


== 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,  
* enter the first date/time of '''intent''' to transfer to lower level in the [[#hierarchy of levels of care]] 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 [[#hierarchy of levels of care | lower level]] of care '''than ''your'' 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]]'''"  
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 these criteria, for a patient going to a '''lower''' level of care, as per hierarchy below:
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 or not they are still intubated and ventilated
{{discussion}} If patient died shortly in ICU after declaring ACP-C, say <2 hrs or within 2-4 hrs or within a day),is transfer ready needed? Or is there a cut-off time? --[[User:JMojica|JMojica]] 12:25, 2018 August 9 (CDT)
* I don't think it should matter how much time between the ACP-C designation and the death.  Why would that matter?  I think we should stick with the rule of all ACP-C patients are transfer ready. This is my opinion on this.--[[User:LKolesar|LKolesar]] 13:08, 2018 August 9 (CDT)
** Julie, what made you ask? For the most part we build our instructions on how you use the data, and what kind of requests you get, so how does that figure in with this? Ttenbergen 16:22, 2018 August 13 (CDT)
 
* 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.
 
* if criteria are otherwise met but need a sitter or some other level of care the the ward can't provide is required then the patient is still considered transfer ready


=== 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, same level of care includes: MICU, SICU, CICU, ACCU, CCU
* Other MB RHA ICU or Other Province ICU <!--(confirmed by Dr. Allan Garland 2Oct2017)-->
* WRHA IICU
* WRHA HOB ward
* "ward" - the following are all considered the same level of care
** WRHA teaching ward
** WRHA non-teaching ward / EMIP
** residents may set patients to be "non-teaching" because their quota is filled - see [[#pt becoming non-teaching is not a reason to consider transfer ready]] for details
** WRHA sub-acute medicine ward (family medicine service)
** WRHA transitional care ward (family medicine service)
* ward outside WRHA
* PCH or home


{{Discussion}} would need to be reconciled as part of [[Eliminating distinction between different ward types]]
=== 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


=== ACP C ===
== Cross Checks ==
A patient is transfer ready on Medicine or ICU once they become ACP-C  <!--(decided at Task Group Meeting on Jan 18, 2016). -->
{{Data Integrity Check List}}
 
=== 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.
 
=== pt becoming non-teaching is not a reason to consider transfer ready ===
* @ HSC we no longer consider patients who are made non-teaching as "transfer ready". This is because residents routinely change patients from "teaching" to "non-teaching" when their quota of patients is filled. The patient moves to non-teaching status under the staff man but are routinely changed back to teaching once discharges occur.--[[User:CMarks|CMarks]] 13:56, 2017 October 3 (CDT)
** StB B5 NTU routinely admits Nephrology NT Service patients as well as lateral transfers such as HSC, as identified above, but does not transfer them back to a CTU. Instead the teaching unit Doctors follow the patient on the NT ward they are admitted to.[[User:ENagy|ENagy]] 14:12, 2017 October 6 (CDT)E.Nagy
*** {{discussion}} Is this only for HSC? Probably not, right? if not the HSC part above should come out and the direction for this be made generic. Does this really point to a general lack of distinction between teaching and non-teaching? If so, do we need to adjust other processes about this? Ttenbergen 08:54, 2018 June 7 (CDT)
 
{{Discussion}} would need to be reconciled as part of [[Eliminating distinction between different ward types]]
 
== Data Use ==
Used to generate [[Transfer_Delay]], which is used in [[Overstay]] and several reports, see also [[Transfer_Delay#data use]].
 
== Data Integrity Checks ==
* [[Function Dispo Chronological()]]
* [[Query check long transfer delay]]
 
== {{CCMDB Data Integrity Checks|needs review}} ==
* 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]].
** {{Discussion}} would need to be reconciled as part of [[Eliminating distinction between different ward types]]


== Legacy ==
== Legacy ==
Line 93: 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: Data Collection Guide]]
[[Category: Registry Data]]
[[Category: Transfer Ready| *]]

Latest revision as of 12:10, 30 July 2025

 
 
 
 

Legacy Content

This page contains Legacy Content.

  • Explanation: This is a legacy data field, its DataElementEndDate is in the past.
  • Successor: No successor was entered

Click Expand to show legacy content.

Data Element (edit)
Field Name: Transfer_Ready_DtTm
CCMDB Label: Transfer Ready DtTm
CCMDB tab: Dispo
Table: L_Log table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 1999-06-01
End Date: 2020-10-15
Sort Index: 47
Data Dependencies(Reports/Indicators/Data Elements): No results

Date and time the intent to discharge a patient to a lower level in the Level of care hierarchy was documented.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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.


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.

Collection Instruction

Entering a Transfer Ready DtTm

Follow the instructions in Transfer Ready DtTm tmp entry.

Before 2020-10-15   

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 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

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.

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

Data Integrity Checks (automatic list)

 AppStatus
Check Function Panelling admit transfer sameCCMDB.accdbretired
Query check dispo lower acuity than locationCCMDB.accdbretired
Link suspect transfer ready before arrive dateCentralized data front end.accdbretired

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. Resp. field names L_Log.R_TRDate and L_Log.R_TRTime

Related Articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Transfer_Ready_DtTm_field&oldid=166914"