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:	complete
App:	CCMDB.mdb
Coding:	query check_CCI_Date
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-10-14
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 Query check ICD10 date should be changed the same way.

• If exists, Px_Date must be between Arrive_DtTm and Dispo_DtTm

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