Check ORDx: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Errors |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
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''' | *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 Ostryzniuk | Trish]]. | |||
== 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. | ||
== 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 === | === Status === | ||
| Line 11: | Line 19: | ||
* [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 | ||
[[Category: Data Cleaner.mdb]] | [[Category: Data Cleaner.mdb]] | ||
[[Category: Data Collection Guide]] | [[Category: Data Collection Guide]] | ||
Revision as of 12:28, 24 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
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
- 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