Query check trach dx task

From CCMDB Wiki
Jump to navigation Jump to search

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: