Check ORDx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
No edit summary
Line 10: Line 10:
* Check [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q6..3F.3F_-_874_and_524_should_not_be_admitted_from_OR] to see if this will be included here.  
* Check [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q6..3F.3F_-_874_and_524_should_not_be_admitted_from_OR] to see if this will be included here.  
* [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q7b._These_DX_code_most_often_NOT_to_OR_for_the_procedure_so_T96_is_not_always_marked] will need to be updated in datacleaner.mdb to draw from new table
* [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q7b._These_DX_code_most_often_NOT_to_OR_for_the_procedure_so_T96_is_not_always_marked] will need to be updated in datacleaner.mdb to draw from new table
==Testing==
*test patient 1 - admit from is HP but DX 1 is septic shock.  CCMDB is not flagging as an error.--[[User:TOstryzniuk|TOstryzniuk]] 14:58, 23 September 2009 (CDT)


[[Category: Data Cleaner.mdb]]
[[Category: Data Cleaner.mdb]]
[[Category: Data Collection Guide]]
[[Category: Data Collection Guide]]

Revision as of 13:58, 23 September 2009

Some diagnoses allow a patient to be admitted from from the OR/Recovery, others require it.

The table Check_ORDx in CCMDB.mdb contains all diagnoses that allow admit-from OR, and a checkbox for all diagnoses that require admit-from OR. Data_cleaner.mdb will draw on this table as well until we are sure that none make it through.

  • the table in Data_cleaner.mdb with the codes numbers and labels listed is called x_OR_Diagnosis

Start Date

Trish completed the first draft of the list August 27.09 at 8 PM. Tina is implementing the checks as of Sep 23 09.

Status

  • This is ready for testing in Test_trish. Trish, you will want to review the check_ordx table, at this point all dxs that allow for OR Admission also require it - this will cause problems with false errors.
  • Check [1] to see if this will be included here.
  • [2] will need to be updated in datacleaner.mdb to draw from new table

Testing

  • test patient 1 - admit from is HP but DX 1 is septic shock. CCMDB is not flagging as an error.--TOstryzniuk 14:58, 23 September 2009 (CDT)