CCMDB Wiki

Query check CCI from OR no CCI: Difference between revisions

Created page with "{{Data Integrity Check | DIC_summary = If from OR or PACU, must have at least 1 CCI Procedure | DIC_related_concepts = CCI Procedure, Previous Location | DIC_firmn..."
 
m Text replacement - "[[Category: " to "[[Category:"
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If from OR or PACU, must have at least 1 [[CCI Procedure]]
| DIC_summary = If from OR or PACU, must have at least 1 [[CCI Procedure]] other than [[No procedure performed]]
| DIC_related_concepts = [[CCI Procedure]], [[Previous Location]]
| DIC_related_concepts = CCI Procedure; Previous Location; No procedure performed; No codable procedure done in OR
| DIC_firmness = hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)
| DIC_firmness = hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and [[cross check]]s have to consider that table)
| DIC_timing =
| DIC_timing =
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.accdb
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
| DIC_coding = query ''check_CCI_from_OR_no_CCI''
| DIC_status = needs review
| DIC_status = implemented
| DIC_implementation_date = date change was rolled out / first applied
| DIC_implementation_date = 2018-11-18
}}
}}
{{Discuss | who = all | question =  
 
* is this actually a reasonable cross-check? What would be a false positive for this? }}
While [[Query check CCI must have entry]] makes sure every pt has at least 1 CCI entry, this check makes sure that each patient who comes from a surgical location has at least one CCI '''other than [[No procedure performed]].
 
===Surgical Location===
Patient is considered coming from a surgical location if [[Previous Location]] is one of the following:
* loc_type = RR
* loc_type = OR
 
=== Aborted procedure ===
Since we code [[Aborted Procedure]]s this check should not produce false errors for those.
 
== Log ==
* 2019-11-07 - confirmed that check will run with [[No codable procedure done in OR]]
* 2019-10-27 - changed so it only runs on completes and incompletes


== Related articles ==
== Related articles ==
Line 16: Line 28:




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