Query check ACP Status Collection for LAU

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:
Implementation Date:	2025-03
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

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

Check:

• 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

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 Lisa Kaita 08:34, 6 March 2025 (CST) you mean "equal to or after", correct? Ttenbergen 13:14, 6 March 2025 (CST)

• SMW

• Cargo

• Categories

Log

• 2025-03-05 - cross check defined