Notifications
Clear all
General Discussion
7
Posts
3
Users
0
Reactions
82
Views
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
Contact me directly, I would be glad to see if I can help you. [email protected]
Posted : December 13, 2015 9:25 am
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
Topic starter
Thank you for this information.
Posted : December 16, 2015 12:18 pm
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
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
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
