Query s_tmp_AHC_consistent

Data Integrity Checks
Summary:	Checks for Project AHC
Related:	Project AHC
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	not entered
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	not entered
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

checks

added

• Medicine records admitted after the start and before the end of project have lines required for the project
• The lines must not be ""not entered"
• If there is a date it has to be after or at admission and before discharge.

Log

• 2025-01-20 - turns out I wrote the query and then never set the VBA to run it; so nothing to disable now that the project is over.
• 2024-12-04 - date and time will not be mandatory so no further checks required for now
• 2024-12-02
  • Medicine records admitted after the start and before the end of project have lines required for the project
  • The lines must not be ""not entered"
  • If there is a date it has to be after or at admission and before discharge.