Query check CCI if no then none: Difference between revisions

mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(4 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 = implemented
| DIC_status = implemented
| DIC_implementation_date = 2018-10-14
| DIC_implementation_date = 2021-01-20
}}
}}
== 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‎]]