Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm

Data Integrity Checks
Summary:	If an ICD10 code in Category:Awaiting/delayed transfer is Primary Admit Diagnosis/Dx Primary then Transfer Ready DtTm must equal Arrive DtTm
Related:	Arrive DtTm, Transfer Ready DtTm tmp entry, Boarding Loc, Primary Admit Diagnosis, Dx Primary, Admit Diagnosis, 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:
App:	CCMDB.accdb
Coding:	query check_ICD10_PrDx_Awaiting_but_not_transferReady
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

• Panelling_admit_transfer_same(Pat_ID): a record is an error if both
  • Primary Admit Diagnosis = any awaiting code
  • (Transfer Ready DtTm) <> (Arrive DtTm)

Needs review

• suspended the check 2020-10-15 because of move to Transfer Ready DtTm tmp entry

AJTT new check should likely go against Boarding Loc entries instead of Arrive DtTms, but now that there may be several Transfer Ready DtTm tmp entry entries, is that check still the right logic? Should it instead check every awaiting code against a TR date entry? Or does the whole thing become so messy that we shouldn't do it at all?

• SMW

• Cargo

• Categories