Check ORDx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
No edit summary
 
(18 intermediate revisions by 2 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
 
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 ==
== Errors Scenarios ==
Line 5: 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'')


 
== Cross checks ==
== {{CCMDB Data Integrity 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.
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 [[User:Ttenbergen|Ttenbergen]] 15:46, 29 September 2009 (CDT)
Implemented [[User:Ttenbergen|Ttenbergen]] 15:46, 29 September 2009 (CDT)
== {{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){{Potential Change}}
* Has anything make it through lately, otherwise we should stop doing this in cleaner. Ttenbergen 13:37, 2012 November 5 (EST){{discussion}}


==Keywords for search==
==Keywords for search==
Line 22: Line 25:
* admit from OR
* admit from OR
* admit from operating room
* admit from operating room
 
* arrive from OR
 
* accept from OR
[[Category:Cleaner.mdb Data Integrity Checks]]
}}
[[Category:CCMDB Data Integrity Checks]]

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"