Query s_tmp_AHC_consistent

From CCMDB Wiki
Jump to navigation Jump to search
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

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

Related articles

Related articles: