Query s tmp ABO TEE checks

From CCMDB Wiki
Revision as of 20:05, 2021 January 21 by Ttenbergen (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Data Integrity Checks
Summary: Each of the three ABO TEE project entries 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

Log

2021-01-21 - updated to only check profiles that have a Service tmp entry "SBGH Cardiac / Cardiac Surgery" Or "SBGH Critical Care / Cardiac Surgery"

Related articles

Related articles: