Check ORDx

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)
• Test patient 2 - admit from is HP and admit DX is angiogram. CCMDB is not flagging it as an error.--TOstryzniuk 15:03, 23 September 2009 (CDT)
• Test patient 3 - admit 1 DX is CABG, and admit FROM is HE. CCMDB is not flagging it as an error.--TOstryzniuk 16:17, 23 September 2009 (CDT)