Query check trach dx task

From CCMDB Wiki
Revision as of 19:26, 26 December 2018 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: make sure Trach Task is entered correctly
Related: Trach Task
Firmness: hard check
Timing: always
App: CCMDB.mdb
Coding: query check trach dx task
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: date change was rolled out / first applied
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 
  • Categories:  
  • form:

Wrong if:

  • trach task none (100) or empty AND if there is any trach dx in admit or complication (empty tasks are checked elsewhere, this will give specific error)
  • trach TASK chronic (102) AND no admit trach DX
  • trach TASK chronic (102) with acquired trach DX
  • trach TASK acute (101) AND no admit or acquired Trach DX

where trach DX's are:


Related articles

Related articles: