Query check CCI from OR no CCI

Data Integrity Checks
Summary:	If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed
Related:	CCI Procedure, Previous Location
Firmness:	hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)
Timing:
App:	CCMDB.mdb
Coding:	how to find this in containing program, eg. SAS file, function name, query name...
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

While Query check CCI must have entry makes sure every pt has at least 1 CCI entry, this check makes sure that each patient who comes from a surgical location has at least one CCI other than No procedure performed.

Surgical Location

Patient is considered coming from a surgical location if [[Previous Location] is one of the following:

is this actually a reasonable cross-check? What would be a false positive for this? Agree, there should be at least one CCI Procedure in admit. --JMojica 14:16, 2018 November 13 (CST) Having an entry is already taken care of in Query check CCI must have entry, this check would mean that for pt from OR or PACU the CCI entry must be other than No procedure performed.

• SMW

• Cargo

• Categories