Query check CCI from OR no CCI: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) 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..." |
Ttenbergen (talk | contribs) m →Log |
||
| (13 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 = | | 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 checks have to consider that table) | ||
| DIC_timing = | | DIC_timing = | ||
| DIC_app = CCMDB. | | DIC_app = CCMDB.accdb | ||
| DIC_coding = | | DIC_coding = query ''check_CCI_from_OR_no_CCI'' | ||
| DIC_status = | | DIC_status = implemented | ||
| DIC_implementation_date = | | DIC_implementation_date = 2018-11-18 | ||
}} | }} | ||
* | 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 17: | Line 29: | ||
[[Category: CCI Px check]] | [[Category: CCI Px check]] | ||
[[Category: Registry checks]] | |||
Latest revision as of 14:58, 7 November 2019
| Data Integrity Checks | |
| Summary: | If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed |
| Related: | CCI Procedure, Previous Location, No procedure performed, No codable procedure done in OR |
| 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) |
| Timing: | |
| App: | CCMDB.accdb |
| Coding: | query check_CCI_from_OR_no_CCI |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2018-11-18 |
| Backlogged: | true |
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 Procedures 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