Query check CCI Component duplicates: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = No duplication of [[CCI Component]] [[Px_Type]], [[Px_Date]]
|DIC_summary=No duplication of [[CCI Component]] [[Px_Type]], [[Px_Date]]
| DIC_related_concepts = CCI Component; Px Type; Dx_Priority; No Dx Entered
|DIC_related_concepts=CCI Component; Px Type; Dx_Priority; No Dx Entered
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing = complete
|DIC_timing=complete
| DIC_app = CCMDB.mdb
|DIC_coding=query ''check_CCI_Component_duplicates''
| DIC_coding = query ''check_CCI_Component_duplicates''
|DIC_implementation_date=2018-10-14
| DIC_status = implemented
|DIC_status=ready to implement
| DIC_implementation_date = 2018-10-14
|DIC_LProblem=No
|DIC_app=CCMDB.mdb
}}
}}
*[[Px Type]] = Acquired – no same [[Px_Date]] and CCI code  
*[[Px Type]] = Acquired – no same [[Px_Date]] and CCI code  
*[[Px Type]] = Admit – no same CCI code (it should not have a [[Px_Date]] at all, dealt with by [[Query check CCI Date]]).   
*[[Px Type]] = Admit – no same CCI code (it should not have a [[Px_Date]] at all, dealt with by [[Query check CCI Date]]).   


We are not currently planning to check for [[CCI Collection Mode]]s being used correctly but this may change.
We are not currently planning to check for [[CCI Collection Mode]]s being used correctly but this may change.
== Waiting for... ==
We are reviewing some details in the definition of when to count or only enter once etc, so waiting to implement until that is settled.


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

Revision as of 13:36, 19 December 2018

Data Integrity Checks
Summary: No duplication of CCI Component Px_Type, Px_Date
Related: CCI Component, Px Type, Dx_Priority, No Dx Entered
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query check_CCI_Component_duplicates
Uses L Problem table: not relevant for this app
Status: ready to implement
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:

We are not currently planning to check for CCI Collection Modes being used correctly but this may change.

Related articles

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