Check ORDx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
No edit summary
 
(50 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Some diagnoses allow a patient to be [[Admit From & Discharged To | admitted from]] from the OR/Recovery, others require it.
{{LegacyContent
|explanation=Patients primary admit diagnosis no longer has cross-requirements to them coming from OR/RR
|successor=
|content=
Table removed from [[CCMDB.accdb]] Ttenbergen 08:41, 2017 December 13 (CST)
Table removed from [[CFE]] 2025-09-28


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.
Some diagnoses allow a patient with [[Previous Location]] OR/Recovery, others require it.  
*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 ===
== Problems with false positives in Medicine ==
* 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.
There were initially some false positives for this in medicine. As of 2017-04-26 they seem to be fixed.
* Check [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q6..3F.3F_-_874_and_524_should_not_be_admitted_from_OR] to see if this will be included here.
* [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]]
== Errors Scenarios ==
[[Category: Data Collection Guide]]
* 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'')
 
== Cross checks ==
The table '''Check_ORDx''' in [[CCMDB.accdb]] contains all diagnoses that '''allow''' admit-from OR, and a checkbox for all diagnoses that '''require''' admit-from OR.
 
Implemented [[User:Ttenbergen|Ttenbergen]] 15:46, 29 September 2009 (CDT)
 
==Keywords for search==
so this can be found more easily using "search"
* admit from OR
* admit from operating room
* arrive from OR
* accept from OR
}}

Latest revision as of 22:24, 31 October 2025

Legacy Content

This page contains Legacy Content.

  • Explanation: Patients primary admit diagnosis no longer has cross-requirements to them coming from OR/RR
  • Successor:

Click Expand to show legacy content.

Table removed from CCMDB.accdb Ttenbergen 08:41, 2017 December 13 (CST) Table removed from CFE 2025-09-28

Some diagnoses allow a patient with Previous Location OR/Recovery, others require it.

Problems with false positives in Medicine

There were initially some false positives for this in medicine. As of 2017-04-26 they seem to be fixed.

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)

Cross checks

The table Check_ORDx in CCMDB.accdb 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)

Keywords for search

so this can be found more easily using "search"

  • admit from OR
  • admit from operating room
  • arrive from OR
  • accept from OR