Query check ACP Status Collection: Difference between revisions

Revision as of 15:32, 10 June 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 RecordStatus ="complete" since a "not entered" record is added automatically for each pt

	add "date of first should be before last"

@@ Line 19: / Line 19: @@
 * ([[L TmpV2 table]] date_var + time_var) must be after [[Admit date and time]]
 * only check on [[RecordStatus]] ="complete" since a "not entered" record is added automatically for each pt
+{{DT|
+* add "date of first should be before last"
+ }}
 == Log ==