Query check trach dx task

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:

• See: Tracheostomy except 77402 chrichothyroidotomy
• See: Tracheostomy Site Infection

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

• SMW

• Cargo

• Categories