Query s tmp IICU consult DtTm

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: "IICU consult" must have either a date or the check box checked. If they have a date, it has to be between Arrive_DtTm and Dispo_DtTm.
Related: IICU consult
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query s_tmp_IICU_consult_DtTm
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date:
Backlogged: true
  • Cargo

  • SMW

  • Categories: 
  • form:


  • 2022-04-19 - retired cross check for tmp that is no longer running
  • 2019-11-26 - tweaked query to make it easier to see specifically what is wrong.

Related articles

Related articles: