Query s tmp ACP: Difference between revisions

Line 1:

{{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]] is missing part of the entry.

|DIC_related_concepts=ACP Status Collection ~~in ICU~~

|DIC_related_concepts=ACP Status Collection

|DIC_firmness=hard check

|DIC_coding=query ''s_tmp_ACP ''

|DIC_implementation_date=~~2015-12-03T13:11:02~~

|DIC_implementation_date=

|DIC_status=~~retired~~

|DIC_status=

|DIC_LProblem=No

|DIC_app=CCMDB.accdb

}}

~~approximate implementation date~~

==== Complete and Incomplete patients ====

* ACP entries must be paired

If there is data is needs to meet these checks:

* there ~~has to be a status entry~~

* if there is a date, it must be during the admission

* there has to ~~be a source entry~~

* integer and real must be blank

* if there is a date, it ~~can't~~ be ~~after~~ the ~~[[Dispo DtTm]]~~

* date/time must be blank for ACP PTA

==== Complete patients ====

* ~~unless source item~~ = "not documented" there ~~has to~~ be a ~~date~~

This needs to only be true to check the record "complete"

* ~~unless status item =~~ "~~not documented~~" there ~~has to~~ be a date

* there is exactly one each of ''ACP PTA, ACP first, ACP last''

* source and ~~status items can~~'t ~~be null~~, "" ~~or "enter"~~

* for "Item" in (ACP first, ACP last)

* source and status integers have to be ~~present~~

** 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 ==

@@ Line 1: / Line 1: @@
 {{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]] is missing part of the entry.
-|DIC_related_concepts=ACP Status Collection in ICU
+|DIC_related_concepts=ACP Status Collection
 |DIC_firmness=hard check
 |DIC_coding=query ''s_tmp_ACP ''
-|DIC_implementation_date=2015-12-03T13:11:02
+|DIC_implementation_date=
-|DIC_status=retired
+|DIC_status=
 |DIC_LProblem=No
 |DIC_app=CCMDB.accdb
 }}
-approximate implementation date
 ==== Complete and Incomplete patients ====
-* ACP entries must be paired
+If there is data is needs to meet these checks:
-* there has to be a status entry
+* if there is a date, it must be during the admission
-* there has to be a source entry
+* integer and real must be blank
-* if there is a date, it can't be after the [[Dispo DtTm]]
+* date/time must be blank for ACP PTA
 ==== Complete patients ====
-* unless source item = "not documented" there has to be a date
+This needs to only be true to check the record "complete"
-* unless status item = "not documented" there has to be a date
+* there is exactly one each of ''ACP PTA, ACP first, ACP last''
-* source and status items can't be null, "" or "enter"
+* for "Item" in (ACP first, ACP last)
-* source and status integers have to be present
+** 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}}