Query Check Renal IncompatibleDxs: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
Comorbid [[CRF]] can not be coded with the following diagnoses for the same patient: | Comorbid [[CRF]] can not be coded with the following diagnoses for the same patient: | ||
* [[ARF]] (as instructed by coding guideline) | * [[ARF]] 350 -(as instructed by coding guideline) | ||
* [[ARI]] (as instructed by coding guideline) | * [[ARI]] 364 -(as instructed by coding guideline) | ||
==Discussion== | |||
{{Discussion}} | |||
* [[ATN]] 352 - must be included here also. This is missing from integrity check.--[[User:TOstryzniuk|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--[[User:TOstryzniuk|TOstryzniuk]] 21:08, 21 January 2010 (CST) | |||
== Administration == | == Administration == | ||
Revision as of 22:08, 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.--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)
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)