Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days

Data Integrity Checks
Summary:	Any patient with a with Transfer Ready DtTm and Dispo DtTm on different days has to have one of the "awaiting" codes and vice versa.
Related:	Transfer Ready DtTm, Dispo 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_needs_awaiting_if_TR_Dt_and_Dispo_Dt_on_diff_days'
Uses L Problem table:	not relevant for this app
Status:	needs review
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:

2018-11-27 - suspended this check because it has false positives; we also consider ACP-C as transfer ready. Need to figure out if we can check this at all. Template:Discussion Additional dx codes that might act as "transfer ready" signal? Or do they?

• Palliative care
• Respite care
• ACP-C, but we don't code taht as a dx for now, do we?
• we don't have a code for "awaiting transfer within same hospital" from ICU
• deemed medically stable on same date as transfer to a subacute ward at same facility-entered delay for awaiting transfer to another facility, but sent to another ward at same facility, now getting error message