Check ORDx: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 14: | Line 14: | ||
{{discussion}} | {{discussion}} | ||
* Check [[!_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 [[!_Automated_Data_Integrity_Checks#Q6..3F.3F_-_874_and_524_should_not_be_admitted_from_OR]] to see if this will be included here. | ||
*this problem is so seldom that I don't think it is worth writing an integrity check | *this problem is so seldom that I don't think it is worth writing an integrity check. | ||
*One error we do see is brain dead organ donors with outcome as Survived. [[User:TOstryzniuk|Trish Ostryzniuk]] 14:51, 2012 April 16 (CDT) | |||
* [[!_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; 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... [[User:Ttenbergen|Ttenbergen]] 15:25, 24 September 2009 (CDT) | * [[!_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; 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... [[User:Ttenbergen|Ttenbergen]] 15:25, 24 September 2009 (CDT) | ||
Revision as of 14:00, 16 April 2012
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
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 !_Automated_Data_Integrity_Checks#Q6..3F.3F_-_874_and_524_should_not_be_admitted_from_OR to see if this will be included here.
- this problem is so seldom that I don't think it is worth writing an integrity check.
- One error we do see is brain dead organ donors with outcome as Survived. Trish Ostryzniuk 14:51, 2012 April 16 (CDT)
- !_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; 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)
Keywords for search
so this can be found more easily using "search"
- admit from OR
- admit from operating room