Notifications
Clear all
Topic starter
Before I dive into it and try to reverse engineer it, can anyone quickly tell me how the problems, masterdiagnosis, and any other relevant tables relate?
just downloaded the latest version of the "schema" and it is far less helpful than what used to be put out with versions 5 and below (shocker I know).
trying to pull a "quick" query of most used problems. The current ICD9 code, the description, the and the automatched ICD10 code (and potential description of that) or null value
I haven't gone through all the ICD webinars/resources yet, but don't recall seeing this, but seems like something a lot of people would want, vs. going in person by person as they schedule appointments as I think i read the "reccomended workflow" to be, with the super helpful form that launches the problem list (oh and populates and obs term that they have been "converted" and banner kit.
thanks.
Posted : August 2, 2015 6:10 pm
Use the ML_PROBLEMCODEMAP table to match ICD-9 to ICD-10 and vice versa. It's in the 9.8 data dictionary.
Posted : August 3, 2015 2:38 am
Unfortunately, you need the CPS12 Data Dictionary. It is HTML format, not paper. There are new tables in CPS12, e.g. MasterDiagnosis, fields, etc. Although it takes some effort to understand the structure of the Data Dictionary, it is worth the effort as it is the gold standard. There is no nice graphical display per 9.5.
Posted : August 3, 2015 6:20 am
SP10 Release Notes state that there will be a CR that will identify the non-billable problems in a patients chart. They say that it's already available on the service portal, but I couldn't find it. I requested it via a post on the CEMR ICD-10 Community. I'll keep you posted.
Posted : August 3, 2015 9:47 am
Problems links to masterdiagnosis in 3 fields, ICD9MASTERDIAGNOSISID, ICD10MASTERDIAGNOSISID and SNOMEDMASTERDIAGNOSISID. These all link to the masterdiagnosis.masterdiagnosisid. You can then use masterdiagnosis.code to search by code.
For example:
SELECT PROBLEM.* from PROBLEM
INNER JOIN MASTERDIAGNOSIS on PROBLEM.ICD10MASTERDIAGNOSISID = MASTERDIAGNOSIS.MASTERDIAGNOSISID
WHERE MASTERDIAGNOSIS.CODE LIKE 'E11.9'
Posted : August 4, 2015 6:55 am
That is true, ICD-10 makes it look scary and it actually is scary. I am working on to get things settled with my providers
Posted : August 6, 2015 6:35 am
