CCMDB Wiki

Query check CCI Picklist duplicates: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = No duplication of [[CCI Picklist]] [[Px_Type]], [[Px_Date]], [[Px_Count]]
| DIC_summary = No duplication of [[CCI Picklist]] [[Px_Type]], [[Px_Date]], [[Px_Count]]
| 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  
| DIC_timing = complete
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.accdb
| DIC_coding = query ''check_CCI_Picklist_duplicates''
| DIC_coding = query ''check_CCI_Picklist_duplicates''
| DIC_status = implemented
| DIC_status = implemented
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 (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 Procedures coded once per ward admission]] only being there once.
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 ==
{{Related Articles}}
{{Related Articles}}


[[Category: CCI]]
[[Category:CCI]]
[[Category: CCI Px check‎]]
[[Category:CCI Px check‎]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_Picklist_duplicates"