Query s_tmp_MR

From CCMDB Wiki
Jump to navigation Jump to search
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: needs review
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • 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.

Related articles

Related articles: