Check ORDx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m S alldiagnoses OR moved to Check ORDx: More descriptive name, and also this will be the name of the table in CCMDB.mdb
No edit summary
Line 1: Line 1:
Some diagnoses '''qualify''' a patient for OR times, and of those, some '''require''' OR time. Table s_alldiagnoses_OR will list these for use in cross-checks in [[CCMDB.mdb]] and [[Data Cleaner.mdb]].  
Some diagnoses allow a patient to be [[Admit From & Discharged To | admitted from]] from the OR/Recovery, others require it.  


*The list of "required " was completed August 27.09 at 8 PM.  The table can be found on X Drive in data cleaner in the program [[Data Cleaner.mdb]]. It is called X_OR_Diagnosis.  Not implemented to [[CCMDB.mdb]] yet.--[[User:TOstryzniuk|TOstryzniuk]] 17:30, 21 September 2009 (CDT)
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.  


Also see [[DX not always to OR so no T96]] which needs to be brought into here when the wiki isn't so hideously slow. [[User:Ttenbergen|Ttenbergen]] 17:15, 4 September 2009 (CDT)
== 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 ===
* 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.
* 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]]
Hey Trish,
[[Category: Data Collection Guide]]
 
I just had a look at X_OR_Diagnoses table in Data_cleaner.mdb. It looks like ALL diagnoses in there have the OR Required field checked. The idea was to have all those diagnoses who qualify for OR listed in the table, and only those who require OR checked. Is that what you understood as well? If so, they should not all be checked.
 
When we get to a more stable version of the table I will move it into the master ccmdb.mdb, and from then on get Pagasa to pull from a copy of the master (probably a directory “Pagasa” under the “Programs” folder, so we no longer have to manually update her program, which never seems to happen.
 
T

Revision as of 10:51, 23 September 2009

Some diagnoses allow a patient to be admitted from from the OR/Recovery, others require it.

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.

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

  • 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.
  • Check [1] to see if this will be included here.
  • [2] will need to be updated in datacleaner.mdb to draw from new table
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Check_ORDx&oldid=14653"