Query check CCI from OR no CCI: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Sorry, original question didn't make clear that this is about procedures other than No procedure performed |
Ttenbergen (talk | contribs) |
||
| Line 14: | Line 14: | ||
===Surgical Location=== | ===Surgical Location=== | ||
Patient is considered coming from a surgical location if [[Previous Location] is one of the following: | Patient is considered coming from a surgical location if [[Previous Location] is one of the following: | ||
* loc_type = RR | |||
* loc_type = OR | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
Revision as of 16:50, 18 November 2018
| 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 |
| 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.mdb |
| Coding: | how to find this in containing program, eg. SAS file, function name, query name... |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | date change was rolled out / first applied |
| 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