Query s tmp ACP

Data Integrity Checks
Summary:	error if ACP Status Collection is missing part of the entry.
Related:	ACP Status Collection
Firmness:	hard check
Timing:	always
App:	CCMDB.accdb
Coding:	query s_tmp_ACP
Uses L Problem table:	not relevant for this app
Status:
Implementation Date:
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

Complete and Incomplete patients

If there is data is needs to meet these checks:

• if there is a date, it must be during the admission
• integer and real must be blank
• date/time must be blank for ACP PTA

Complete patients

This needs to only be true to check the record "complete"

• there is exactly one each of ACP PTA, ACP first, ACP last
• for "Item" in (ACP first, ACP last)
  • If "Item" = "not documented", there must not be a datetime and the checkbox must be checked
  • If "Item" in (ACP-C, ACP-M, ACP-R), there must be a datetime
• "Item" must be in (ACP-C, ACP-M, ACP-R, not documented) (i.e. not blank, null, not yet entered)

Log

• 2025-08-19 discussion whether we should use the checkbox crosscheck for date/time missing; since the date/time is either mandatory or must be blank this would not add anything, so decided to omit the checkbox from the cross check