CCMDB Wiki

Query check CCI if no then none: Difference between revisions

Created page with "{{Data Integrity Check | DIC_summary = If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component | DIC_related..."
 
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 = If [[No procedure performed]]  in [[CCI Picklist]] there must be no other entries in [[CCI Picklist]] or [[CCI Component]]
| DIC_summary = If [[No procedure performed]]  in [[CCI Picklist]] there must be no other entries in [[CCI Picklist]] or [[CCI Component]]
| DIC_related_concepts = [[CCI Picklist]], [[CCI Component]], [[No procedure performed]]
| DIC_related_concepts = CCI Picklist; CCI Component; No procedure performed
| 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_if_no_then_none''
| DIC_coding = query ''check_CCI_if_no_then_none''
| DIC_status = ready to implement
| DIC_status = implemented
| DIC_implementation_date =  
| DIC_implementation_date = 2021-01-20
}}
}}


* need to make sure each pt has at least one CCI entry, possibly [[No procedure performed]].
== Log ==
* 2021-01-20 - the check never worked because it wasn't matching Pat_ID correctly; this was fixed today, meaning effectively this query was only implemented today, so changing the implementation date above.


== 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_if_no_then_none"