Check ORDx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
TOstryzniuk (talk | contribs)
mNo edit summary
Line 2: Line 2:


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 '''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 ==
== 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.  
Trish completed the first draft of the list August 27.09 at 8 PM. Tina is implementing the checks as of Sep 23 09.  

Revision as of 11:30, 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