Query check trach dx task: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 5: Line 5:
|DIC_coding=query ''check trach dx task''
|DIC_coding=query ''check trach dx task''
|DIC_implementation_date=date change was rolled out / first applied
|DIC_implementation_date=date change was rolled out / first applied
|DIC_status=needs review
|DIC_status=retired
|DIC_LProblem=No
|DIC_LProblem=No
|DIC_app=CCMDB.mdb
|DIC_app=CCMDB.mdb

Revision as of 19:26, 26 December 2018

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