Query check ICD10 awaiting has Transfer Ready DtTm

Data Integrity Checks
Summary:	Any patient who has code in Category:Awaiting/delayed transfer has to have a Transfer Ready DtTm on a different day than their Dispo DtTm.
Related:	Transfer Ready DtTm, [[Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg]], [[Change from Awaiting/delayed dx codes to Transfer Ready DtTm]], [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]], [[Template:ICD10 Guideline AwaitingTransfer]], [[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]], [[Task Team Meeting - Rolling Agenda and Minutes 2021]]
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	Query check_ICD10_awaiting_code_has_Transfer_Ready_DtTm
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-11-24
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Change from Awaiting/delayed dx codes to Transfer Ready DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Template:ICD10 Guideline AwaitingTransfer" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Task Team Meeting - Rolling Agenda and Minutes 2021" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

As per Template:ICD10 Guideline AwaitingTransfer, an awaiting code should be entered if actual discharge is "not on the same calendar day". So, everyone who has an awaiting code has to have Dispo DtTm on different day from Transfer Ready DtTm.

Log

2019-01-22 - added requirement that Transfer Ready DtTm must be on different date than Dispo_DtTm.