Trach Task: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "S_AllDiagnoses table" to "s_AllDiagnoses table")
mNo edit summary
Line 8: Line 8:


== {{Data Integrity Checks}} ==
== {{Data Integrity Checks}} ==
* see [[Check Duplicate Task Entries]]
* [[Check Duplicate Task Entries]]
* [[query check trach dx task]]


=={{CCMDB Data Integrity Checks|needs review}}==
Will need review with move to [[CCI]]/[[ICD10]]. {{CCI}}{{ICD10}}
See diagnoses in [[:Category:Tracheostomy]].
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 ==
== Data Structure ==

Revision as of 11:50, 2018 September 20

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:

Template:Data Integrity Checks

See diagnoses in Category:Tracheostomy.

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.