Trach Task: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m clarification to make sure rules were right
Line 4: Line 4:
Medicine patients have lines created automatically under the diagnosis tab. The one for this element needs to be changed to one of the following:  
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]]   
*[[100100 -  Trach None]]   
*[[100101 -  Trach Acute]]-1st 48 hrs (new trach)
*[[100101 -  Trach Acute]] - fresh trach has been in place for '''less''' than 48 hours by admission
*[[100102 -  Trach Chronic]]-more than 48 hrs
*[[100102 -  Trach Chronic]] - chronic trach has been in place for 48 hours or more by admission


== {{Data Integrity Checks}} ==
== {{Data Integrity Checks}} ==

Revision as of 18:09, 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:

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

  • 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.