Query s tmp ABO TEE checks

From CCMDB Wiki
Revision as of 22:53, 2019 January 2 by Ttenbergen (talk | contribs)
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.mdb
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
"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property.
  • 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
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_s_tmp_ABO_TEE_checks&oldid=132896"