Query check CCI from OR no CCI: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
| DIC_summary = If from OR or PACU, must have at least 1 [[CCI Procedure]] other than [[No procedure performed]]
| 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; No procedure performed; No codable procedure done in OR
| 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.accdb
| DIC_app = CCMDB.accdb
Line 21: Line 21:


== Log ==
== Log ==
2019-10-27 - changed so it only runs on completes and incompletes
* 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 27: Line 28:




[[Category: CCI Px check]]
[[Category:CCI Px check]]
[[Category: Registry checks]]
[[Category:Registry checks]]

Latest revision as of 10:55, 30 July 2025

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
  • Cargo


  • SMW


  • Categories:  
  • form:

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

Related articles

Related articles: