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

Post Oct 1 New ICD-9 / ICD-10 Data Tables CPS12

General Discussion

Last Post by bruins1986 9 years ago

7 Posts

3 Users

0 Reactions

67 Views

RSS

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

We are reaching out to any CHUG practices who extract Family Planning encounters into a spreadsheet for electronic submission for their Family Planning grant.

We are an FQHC and submit Family Planning encounter data into the Title X Region website.

The Oct. 1 switch over to ICD-10 broke our extract. This was discovered in early November when pulling October encounter data. Previous months work fine, but there is no data after Oct 1. We've tried using both ICD-9 and ICD-10 Dx codes but both come up empty.

It appears the ICD-9 and ICD-10 tables have moved or changed names. Being a custom query GE could only provide limited assistance, and pointed us to the table dbo.masterdiagnosis codetype=1. GE referred us to their professional services and has escalated our request. We are still awaiting call back from them.

If your practice has a workable extract, or could give us some help in locating the new ICD tables, please reply to me at [email protected].

Thank you,
Anna

Posted : December 11, 2015 10:49 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Contact me directly, I would be glad to see if I can help you. [email protected]

Posted : December 13, 2015 9:25 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

Hi Anna,

The table that houses the ICD-10 data in GE now (CEMR but I'm sure the same in CPS) is the MASTERDIAGNOSIS table. You need to link the PROBLEM table to this new table via the fields:

PROBLEM.ICD10MASTERDIAGNOSISID joined to MASTERDIAGNOSIS.MASTERDIAGNOSISID

The ICD-10 code (and description) are then found in this new table.

I work in crystal not with SQL so forgive my crystal formatting but the above is what you should need.

Thanks

Mike

Posted : December 15, 2015 6:11 am

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

Thank you for this information.

Posted : December 16, 2015 12:18 pm

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

Thank you. We're taking a look at the data table from Mike's reply and will reach out to you if we run into any roadblocks.

Posted : December 16, 2015 12:18 pm

[email protected]

(@anna-rodriguedfdrussell-org)

Posts: 141

Estimable Member

Topic starter

Thank you Mike.

We are one step closer, but we are still missing one step in between that maybe you or another CHUG user can help us with.

Please see the attached screenshot.Table Mapping Screenshot

With our file extract queries, previously we were able to get everything we needed from the PatientProfile table, the PatientVisit table, and the PatientVisitDiags table. Also we were keying our date range off the visit column in the PatientVisit table.

Now we are trying to link PatientVisit data to the Problem table, and then pull the appropriate ICD-10 code from the MasterDiagnosis table.

How do we link the PatientVisit table to the Problem table and then subsequently to the MasterDiagnosis table?

Thank you.

Posted : January 14, 2016 11:08 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

Sorry anna, those patient visit tables look specific to CPS and I'm a CEMR user, haven't work with them before. Do they publish a data dictionary for CPS like they do for CEMR? Id be curious if it is explained there but I also have a random "try it" theory:

I've found that in CEMR the "code" field in the PROBLEM table is still the ICD-9 code and that the only way to display the ICD-10 is to link the PROBLEM table to the MASTERDIAGNOSIS table like I said above. So, that being said, have you tried running your report/query just like before but only adding in that MASTERDIAGNOSIS table and telling the "output" to be the CODE field from the MASTERDIAGNOSIS (which, if all linked together properly, should be the ICD-10 code).

I'm curious if that will work - when we modified all our existing ICD-9 related reports to fit with ICD-10 we really just did the above (add the new table and display the new field). Plus the above is the "easy way out" for GE since they didn't really have to change any database structures in a major way, they just added a new relational table to be called.

If that doesn't work then sometimes (too rarely but still) GE support is able to provide some guidance on new table linking if you can push hard enough that is.

Thanks

Mike

Posted : January 15, 2016 6:08 am

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