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 |
||
| 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 and the checkbox must not be checked | |||
{{DL | 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? [[User:Ttenbergen|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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
Revision as of 18:27, 24 June 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 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: |