Trach Task: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(→‎{{CCMDB Data Integrity Checks}}: Chronic Trach put in admit DX for both ICU and Medicine patients)
m (Text replacement - "ccmdb.accdb" to "CCMDB.accdb")
 
(11 intermediate revisions by 2 users 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}} ==
See diagnoses in [[:Category:Tracheostomy]].
query ''check_trach_dx_task''


'''Wrong if''':
{{Data Integrity Check List}}
* trach task none (100) or empty(1) AND if there is any trach dx in admit or complication.  (1 - 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:
== Data Structure ==
* [[Tracheostomy]] ''except 77402 chrichothyroidotomy''
the list of options is in [[s_AllDiagnoses table]] and the actual data is stored in [[L_Dxs]].
* [[Tracheostomy Site Infection]]
 
 
{{discussion}}
*Hi all I have a patient admitted that has a chronic trach (has for years) (trach task chronic) and was wondering if I should also be including trach in admit dx? (I would code this last) Would this be consistent with instruction above? Thanks. [[User:Ppiche|Pamela Piche]] 08:29, 2015 May 15 (CDT)
**I would put the trach task chronic but would not put the procedure tracheostomy in the admit codes in this scenario.  The admit code section applies to current admission items (current hospitalization).  If the pt was admitted with a problem with the trach, like an infection, then this can still be coded without putting the procedure tracheostomy in the admit section.  --[[User:LKolesar|LKolesar]] 13:39, 2015 May 15 (CDT)
*** the cross-checks as I was asked to implement them would not allow through a chronic trach task without a corresponding admit dx. If we want to change that I need to change the code. Ttenbergen 13:31, 2015 May 20 (CDT)
****This will now change.  We can put unlimited amounts of DX codes now.  So if Chronic trach (one that has been in place for more than 48 hrs) is present at admission,  it should be part of the admit DX's one of the LAST one. Including the DX code of a chronic trach in ADMIT DX slot is applicable for both Medicine and ICU. - [[User:TOstryzniuk|Trish Ostryzniuk]] 17:34, 2015 May 20 (CDT)


== Data Structure ==
== CCI ==
the list of options is in [[S_AllDiagnoses]] and the actual data is stored in [[L_Dxs]].
*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:

}}

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Trach_Task&oldid=145424"