Query s tmp ACP: Difference between revisions

(4 intermediate revisions by 2 users not shown)

Line 1:

~~{{LegacyContent~~

~~|explanation=Check using old DX coding schema~~

~~|successor=[[Query check cooling vs arrest]]~~

~~|content=~~

{{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

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

}}

@@ Line 1: / Line 1: @@
-{{LegacyContent
-|explanation=Check using old DX coding schema
-|successor=[[Query check cooling vs arrest]]
-|content=
 {{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
+* "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}}
-}}