Notifications
Clear all
Topic starter
Good Day CHUGgers!!!!
As we end the year and are looking to wrap up our Meaningful Use Reporting, we are seeing a large number of providers are failing on Record Patient Demographics in CQR.
Investigating this further using 1 provider, he has a small number of successful patients in this category, but many who have failed. Looking deeper, the only thing that I can tag as being a pattern is that all of the failed patients have: PATIENT DECLINED (exact spelling and case) set on Ethnicity.
Is there a standard spelling, casing for patient declined? Should there be some standard code set in the MIK settings or Admin section of CPS to correctly have this be successful in CQR?
Any thoughts? Anyone else having issues with this particular measure? Anything that I need to look at from a system configuration standpoint?
Happy New Year to all of you. Hopefully next year will be a better CPS/EMR year.
Posted : December 31, 2014 8:16 am
Jim,
Our Crystal Report for demographics looks for "Declined". Here's our MIK setup for ethnicity:
http://screencast.com/t/dcfhxuBcO
We're on CPS11
Note: I don't know how this relates to CQR, other than I'd guess it looks for the same values in the database.
David Cowes
Michigan State University
Posted : December 31, 2014 9:24 am
Topic starter
Thank you. Yes, our numbers looked good too on the Crystal Reports until we upgraded to CPS12 and CQR.
I have double checked my MIK configurations and believe that I may have stumbled onto a situation that not all things are "configured equally". I have corrected this and am waiting for CQR to process my changes so that I can test against some of my failing providers.
Thank you for your assistance on this matter.
Posted : December 31, 2014 9:33 am
I was just looking at this.
We had a large number fail on demograhics and it seems it is due to Undetermined in Ethnicity.
I checked the mappings for ethnicity and ethnicity sub categories in Admin.
Ethnicity has a value of Unspecified.
So in my sub categories for ethnicity I made sure the values for undetermined and declined have the ethnicity field set to the Ethnicity value Unspecified & and copied the HL7 code 1231-1 from Ethnicity Unspecified to my Ethnicity Sub Category Undetermined HL7 field.
I plan to request data today and I'll see the effect of the new mappings on Monday when I'm back in the office.
Let me know if you want to know how it turned out.
[email protected]
Posted : December 31, 2014 10:24 am
We also fail on Demographics, but due to the format of Language coming in via a demographic interface.
I've tried all the different HL7s variations but still haven't nailed down exactly what EMR (9.8x) wants for Language in the PID.
I was able to run an SQL to fix the data on PERSON.LANGUAGEID and see the numbers change dramatically on CQR. Worst-case, I'll have that run as an automatic every-night fix.
Posted : January 5, 2015 10:51 am
Topic starter
How interesting!!!! Is there some MASTER table for language that CQR is looking for? I'm wondering if this is part of our problem.
jamesedward, would you mind sharing your SQL, either directly or paraphrased?
Jim --> [email protected]
Posted : January 6, 2015 7:17 am
There is a language table and what I've found is the CQR only counts languages that are ISO-639.2 languages ("official" languages). If you google that you can see a full list.
What I found is that all of the "factory" languages counted, I've never been able to get a custom/free text/user entered language to count in the CQR (we are still in the testing phase). In the language table itself there is a column called "owner" that indicates if it is factory or custom.
We have issues with our interfacing PM systems (some of them) related to how languages cross into the registration piece of the EMR but thankfully we are lucky enough that about 90% of all of our patients have "factory" languages. Our plan is to move forward as is and if providers are not making it the languages can be updated near the end of the reporting period to get us/them over the 80%.
Posted : January 6, 2015 9:08 am
Topic starter
Thanks for the reference information. I will pursue that and see if we have all the languages set up correctly in CPS Admin and MIK.
Posted : January 6, 2015 9:36 am
Topic starter
Ladies and Gentlemen,
With the assistance of GE, we have figured out why we were failing miserably on RECORD DEMOGRAPHICS. CQR is expecting the spelling/case of the various options for Ethnicity to be first Upper then lowercase, whereas our original database had all UPPERCASE. See the database update commands that I ran last night to fix our tables.
update MedLists set Description = 'Patient Declined' where TableName = 'Ethnicity' and Description = 'PATIENT DECLINED';
update MedLists set Description = 'State Prohibited' where TableName = 'Ethnicity' and Description = 'STATE PROHIBITED';
update MedLists set Description = 'Hispanic or Latino' where TableName = 'Ethnicity' and Description = 'HISPANIC OR LATINO';
Then export patients with the 'Patient Declined' ethnicity via Chart Report > Inquiries
Posted : January 13, 2015 8:00 am
Hi All,
Before starting my own post I figured I'd try hear since it is pretty much the same issue.
We've been testing demographics and noticed a lot of oddities like everyone else. The main one I am focused on now is Race. For example: we have a multiracial subcategory that is mapped to unspecified. It "passed" for one patient and not another although I was expecting neither to pass.
Following that I ran a report that pulls the race for our test patients and noticed that one of those patients showed "race" as White and the other blank- the EMR has multiracial for both. I suspect this is why one passed (the person who had white show in the report is passing). My big question is why is the report not reflecting the demographics I see? Does something need to trigger for this to update the table (that makes no sense to me but...)? Has anyone else noticed this? I brought it up at a roundtable but the person present, although very good with the CQR workflow, didn't know the GE table structure to provide additional insight.
I am not good a sql but I may try to have someone come up with a way to pull this field directly from our DB instead of through Crystal to just rule out that I am structuring the table links improperly or misunderstanding the MEDLIST table.
My email is [email protected] if anyone would rather reach out directly then post.
Thanks in advance,
Mike
Posted : January 14, 2015 6:33 am
We are having the same issue. There is a SPR for this CQR :
CISDB00059335 , "When running inquiry for patients with a particular race, the results are 0."
Posted : January 14, 2015 10:10 am
My demographics numbers went from 98% in Crystal Reports to 2% in CQR; it turned out our install was missing the HL7 code from Server Setup for our "White" patients. Replaced it, redigested, numbers are back to where they used to be. Or at least they were, now CQR says no data for everything. :/
Posted : February 1, 2015 10:14 am
