Query check ACP Status Collection for LAU: Difference between revisions

Revision as of 00:05, 7 March 2025

Data Integrity Checks
Summary:	every LAU Collection Project must have an entry, and the date must make sense
Related:	Admit date and time, Dispo_DtTm, ACP Status Collection for LAU
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_ACP_Status_Collection_for_LAU
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2025-03-06
Backlogged:	true

This check is or a temporary entry collected for the LAU Collection Project.

Check:

Project IN ("ACP first", "ACP last")
there is at least one entry for every LAU Collection Project record
"item" is not "not entered"
(L_TmpV2 table date_var + time_var) must be before Dispo DtTm field
(L TmpV2 table date_var + time_var) must be after Admit date and time
only check on Record_Status="complete" since a "not entered" record is added automatically for each pt

@@ Line 6: / Line 6: @@
 | DIC_app = CCMDB.accdb
 | DIC_coding =  query ''check_ACP_Status_Collection_for_LAU''
-| DIC_status =
+| DIC_status = implemented
-| DIC_implementation_date = 2025-03
+| DIC_implementation_date = 2025-03-06
 }}
@@ Line 13: / Line 13: @@
 Check:
+* Project IN ("ACP first", "ACP last")
 * there is at least one entry for every [[LAU Collection Project]] record
 * "item" is not "not entered"
 * ([[L_TmpV2 table]] date_var + time_var) must be before [[Dispo DtTm field]]
 * ([[L TmpV2 table]] date_var + time_var) must be after [[Admit date and time]]
-{{DL |
+* only check on [[Record_Status]]="complete" since a "not entered" record is added automatically for each pt
-Is that last one reasonable? I guess it depends on how we want to collect a status that was set before admission to this unit. See question in [[ACP_Status_Collection_for_LAU#Data_Entry_Instructions]].
-* as long as equal to or before admit dttm not prior to [[User:Lkaita|Lisa Kaita]] 08:34, 6 March 2025 (CST)
-** you mean "equal to or after", correct? [[User:Ttenbergen|Ttenbergen]] 13:14, 6 March 2025 (CST)}}
-**yes, sorry
 == Log ==
+* 2025-03-06 - implemented
 * 2025-03-05 - cross check defined