Query check CCI Date

Data Integrity Checks
Summary:	Px Date must be sensible when compared to Arrive_DtTm and Dispo_DtTm
Related:	[[Px Date, Arrive_DtTm, Dispo_DtTm]]
Firmness:	hard check
Timing:
App:	CCMDB.mdb
Coding:
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:
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 "Px Date]], Arrive_DtTm, [[Dispo_DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

If this check changes, consider whether Dx Chronological should be changed the same way.

• If exists, Dx_Date must be between Arrive_DtTm and Dispo_DtTm

• mandatory for procedures with Px Type acquired / Acquired Procedure
• not allowed for procedures with Px Type admit / Admit Procedure