Query check CCI if no then none: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Newer edit →
Created page with "{{Data Integrity Check | DIC_summary = If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component | DIC_related..."
 
mNo edit summary
Line 6: Line 6:
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.mdb
| DIC_coding = query ''check_CCI_if_no_then_none''
| DIC_coding = query ''check_CCI_if_no_then_none''
| DIC_status = ready to implement
| DIC_status = implemented
| DIC_implementation_date =  
| DIC_implementation_date = 2018-10-14
}}
}}
* need to make sure each pt has at least one CCI entry, possibly [[No procedure performed]].


== Related articles ==
== Related articles ==

Revision as of 15:41, 14 October 2018

Data Integrity Checks
Summary: If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component
Related: [[CCI Picklist, CCI Component, No procedure performed]]
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query check_CCI_if_no_then_none
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 (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "CCI Picklist]], CCI Component, [[No procedure performed" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.
  • Categories:  
  • form:

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_if_no_then_none&oldid=120976"