Query check CCI must have entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=There must be at least 1 CCI entry (which might be [[No procedure performed]])
|DIC_summary=There must be at least 1 CCI entry in [[L_CCI_Picklist table]] (which might be [[No procedure performed]])
|DIC_related_concepts=CCI Collection; No procedure performed
|DIC_related_concepts=CCI Collection; No procedure performed, L_CCI_Picklist table
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_timing=complete

Revision as of 15:45, 2019 January 9

Data Integrity Checks
Summary: There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed)
Related: CCI Collection, No procedure performed, L_CCI_Picklist table
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query check_CCI_must_have_entry
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018/11/12
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:

Related articles

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