Query check ACP Status Collection

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

• Cargo

• SMW

• Categories:  

• form:

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"

• SMW

• Cargo

• Categories

Log

• 2025-03-06 - implemented
• 2025-03-05 - cross check defined