Query Check Renal IncompatibleDxs: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 8: | Line 8: | ||
==Integrity Rule that includes renal Transplant (805)== | ==Integrity Rule that includes renal Transplant (805)== | ||
*here is what we want as an integrity check rule that also includes kidney transplant: | *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. | *'''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''' | '''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) | ||
Revision as of 22:17, 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--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)