Trach Task: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →{{CCMDB Data Integrity Checks}}: clean-up |
Ttenbergen (talk | contribs) |
||
| Line 15: | Line 15: | ||
Wrong if: | Wrong if: | ||
* trach task none (100) or empty*1 and any trach dx | * trach task none (100) or empty*1 and any trach dx | ||
* trach task chronic (102) and no admit trach dx | * 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 acute trach dx | * trach task acute (101) and no admit or acute trach dx | ||
Revision as of 18:02, 14 May 2015
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 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-1st 48 hrs (new trach)
- 100102 - Trach Chronic-more than 48 hrs
Template:Data Integrity Checks
Template:CCMDB Data Integrity Checks
query check_trach_dx_task
Wrong if:
- trach task none (100) or empty*1 and any trach dx
- 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 acute trach dx
where trach dxs are
- Tracheostomy except 77402 chrichothyroidotomy
- Tracheostomy Site Infection
- 1 empty tasks are checked elsewhere, this will give specific error.
Data Structure
the list of options is in S_AllDiagnoses and the actual data is stored in L_Dxs.
Legacy
Task items replaced iTISS December 15, 2006.