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 |..."
 
m Text replacement - "[[Category: " to "[[Category:"
 
(4 intermediate revisions by the same user not shown)
Line 4: Line 4:
| DIC_firmness = hard check
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.accdb
| 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.accdb 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 ==
{{Related Articles}}
{{Related Articles}}


[[Category: CCI Px check]]
[[Category:CCI Px check]]

Latest revision as of 11:56, 30 July 2025

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


  • 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.accdb 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: