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:

• loc_type = RR
• loc_type = OR