Query s tmp ACP: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "ACP Status collection in ICU" to "ACP Status Collection in ICU" |
Ttenbergen (talk | contribs) there is no legacy query with that name, so using the name |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=error if [[ACP Status Collection in ICU]] is missing part of the entry. | |DIC_summary=error if [[ACP Status Collection in ICU]] is missing part of the entry. | ||
| Line 29: | Line 24: | ||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
Revision as of 17:14, 24 June 2025
| Data Integrity Checks | |
| Summary: | error if ACP Status Collection in ICU is missing part of the entry. |
| Related: | ACP Status Collection in ICU |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query s_tmp_ACP |
| Uses L Problem table: | not relevant for this app |
| Status: | retired |
| Implementation Date: | 2015-12-03T13:11:02 |
| Backlogged: | true |
approximate implementation date
Complete and Incomplete patients
- ACP entries must be paired
- there has to be a status entry
- there has to be a source entry
- if there is a date, it can't be after the Dispo DtTm
Complete patients
- unless source item = "not documented" there has to be a date
- unless status item = "not documented" there has to be a date
- source and status items can't be null, "" or "enter"
- source and status integers have to be present
Related articles
| Related articles: |