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

Administration

If you come across a OR-required OR-allowed diagnoses that need to be changed, contact Trish.

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.

Errors Scenarios

• admit-from OR, admit diagnosis 1 is not OR-allowed (query Check_ORDx__from_OR_no_ORDx)
• admit diagnosis 1 is OR-required, admit-from is not (OR or Recovery) (query Check_ORDx__not_from_OR_OrDx)

Status

Implemented Ttenbergen 15:46, 29 September 2009 (CDT)

Discussion

• Check [1] to see if this will be included here.

• [2] will need to be updated in datacleaner.mdb to draw from new table; mind you: if it will use the same data, and the same query, then what would it possibly expect to find. putting on back burner... Ttenbergen 15:25, 24 September 2009 (CDT)