Query s tmp ACP: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
|||
| Line 21: | Line 21: | ||
* for "Item" in (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" = "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 | ** If "Item" in (ACP-C, ACP-M, ACP-R), there must be a datetime | ||
* "Item" must be in (ACP-C, ACP-M, ACP-R, not documented) (i.e. not blank, null, not yet entered) | * "Item" must be in (ACP-C, ACP-M, ACP-R, not documented) (i.e. not blank, null, not yet entered) | ||
== Log == | |||
* 2025-08-19 discussion whether we should use the checkbox crosscheck for date/time missing; since the date/time is either mandatory or must be blank this would not add anything, so decided to omit the checkbox from the cross check | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
Latest revision as of 16:40, 19 August 2025
| 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
- "Item" must be in (ACP-C, ACP-M, ACP-R, not documented) (i.e. not blank, null, not yet entered)
Log
- 2025-08-19 discussion whether we should use the checkbox crosscheck for date/time missing; since the date/time is either mandatory or must be blank this would not add anything, so decided to omit the checkbox from the cross check
Related articles
| Related articles: |