Query check Project Consults data: Difference between revisions

Revision as of 12:29, 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, Project Consults data
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_Project_Consults_data
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:

(L_TmpV2 table date_var, time_var) must not be null
(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
"item" is not "not entered"
there is at least one entry for every LAU Collection Project record (Project: Consults)
only check on RecordStatus="complete" since a "not entered" record is added automatically for each pt

@@ Line 13: / Line 13: @@
 Check:
-* there is at least one entry for every [[LAU Collection Project]] record (Project: Consults)
-* "item" is not "not entered"
 * ([[L_TmpV2 table]] date_var, time_var) must not be null
 * ([[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]]
+* "item" is not "not entered"
+* there is at least one entry for every [[LAU Collection Project]] record (Project: Consults)
 * only check on [[RecordStatus]]="complete" since a "not entered" record is added automatically for each pt