Check ORDx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
No edit summary
 
(30 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'''
 
== 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 ==
== Errors Scenarios ==
Line 8: 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==
{{discussion}}
* [[!_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)
** do we still need this one, then? [[User:Ttenbergen|Ttenbergen]] 15:57, 2012 April 16 (CDT)
***no.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:03, 2012 April 16 (CDT)
*Note there are some cases where patient is DX to be braindead and family agree to organ donation.  They are sent from one ICU in city to another.  They are coded as Survived from one ICU and E and second ICU.


==Keywords for search==
==Keywords for search==
Line 23: Line 25:
* admit from OR
* admit from OR
* admit from operating room
* admit from operating room
 
* arrive from OR
[[Category: IT Instructions]]
* accept from OR
[[Category: Data Cleaner.mdb]]
}}
[[Category: Data Collection Guide]]
[[Category: Questions Integrity Rules]]

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
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Check_ORDx&oldid=167931"