Query Check Renal IncompatibleDxs: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 11: | Line 11: | ||
'''OR''' | '''OR''' | ||
'''IF''' Comorbid DX (any slot) is 351 '''AND''' Admit DX (any slot) is (350, 352, 364) then = Error--[[User:TOstryzniuk|TOstryzniuk]] 21:08, 21 January 2010 (CST) | '''IF''' Comorbid DX (any slot) is 351 '''AND''' Admit DX (any slot) is (350, 352, 364) then = Error--[[User:TOstryzniuk|TOstryzniuk]] 21:08, 21 January 2010 (CST) | ||
*[http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q2.11_-_Additional_check click here to see rule]--[[User:TOstryzniuk|TOstryzniuk]] 21:17, 21 January 2010 (CST) | *[http://ltc.umanitoba.ca/wikis/ccmdb/index.php/!_Automated_Data_Integrity_Checks#Q2.11_-_Additional_check click here to see rule request to move to ccmdb.mdb]--[[User:TOstryzniuk|TOstryzniuk]] 21:17, 21 January 2010 (CST) | ||
== Administration == | == Administration == | ||
Revision as of 22:18, 21 January 2010
Comorbid CRF can not be coded with the following diagnoses for the same patient:
Discussion
- ATN 352 - must be included here also. This is missing from integrity check. see rule here.--TOstryzniuk 21:08, 21 January 2010 (CST)
Integrity Rule that includes renal Transplant (805)
- here is what we want as an integrity check rule that also includes kidney transplant:
- IF Comorbid DX (any slot) is 351 AND Complication/Acquired DX (any slot) is 805 AND Admit DX (any slot) is (350, 352, 364) then = Error.
OR IF Comorbid DX (any slot) is 351 AND Admit DX (any slot) is (350, 352, 364) then = Error--TOstryzniuk 21:08, 21 January 2010 (CST)
- click here to see rule request to move to ccmdb.mdb--TOstryzniuk 21:17, 21 January 2010 (CST)
Administration
Hardcoded in query Check_Renal_IncompatibeDXs in CCMDB.mdb.
Start Date
Sept 2009 (see Log)
Errors Scenarios
Patient has both ARF and CRF
Status
being implementedCCMDB.mdb_Change_Log_2009#v1.90. Ttenbergen 15:50, 29 September 2009 (CDT)