Notifications
Clear all
Topic starter
Before I submit a ticket to the SSO, I want to see if I'm the only one.
We have a custom report that displays the patient's ethnicity for state lead reporting purposes. The report is linked on PERSON.ETHNICITYMID to MEDLISTS.MEDLISTSID. Post upgrade to CEMR 9.12.3 all patients are returning a "No Value" ethnicity. I compared the data dictionaries for both 9.8 and 9.12 and don't see any changes that should impact.
I ran a report of all values in the MEDLISTS table and see that default ethnicity values are still there. I then ran another report of all patients and their PERSON.ETHNICITYMID and they are all null. Has anyone else noticed this and if so do you know how Athena is storing these values now?
Posted : October 28, 2019 3:09 am
Topic starter
Batman to the rescue again! If you folks don't know who Brad Batman is with ISS then you should because he regularly solves our problems!
Batman alerted me to the fact that there is a new table called PATIENTETHNICITY in 9.12. The table appears in the revised data dictionary, but the old ETHNICITYMID field in the PERSON table and associate links are also referenced in the data dictionary.
Adding the new table with the following links solved the issue.
PERSON.PID--->PATIENTETHNICITY.PID--->PATIENTETHNICITY.PATIENTETHNICITYMID--->MEDLISTS.MEDLISTSID
Posted : October 28, 2019 7:05 am
