Transfer Ready DtTm tmp entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 21: Line 21:
***order is written to change all iv meds to po AND remove monitoring
***order is written to change all iv meds to po AND remove monitoring
***patient is made '''[[ACP C|ACP-C]]'''
***patient is made '''[[ACP C|ACP-C]]'''
***BUT in the absence of some clear indication (a discharge order, or a progress note, or one of the 2 items immediately above), do NOT try to guess at the transfer ready timing.  For example, if there is no such order, and no note saying that the patient was ready to leave, but the patient was discharged, in this case assign the transfer ready timing as the actual discharge timing.
***BUT in the absence of some clear indication (a discharge order, or a progress note, or one of the 2 items immediately above), do NOT try to guess at the transfer ready timing.  For example, if there is no such order, and no note saying that the patient was ready to leave or ready for transfer to a lower level of care, but the patient was discharged or transferred, in this case assign the transfer ready timing as the actual [[Dispo DtTm]] or the date and time of the next [[Boarding Loc]]


{{DA| in these instructions we are told to put the date and time of discharge if there is nothing written, no order etc, we have been following this rule at HSC, and If pt never becomes [[#Transfer Ready]], check the checkbox to say so. This is so we can be sure the entry wasn't just forgotten, we have been following this rule as well, but then further down it says- checkbox checked that a transfer ready status was never documented for this patient while at this [[Boarding Loc]] So there is confusion around how to use the check box. 
* example for HSC- pt goes from ER to H4 to H7S back to H4, we would check the checkbox for the ER and the first H4 boarding locs, we would have a date and time for the HOBS (if one is written) if not we would put the date and time of transfer to H4, and for the final boarding loc we would put the date and time if documentation supports this, if no documentation, we would put the date and time of discharge.  We only use the checkbox if a patient was never transfer ready.  We need to tweak these instructions so there is less confusion [[User:Lkaita|Lisa Kaita]] 07:47, 2022 May 5 (CDT)
** as far as the calculation of transfer delay is concerned, in this example, both your way (i.e.  entering the TR the same as transfer dttm to next location)  and the other way (i.e. checkbox marked)  achieved the SAME transfer delay which is ZERO since the patient left their current location to go to a lower level of care. However, if all the Med boarding locations are of the  same level of care, the transfer delay is calculated from the '''First TR''' to Dispo dttm  - so if the first boarding loc has NO transfer dttm  written but DC entered the TR as the transfer dttm to next boarding loc, then that TR will be chosen to calculate transfer delay even though the patient is really not transfer ready yet and this is incorrect. --[[User:JMojica|JMojica]] 10:10, 2022 May 5 (CDT)  }}


*Special Note regarding Transfer Ready from a ward: Before going home, some ward patients get a home safety evaluation from PT and OT, and if deemed safe for home get a homecare evaluation before going home.
*Special Note regarding Transfer Ready from a ward: Before going home, some ward patients get a home safety evaluation from PT and OT, and if deemed safe for home get a homecare evaluation before going home.
Line 38: Line 34:
***  Collector needs to enter one of the following:
***  Collector needs to enter one of the following:
**** '''First''' Date and Time during the stay '''at this [[Boarding Loc]]''' that patient was transfer ready as per [[#What is Transfer Ready]] above; '''do not "carry forward" a transfer ready from any prior [[Boarding Loc]]'''
**** '''First''' Date and Time during the stay '''at this [[Boarding Loc]]''' that patient was transfer ready as per [[#What is Transfer Ready]] above; '''do not "carry forward" a transfer ready from any prior [[Boarding Loc]]'''
***** i.e. this is the '''transition''' to transfer ready, so if they arrived already transfer ready at a [[Boarding Loc]] you should ''not'' enter the start of that [[Boarding Loc]] and instead click the checkbox, or the date of a subsequent new first transfer ready status at this second [[Boarding Loc]]
***** i.e. this is the '''transition''' to transfer ready, so if they arrived already transfer ready at a [[Boarding Loc]] you should ''not'' enter the start of that [[Boarding Loc]] and instead enter the date of a subsequent new first transfer ready status at this second [[Boarding Loc]]
::OR
::OR
:::* checkbox checked that a transfer ready status was never documented for this patient while at this [[Boarding Loc]]
:::* checkbox checked if the patient is not transfer ready (ie. moves to a higher level of care)
:::** exception shown below in  Patient left from HOBS or Last boarding loc to lower level of care without clear documentation of  [[#Transfer Ready]]
:: OR
:::if there is no clear [[Transfer Ready DtTm]] enter the [[Dispo DtTm]] if discharged from hospital or use the date and time of the subsequent [[Boarding Loc]] if transferred to a lower level of care.
 
{{Ex| Mr Jones went from MICU to SICU.  In MICU he was transfer ready but at no time after transfer did the team caring for him in the SICU write that he was transfer ready.  Thus he will have a transfer ready date/time from the MICU boarding loc, but not from the SICU boarding loc.}}
{{Ex| Mr Jones went from MICU to SICU.  In MICU he was transfer ready but at no time after transfer did the team caring for him in the SICU write that he was transfer ready.  Thus he will have a transfer ready date/time from the MICU boarding loc, but not from the SICU boarding loc.}}


Line 49: Line 47:
* If pt never becomes [[#Transfer Ready]], check the checkbox to say so. This is so we can be sure the entry wasn't just forgotten.  
* If pt never becomes [[#Transfer Ready]], check the checkbox to say so. This is so we can be sure the entry wasn't just forgotten.  
* Don't check this until the patients actually leaves that [[Boarding Loc]] (either to a next one or to [[Dispo]]) and you are sure a date never became available.
* Don't check this until the patients actually leaves that [[Boarding Loc]] (either to a next one or to [[Dispo]]) and you are sure a date never became available.
=== Patient left from HOBS or Last boarding loc to lower level of care without clear documentation of  [[#Transfer Ready]] ===
 
* If during the same admission, from Med '''HOBS''' ward, the patient moves to a '''regular''' Med ward  with no clear documentation  of [[#Transfer Ready]], enter the  [[#Transfer Ready]] the same as the transfer date and time to that next regular ward and enter the same integer as  HOBS.
* If there is no clear documentation  of [[#Transfer Ready]] of same level of care  until the '''last''' [[Boarding Loc]] and the patient  left the ward/unit to a lower level of care as shown in the [[Dispo field]], enter the  [[#Transfer Ready]] the same as the [[Dispo DtTm]] and enter the same integer as the last boarding loc.


=== Transfer ready to serveral different lower levels of care ===
=== Transfer ready to serveral different lower levels of care ===

Revision as of 13:27, 2022 May 6

Projects
Active?: active
Program: CC and Med
Requestor: internal
Collection start: 2020-10-15
Collection end:

Collection instructions

What is Transfer Ready

  • The status of "transfer ready" is about the date/time of an intent to transfer a patient to LOWER level of care in the Level of care hierarchy if there was an available bed there. Whether or not the patient actually moves does not matter, just that at some point there was an intent to move the pt. It also does not matter whether after such a determination the care team changed their minds about such a desired transfer.
  • Obviously we don't always know the team's intentions, but if they do write them down, then use that info.
    • In making this delineation, except as for the exceptions listed immediately below, only consider a clearly written intent that the team now desires the patient to be transferred to such a lower level of care.
      • In particular, when a ward patient is transferred (e.g. home) without any notes stating the team’s intention to do so in advance or even an order to discharge, collectors should not attempt to make educated guesses from the notes of when the patient was probably clinically ready to leave.
  • EXCEPTIONS:
    • In an ICU, take the following to indicate transfer ready to a lower level of care even if they have not written that explicitly:
      • care is stepped down to ward frequency (q4hrs or less) of vitals AND off all forms of life support except possibly intermittent dialysis
      • HSC_IICU consult is written
      • patient is made ACP-C
    • In a ward, take the following to indicate transfer ready to a lower level of care even if they have not written that explicitly:
      • order is written to change all iv meds to po AND remove monitoring
      • patient is made ACP-C
      • BUT in the absence of some clear indication (a discharge order, or a progress note, or one of the 2 items immediately above), do NOT try to guess at the transfer ready timing. For example, if there is no such order, and no note saying that the patient was ready to leave or ready for transfer to a lower level of care, but the patient was discharged or transferred, in this case assign the transfer ready timing as the actual Dispo DtTm or the date and time of the next Boarding Loc


  • Special Note regarding Transfer Ready from a ward: Before going home, some ward patients get a home safety evaluation from PT and OT, and if deemed safe for home get a homecare evaluation before going home.
    • The transfer ready date/time in such a situation should be only after the PT/OT evaluation has deemed them safe to go home, i.e. before homecare has seen them. The rationale is that homecare evaluation can occur after discharge, but a hospitalized patient who “fails” their home safety evaluation will end up going to LTC, not home.

Data entry instructions

  • A "Transfer Ready" line is automatically created for each Boarding Loc entry.
    • Project: Transfer Ready DtTm
    • Item: the only available item is "Transfer Ready DtTm", just like the project entry.
    • Date and Time vs checkbox:
      • Collector needs to enter one of the following:
        • First Date and Time during the stay at this Boarding Loc that patient was transfer ready as per #What is Transfer Ready above; do not "carry forward" a transfer ready from any prior Boarding Loc
          • i.e. this is the transition to transfer ready, so if they arrived already transfer ready at a Boarding Loc you should not enter the start of that Boarding Loc and instead enter the date of a subsequent new first transfer ready status at this second Boarding Loc
OR
  • checkbox checked if the patient is not transfer ready (ie. moves to a higher level of care)
OR
if there is no clear Transfer Ready DtTm enter the Dispo DtTm if discharged from hospital or use the date and time of the subsequent Boarding Loc if transferred to a lower level of care.
Example:   
Mr Jones went from MICU to SICU.  In MICU he was transfer ready but at no time after transfer did the team caring for him in the SICU write that he was transfer ready.  Thus he will have a transfer ready date/time from the MICU boarding loc, but not from the SICU boarding loc.

Combining Transfer Ready DtTm tmp entry and Boarding Loc records

There needs to be one Transfer Ready DtTm tmp entry for each Boarding Loc and vice versa. To mark which entries belong together, use the same integer number in the "combiner" field in Patient Viewer Tab Cognos ADT2 for both records and in sequential order according to Boarding start_dt and start_tm. The presence of matching records is validated by query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm, and their sequential status by query s_tmp_check_combined_BL_and_TRDtTm_nonsequential.

Patient doesn't become #Transfer Ready before leaving unit

  • If pt never becomes #Transfer Ready, check the checkbox to say so. This is so we can be sure the entry wasn't just forgotten.
  • Don't check this until the patients actually leaves that Boarding Loc (either to a next one or to Dispo) and you are sure a date never became available.


Transfer ready to serveral different lower levels of care

  • If there is clearly written as transfer-ready to a lower level, and then while in the same location he/she is written as transfer-ready to an even lower level of care, only enter the first date and time.

What if the pt ends up transferred to a higher level of care

The original Transfer Ready DtTm tmp entry does not change. We want the first one one only.

Expand for details why   
  • It might seem that a patient who was transfer ready but then moves to a higher level of care should be excluded, since they did not actually get transferred to a lower level of care. However, when the patient was deemed transfer ready, additional time in the ward was "wasted time" - if we could have sent them elsewhere we would have. If the patient later crashes, that doesn't make it not-wasted time - they could have crashed anywhere. So the interpretation that a pt moving to a higher level of care after transfer ready is not wasted time is not right. We discussed this repeatedly at task and steering meetings. The only way this makes sense is if it is done by intent.

After discussion with medicine, Allan reported back that they want the 'first medically stable only (Task Team Meeting - Rolling Agenda and Minutes 2021#ICU Database Task Group Meeting – June 15, 2021).

Start DtTm/Legacy

We used the old Transfer Ready DtTm field for transfer ready dttms before 2020-10-15, and use this new entry for dttms after.

Data Use / Purpose

Critical care and Medicine programs want to know this to better understand patient flow and bed utilization.

Used to generate Transfer_Delay and Avoidable Days (Critical Care).

Background

This isn't so much a project as a change to Transfer Ready DtTm collection to allow us to collect more than one Transfer Ready DtTm per patient-program-stay. See Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry for why we needed to change to this.

Data Integrity Checks (automatic list)

 AppStatus
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysCCMDB.accdbdeclined
Query check TISS each dayCCMDB.accdbdeclined
Query check ICD10 awaiting has Transfer Ready DtTmCCMDB.accdbimplemented
Query check transfer DtTm during admissionCCMDB.accdbimplemented
Query check has transfer ready date or checkboxCCMDB.accdbimplemented
Query s tmp check combined Boarding Loc and TransferReadyDtTmCCMDB.accdbimplemented
Query s tmp check Boarding Loc and TransferReadyDtTm pairsCCMDB.accdbimplemented
Query check Transfer DtTm after paired BL and before later BLCCMDB.accdbimplemented
Query Check BL TR combiner nullCCMDB.accdbimplemented
Query check tmp 2 BL TR S same tmCCMDB.accdbimplemented
Query check long transfer delayCCMDB.accdbneeds review
Function Validate Transfer Ready DtTmCCMDB.accdbretired
Function Transfer Ready DtTm vs statusCCMDB.accdbretired
Query check transfer ready tmp for each Boarding LocCCMDB.accdbretired
Query check tmp Transfer Ready not before Boarding LocCCMDB.accdbretired
Query s tmp check combined BL and TRDtTm nonsequentialCCMDB.accdbretired

Log

2021-07-08 - Change from Awaiting/delayed dx codes to Transfer Ready DtTm for data back to 2021-07-01

Legacy

Similar to the old Transfer Ready DtTm field and Transfer Ready date and time, but we eliminated special cases and differences between medicine and critical care.

Related articles

Related articles: