Query check trach dx task

Revision as of 12:01, 22 September 2019 by Ttenbergen (talk | contribs) (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

Data Integrity Checks
Summary: make sure Trach Task is entered correctly
Related: Trach Task
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check trach dx task
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date: date change was rolled out / first applied
Backlogged: true
  • Cargo


  • SMW


  • 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: