Query s tmp ACP
Jump to navigation
Jump to search
| Data Integrity Checks | |
| Summary: | error if ACP Status Collection is missing part of the entry. |
| Related: | ACP Status Collection |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query s_tmp_ACP |
| Uses L Problem table: | not relevant for this app |
| Status: | |
| Implementation Date: | |
| Backlogged: | true |
Complete and Incomplete patients
If there is data is needs to meet these checks:
- if there is a date, it must be during the admission
- integer and real must be blank
- date/time must be blank for ACP PTA
Complete patients
This needs to only be true to check the record "complete"
- there is exactly one each of ACP PTA, ACP first, ACP last
- for "Item" in (ACP first, ACP last)
- If "Item" = "not documented", there must not be a datetime and the checkbox must be checked
- If "Item" in (ACP-C, ACP-M, ACP-R), there must be a datetime and the checkbox must not be checked
|
Actually... in that scenario, the checkbox doesn't add anything, it would only be useful if the date was optional and we wanted to ensure that it doesn't get forgotten. So, is it optional? Or can we omit the checkbox? Ttenbergen 18:27, 24 June 2025 (CDT) |
- "Item" must be in (ACP-C, ACP-M, ACP-R, not documented) (i.e. not blank, null, not yet entered)
Related articles
| Related articles: |