Trach Task: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "S_AllDiagnoses table" to "s_AllDiagnoses table")
m (Text replacement - "ccmdb.accdb" to "CCMDB.accdb")
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
The trach [[tasks | 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.  
{{LegacyContent
|explanation=discontinued as part of move to [[ICD10]]/[[CCI]].
|successor= CCI [[Tracheostomy creation]] and ICD10 [[Tracheostomy, has one]], [[Tracheostomy care]] and various tracheostomy complications
|content=
 
The trach [[tasks | task]] encodes whether or not a '''medicine''' patient has a tracheostomy.  It is stored in the Diagnosis tab in [[CCMDB.accdb]] because that is the only way we could store it when we started to collect it.  


== Instructions ==
== Instructions ==
Line 7: Line 12:
*[[100102 -  Trach Chronic]] - chronic trach has been in place for '''48 hours or more''' by admission
*[[100102 -  Trach Chronic]] - chronic trach has been in place for '''48 hours or more''' by admission


== {{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''
{{Data Integrity Check List}}
 
'''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 ==
the list of options is in [[s_AllDiagnoses table]] and the actual data is stored in [[L_Dxs]].
the list of options is in [[s_AllDiagnoses table]] and the actual data is stored in [[L_Dxs]].
== CCI ==
*This task will no longer be collected once we move to ICD10/CCI. There are codes there, CCI [[Tracheostomy creation]] and ICD10 [[Tracheostomy, has one]], [[Tracheostomy care]] and various tracheostomy complications. Will we want to move this data over or just keep it separate? Ttenbergen 19:26, 2018 October 25 (CDT)}}


== Legacy ==
== Legacy ==
Task items replaced [[iTISS]] December 15, 2006.
Task items replaced [[iTISS]] December 15, 2006.
== Related articles ==
{{Related Articles}}


[[Category: Task Elements]]
[[Category: Task Elements]]
}}

Latest revision as of 21:27, 2020 July 24

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

The trach task encodes whether or not a medicine patient has a tracheostomy. It is stored in the Diagnosis tab in CCMDB.accdb 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:

Data Integrity Checks

See diagnoses in Category:Tracheostomy.

Data Integrity Checks (automatic list)

 AppStatus
Query check trach dx taskCCMDB.accdbretired

Data Structure

the list of options is in s_AllDiagnoses table and the actual data is stored in L_Dxs.

CCI

  • This task will no longer be collected once we move to ICD10/CCI. There are codes there, CCI Tracheostomy creation and ICD10 Tracheostomy, has one, Tracheostomy care and various tracheostomy complications. Will we want to move this data over or just keep it separate? Ttenbergen 19:26, 2018 October 25 (CDT)


Legacy

Task items replaced iTISS December 15, 2006.

Related articles

Related articles:

}}