Query s_tmp_MR

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

• Cargo

• SMW

"in planning" is not in the list (needs review, ready to implement, implemented, not entered, not feasible, declined, retired) of allowed values for the "DICStatus" property.

• Categories:  

• form:

Checks

• Medicine records admitted after the start and before the end of project have exactly one line
• The lines have to either have date and time, or have the checkbox checked
• If there is a date it has to be after project start, after or at admission, before the project end and before discharge.