Hello Aashish,
Interesting this conversation has just come up. I have seen this issue ever since 2012 when integrated the EMR mod to our PM mod. I just spent a very large amount of time over the last week updating our user’s credentials with suffix for licensure / signature compliancy.
When a Suffix is added to the User, the USR table gets updated with the new suffix by concatenating the LAST field in the DB (<Last Name> + “ “ + <Suffix> = Smith MD). There is not a Suffix attribute to store this field in the USR table. The issue with the chart area (document provider or user dropdown lists) is the fact that it uses the DOCTORFACILITY table, not the USR table. Interesting fact is the DOCTORFACILITY table has a Suffix attribute available. This is where the bug shows with updating of the tables with new suffix entries on existing users.
Here is what I found with testing the naming fields in the user admin:
- New User entry
- Enter <First> <Last> <Suffix>
- both USR and DOCTORFACILITY table update with all fields
- Suffix will appear in the chart mod
- Existing User Update
- Update <First> <Middle> <Last>
- both USR and DOCTORFACILITY table will update all fields
- change can be seen in the chart mod
- Update Suffix only – ONLY the USR table will update
- NO suffix will appear in the chart mod
- Update (<First> or <Middle> or <Last>) AND add <Suffix
- Suffix will appear in the chart mod
As you can see, I found it was not an issue with the inception of a new user but found the change does not push to both tables when updating an existing user. I was able to determine the catalyst for pushing the suffix field across both the USR and DOCTORFACILITY tables for an existing user is to apply a ‘change’ to one of the name fields at the same time I added the suffix.
Steps to follow when updating an existing user:
- Add suffix
- Apply a change to last name by adding a character on the end (ex. Smith = Smithx)
- Click OK to save changes
- Open the user update screen again
- Change the last name field back (ex. Smithx = Smith)
- Check chart and you will see the suffix appear
Hope this helps. I am saddened to hear from Daniel that this is not fixed in 12.2, especially with the application of EPCS. Would have imagined the data migration across the tables as a priority action. Send me an email if you have any issues or need help walking through the steps.
Best,
Dennis
Posted : March 1, 2017 12:48 am