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]], [[Px_Count]]
| DIC_summary = No duplication of [[CCI Component]] [[Px_Type]], [[Px_Date]]
| DIC_related_concepts = [[CCI Picklist]], [[Px Type]], [[Dx_Priority]], [[No Dx Entered]]
| DIC_related_concepts = [[CCI Picklist]], [[Px Type]], [[Dx_Priority]], [[No Dx Entered]]
| DIC_firmness = hard check  
| DIC_firmness = hard check  
Line 10: Line 10:
}}
}}


*[[Px Type]] = Acquired – no same [[Px_Date]] and CCI code and [[Px Count]]
*[[Px Type]] = Acquired – no same [[Px_Date]] and CCI code  
*[[Px Type]] = Admit – no same CCI code and [[Px Count]], (exclude the  Px_date  entered).   
*[[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 Procedures coded once per ward admission]] only being there once.
We are not currently planning to check for [[CCI Procedures coded once per ward admission]] only being there once.

Revision as of 17:27, 14 October 2018

Data Integrity Checks
Summary: No duplication of CCI Component Px_Type, Px_Date
Related: [[CCI Picklist, 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: 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]], Px Type, Dx_Priority, [[No Dx Entered" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.
  • Categories:  
  • form:

We are not currently planning to check for CCI Procedures coded once per ward admission only being there once.

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_Component_duplicates&oldid=121020"