Transfer Ready DtTm tmp entry

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 to GRA Med, HSC Med, STB Med Service Location for why we needed to change to this.

Transition to new way of entering this

Transfer Ready DtTms before 2020-10-15 should be entered using the old field, any Transfer Ready DtTms starting 2020-10-15 midnight should be entered into the new tmp entry.

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: only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.

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.

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 line, 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.

Data Integrity Checks (automatic list)

	App	Status
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days	CCMDB.accdb	declined
Query check TISS each day	CCMDB.accdb	declined
Query check ICD10 awaiting has Transfer Ready DtTm	CCMDB.accdb	implemented
Query check transfer DtTm during admission	CCMDB.accdb	implemented
Query check has transfer ready date or checkbox	CCMDB.accdb	implemented
Query s tmp check combined Boarding Loc and TransferReadyDtTm	CCMDB.accdb	implemented
Query s tmp check Boarding Loc and TransferReadyDtTm pairs	CCMDB.accdb	implemented
Query check Transfer DtTm after paired BL and before later BL	CCMDB.accdb	implemented
Query Check BL TR combiner null	CCMDB.accdb	implemented
Query check tmp 2 BL TR S same tm	CCMDB.accdb	implemented
Query check long transfer delay	CCMDB.accdb	needs review
Function Validate Transfer Ready DtTm	CCMDB.accdb	retired
Function Transfer Ready DtTm vs status	CCMDB.accdb	retired
Query check transfer ready tmp for each Boarding Loc	CCMDB.accdb	retired
Query check tmp Transfer Ready not before Boarding Loc	CCMDB.accdb	retired
Query s tmp check combined BL and TRDtTm nonsequential	CCMDB.accdb	retired

Data Use

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

SAS Program

Background

Related articles