Trach Task
The trach task encodes whether or not a medicine patient has a tracheostomy. It is stored in the Diagnosis tab in ccmdb.mdb because that is the only way we could store it when we started to collect it.
Instructions
Medicine ward patients have lines created automatically under the diagnosis tab. The one for this element needs to be changed to one of the following:
- 100100 - Trach None
- 100101 - Trach Acute - fresh trach has been in place for less than 48 hours by admission
- 100102 - Trach Chronic - chronic trach has been in place for 48 hours or more by admission
Template:Data Integrity Checks
Template:CCMDB Data Integrity Checks
Will need review with move to CCI/ICD10. Template:CCITemplate:ICD10 See diagnoses in Category:Tracheostomy.
query check_trach_dx_task
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
Data Structure
the list of options is in s_AllDiagnoses table and the actual data is stored in L_Dxs.
Legacy
Task items replaced iTISS December 15, 2006.