Query check trach dx task: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = make sure [[Trach Task]] is entered correctly
|DIC_summary=make sure [[Trach Task]] is entered correctly
| DIC_related_concepts = [[Trach Task]]
|DIC_related_concepts=Trach Task
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing =
|DIC_coding=query ''check trach dx task''
| DIC_app = CCMDB.mdb
|DIC_implementation_date=date change was rolled out / first applied
| DIC_coding = query ''check trach dx task''
|DIC_status=needs review
| DIC_status = needs review
|DIC_LProblem=No
| DIC_implementation_date = date change was rolled out / first applied
|DIC_app=CCMDB.mdb
}}
}}
'''Wrong if''':  
'''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 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)

Revision as of 23:14, 23 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: 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:

  • if we keep tasks in ICD10 we will need to adjust this.

will need to eliminiate this

  • SMW


  • Cargo


  • Categories

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_trach_dx_task&oldid=130435"