Check pre acute consistent

Data Integrity Checks
Summary:	consistency of Pre acute living situation; Dispo; Postal Code and Previous Location
Related:	Pre acute living situation, Dispo, Postal Code, Previous Location, Province field
Firmness:	soft check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check pre acute consistent
Uses L Problem table:	not relevant for this app
Status:	declined
Implementation Date:	not entered
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

Discussed with Julie; she used to use this as part of Overstay, but that project is no longer so we don't need this.

JALT Julie found data discrepancies and asked if we could review doing cross checks at least on records with the same Visit Admit DtTm for the following fields: Pre acute living situation Province field Postal Code We reviewed a broader cross check proposal (link below) in some detail in a version available in the history of this page], so if we consider adding this we should confirm that none of those apply to any checks. Or we can ignore and just implement as soft-checks. Thoughts? Ttenbergen 12:28, 17 December 2025 (CST)

• SMW

• Cargo

• Categories

version with discussion