Query s tmp ACP: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) there is no legacy query with that name, so using the name |
Ttenbergen (talk | contribs) No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=error if [[ACP Status Collection | |DIC_summary=error if [[ACP Status Collection]] is missing part of the entry. | ||
|DIC_related_concepts=ACP Status Collection | |DIC_related_concepts=ACP Status Collection | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''s_tmp_ACP '' | |DIC_coding=query ''s_tmp_ACP '' | ||
|DIC_implementation_date= | |DIC_implementation_date= | ||
|DIC_status= | |DIC_status= | ||
|DIC_LProblem=No | |DIC_LProblem=No | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
}} | }} | ||
==== Complete and Incomplete patients ==== | ==== 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 | |||
* if there is a date, it | * date/time must be blank for ACP PTA | ||
==== Complete patients ==== | ==== 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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
Latest revision as of 15: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: |