Query check Project OT PT Consults: Difference between revisions

Latest revision as of 10:55, 30 July 2025

Data Integrity Checks
Summary:	every LAU OT/PT consults must have an entry, and the date must make sense
Related:	Admit date and time, Dispo_DtTm, LAU OT/PT consults
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_Project_OT_PT_Consults
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: OTPT Consults)
only check on RecordStatus="complete" since a "not entered" record is added automatically for each pt

@@ Line 1: / Line 1: @@
 {{DISPLAYTITLE:Query check_Project_OT_PT_Consults}}{{Data Integrity Check
 | DIC_summary = every [[LAU OT/PT consults]] must have an entry, and the date must make sense
-| DIC_related_concepts = Admit date and time; Dispo_DtTm; Project Consults data
+| DIC_related_concepts = Admit date and time; Dispo_DtTm; LAU OT/PT consults
 | DIC_firmness = hard check
 | DIC_timing = complete
@@ Line 22: / Line 22: @@
 == Log ==
 * 2025-03-...
-* 2025-03-13 - cross check defined
+* 2025-03-13 - [[cross check]] defined
 == Related Articles ==
 {{Related Articles}}
-[[Category: LAU Collection Project]]
+[[Category:LAU Collection Project]]
-[[Category: ACP]]
+[[Category:ACP]]