Query s tmp ABO TEE checks

From CCMDB Wiki
Revision as of 12:00, 2020 March 2 by Ttenbergen (talk | contribs) (Text replacement - "Site/Location check" to "Service/Location check")
Jump to navigation Jump to search
Data Integrity Checks
Summary: Each of the three projects must have one entry on the ITEM for patients with RecordStatus complete
Related: Project ABO TEE, Service/Location field
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query s_tmp_ABO_TEE_checks
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2016-01-28
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Checks might have been around before them but were first documented then.

  • All the three projects must not have blanks on completion of record.
    • automatic functionality, all tmp entries must have matching project/item entries