Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Problem SQL (ICD9 ICD10 question)

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

5 Users

0 Reactions

70 Views

RSS

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

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

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

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

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

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

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

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

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

DanialSchwartz

(@danialschwartz)

Posts: 2

New Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0