Transfer Ready DtTm tmp entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 67: Line 67:
{{Related Articles}}
{{Related Articles}}


== Legacy ==
{{LegacyContent
|explanation= legacy
|content=
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.
 
Resp. field names L_Log.R_TRDate and L_Log.R_TRTime
}}


[[Category:Transfer Ready| *]]
[[Category:Transfer Ready| *]]

Revision as of 17:05, 2021 January 21

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

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

  • Use tmp fields:
    • Project: Transfer Ready DtTm
    • Item: Transfer Ready DtTm
    • Transfer Ready Date: Date as defined in Transfer Ready DtTm, under column E.
    • Transfer Ready Time: Time as defined in Transfer Ready DtTm, under column M.
    • checkbox: to be checked only if a transfer ready date never became available
    • comment (under 'q'): only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.

initial pre-entered record

A first entry is added automatically to each new patient entered on the laptop.

If a transfer date never becomes available, 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 moves to a unit with a different level of care (either stays in your collection or not) and you are sure a date never became available.

The first time the patient becomes transfer ready, enter the date and time into this pre-entered record. Don't check the checkbox in this case, since the patient is transfer ready.


additional records if there are additional Boarding Locs

If, after this initial entry, the patient moves to a physical location (ie new entry in Boarding Loc that has a different level in the Level of care hierarchy, then:

  • leave the original line as is
  • enter a new Transfer Ready DtTm tmp entry, either without a date (for now), or if a new transfer ready date from the new level of care is known by the time you enter this, enter the new date and time

Then either check the box on the new line when you finally complete the patient, or lather rinse repeat.

We do not need a new record for every move, just for moves to a higher or lower level in the Level of care hierarchy. We need this for moves to a higher level as well because once a patient actually moves to a higher level of care, the original determination that they were transfer ready almost certainly is no longer valid.

  • How about the original ER entry - that is a high level of care location, but would we expect someone to become transfer ready there and then still move to the ward? Probably not. I'd say no entry for that part, but should see what Julie has to say. Ttenbergen 15:16, 2020 October 16 (CDT)
  • SMW


  • Cargo


  • Categories

is a time needed for all?

  • Should we be entering a date/TM for every entry? the reason I ask is because if we check off B and put not transfer ready in column Q, we often have multiple entries, How will Julie know which boarding LOC is associated with each transfer ready entry without a date? Lisa Kaita 10:14, 2020 October 20 (CDT)
    • You could only enter a date if they were transfer ready, so Julie would still not be able to link unready ones. And maybe that's OK, since unready ones wouldn't contribute to wasted beds. But we need to ask Julie. Ttenbergen 15:58, 2021 January 21 (CST)
  • SMW


  • Cargo


  • Categories

This entry is about intent

  • This is my dilemma with our definition, it is the intent which I cannot qualify thru the data. if I see an entry in transfer ready date but the physical transfer location is the same or higher level of care, I have to consider that transfer ready date to be valid. I rely that the entry is correct. I rather have the definition to be consistent with the level of care (except for Deaths) so I can quality check the transfer date entry and remove the intent as part of the definition. The goal is to measure bed wastage and when the patient moves to the same or higher level of care, that is not bed wastage to me. --JMojica 10:18, 2020 October 16 (CDT)
    • 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. The only way this makes sense is if it is done by intent. Ttenbergen 15:16, 2020 October 16 (CDT)}}

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. This is used as part of the concept Avoidable Days in ICU.

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

Transition to new way of entering this

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

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

Data Use

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

SAS Program

Background

Related articles

Related articles: