Query check CCI component 1 and 2 compatible: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{Data Integrity Check | DIC_summary = Component CCIs must have compatible component 1 and component 2 | DIC_related_concepts = CCI Procedure | DIC_firmness = hard check |..."
 
mNo edit summary
Line 5: Line 5:
| DIC_timing = complete
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.mdb
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
| DIC_coding = query ''Check_CCI_component_1_and_2_compatible''
| DIC_status = ready to implement
| DIC_status = implemented
| DIC_implementation_date = date change was rolled out / first applied
| DIC_implementation_date = 2018-10-14
}}
}}
It is possible to enter a Component 1 from e.g. diagnostics and a component 2 from e.g. imaging. This should be impossible in the first place, but making that happen in CCMDB.mdb turned out quite complicated, so has not been implemented. We need to have a cross check that disallows combining codes from different groups.
It is possible to enter a Component 1 from e.g. diagnostics and a component 2 from e.g. imaging. This should be impossible in the first place, but making that happen in CCMDB.mdb turned out quite complicated, so has not been implemented. We need to have a cross check that disallows combining codes from different groups.


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

Revision as of 17:34, 14 October 2018

Data Integrity Checks
Summary: Component CCIs must have compatible component 1 and component 2
Related: [[CCI Procedure]]
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query Check_CCI_component_1_and_2_compatible
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. 
  • Categories:  
  • form:

It is possible to enter a Component 1 from e.g. diagnostics and a component 2 from e.g. imaging. This should be impossible in the first place, but making that happen in CCMDB.mdb turned out quite complicated, so has not been implemented. We need to have a cross check that disallows combining codes from different groups.

Related articles

Related articles: