Notifications
Clear all
Topic starter
Perhaps, being a Monday, I am simply missing the obvious...
Currently, I can (with Crystal Reports) link Problem.PID to Person.PID and select where Problem.Code begins with "ICD-250" to find all my Diabetic patients. I know this is the ICD-9 code.
Here is the actual syntax:
SELECT "PROBLEM"."CODE"
FROM "ML"."PROBLEM" "PROBLEM"
WHERE "PROBLEM"."CODE" LIKE 'ICD-250%'
So... how do I modify this to request find the new ICD-10 code of "E11.9"?
I am on Logician EMR 9.8
Posted : August 3, 2015 7:30 am
Maybe this:
SELECT “PROBLEM”.”CODE”
FROM “ML”.”PROBLEM” “PROBLEM”
WHERE “PROBLEM”.”CODE” LIKE ‘ICD10-E11%’
In MEL all of the ICD-10 codes have a 'ICD10-' prefix on them. I think that might help you here. Also, I believe that all of E11 is diabetic codes -- however, I might be wrong on that.
Posted : August 3, 2015 8:02 am
Topic starter
Yes, Brad, that is what I was thinking. However, what I currently have in the PROBLEM table for that CODE field appears to only be the ICD (as in ICD9) codes. Must admit that I am not up-to-speed on the ICD10 - is there a conversion program that will need to be run to update the CODE field in the PROBLEM table?
Posted : August 4, 2015 2:09 am
SELECT PROBLEM.* from PROBLEM
INNER JOIN MASTERDIAGNOSIS on PROBLEM.ICD10MASTERDIAGNOSISID = MASTERDIAGNOSIS.MASTERDIAGNOSISID
WHERE MASTERDIAGNOSIS.CODE LIKE 'E11.9'
Posted : August 4, 2015 4:49 am
