Query s tmp ACP

Data Integrity Checks
Summary:	error if ACP Status collection in ICU is missing part of the entry.
Related:	[[ACP Status collection in ICU]]
Firmness:	hard check
Timing:	complete always
App:	CCMDB.mdb
Coding:	query s_tmp_ACP
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2015-12-03T13:11:02
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. 

• Categories:  

• form:

approximate implementation date

Complete and Incomplete patients

• ACP entries must be paired
• there has to be a status entry
• there has to be a source entry
• if there is a date, it can't be after the Dispo DtTm

Complete patients

• unless source item = "not documented" there has to be a date
• unless status item = "not documented" there has to be a date
• source and status items can't be null, "" or "enter"
• source and status integers have to be present