Check ORDx: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) don't think this is a TISS76 check, put back in category with explanation if I am missing something. |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 12: | Line 12: | ||
== {{Cleaner.mdb Data Integrity Checks}} == | == {{Cleaner.mdb Data Integrity Checks}} == | ||
[[ | [[CCMDB Cleaner.mdb]] will draw on this table as well until we are sure that none make it through. | ||
*the table in | *the table in CCMDB Cleaner.mdb with the codes numbers and labels listed is called '''x_OR_Diagnosis''' | ||
** when we update | ** when we update CCMDB Cleaner.mdb we need to change it so it pulls its list from the master table in ccmdb.mdb, otherwise they will get out of synch. Ttenbergen 10:56, 2012 November 7 (EST){{Potential Change}} | ||
* Has anything make it through lately, otherwise we should stop doing this in cleaner. Ttenbergen 13:37, 2012 November 5 (EST){{discussion}} | * Has anything make it through lately, otherwise we should stop doing this in cleaner. Ttenbergen 13:37, 2012 November 5 (EST){{discussion}} | ||
Revision as of 10:09, 7 November 2012
Some diagnoses allow a patient to be admitted from from the OR/Recovery, others require it.
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)
Template:CCMDB Data Integrity Checks
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.
Implemented Ttenbergen 15:46, 29 September 2009 (CDT)
Template:Cleaner.mdb Data Integrity Checks
CCMDB Cleaner.mdb will draw on this table as well until we are sure that none make it through.
- the table in CCMDB Cleaner.mdb with the codes numbers and labels listed is called x_OR_Diagnosis
- when we update CCMDB Cleaner.mdb we need to change it so it pulls its list from the master table in ccmdb.mdb, otherwise they will get out of synch. Ttenbergen 10:56, 2012 November 7 (EST)Template:Potential Change
- Has anything make it through lately, otherwise we should stop doing this in cleaner. Ttenbergen 13:37, 2012 November 5 (EST)Template:Discussion
Keywords for search
so this can be found more easily using "search"
- admit from OR
- admit from operating room