Check ORDx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(38 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'''


== Administration ==
== Problems with false positives in Medicine ==
If you come across a OR-required OR-allowed diagnoses that need to be changed, contact [[Trish Ostryzniuk | Trish]].
There were initially some false positives for this in medicine. As of 2017-04-26 they seem to be fixed.
 
== 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 ==
== Errors Scenarios ==
Line 14: Line 16:
* admit diagnosis 1 is '''OR-required''', admit-from is '''not (OR or Recovery)''' (query ''Check_ORDx__not_from_OR_OrDx'')
* admit diagnosis 1 is '''OR-required''', admit-from is '''not (OR or Recovery)''' (query ''Check_ORDx__not_from_OR_OrDx'')


== Status ==
== 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)
Implemented [[User:Ttenbergen|Ttenbergen]] 15:46, 29 September 2009 (CDT)


==Discussion==
==Keywords for search==
{{discussion}}
so this can be found more easily using "search"
* 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.
* admit from OR
 
* admit from operating room
* [[!_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)
* arrive from OR
 
* accept from OR
 
}}
 
[[Category: IT Instructions]]
[[Category: Data Cleaner.mdb]]
[[Category: Data Collection Guide]]

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