Notifications
Clear all
Topic starter
Does anyone know where the MPI # is stored in the EMR Database? This is a number that we use in billing, Horizon Practice Plus system. I'm not sure if its specific to that system or if it is a number that originated with Centricity. We can pull it up in patient registration, however, having difficulty finding where it is stored in the database.
If anyone knows the table and field name it would be extremely helpful.
Posted : November 26, 2012 11:09 pm
Where does it show up in Registration?
Posted : November 26, 2012 11:58 pm
Topic starter
Ernie,
This number is selectable by a user that can update registration. It is located where Patient # field is when changing the registration of a patient.
This is to the right of the Status field and above the Social Security # field. When changing IDs there is a drop down list with the following options. ChartScript, DAL, MPI (the number i am trying to find), ppm_id, Preload, PtLink,ZZOLDDAL, ZZZOLDMPI.
If you know where this information may be stored please let me know.
Thanks,
Damon
Posted : November 27, 2012 12:20 am
Topic starter
This is just an update.
I was able to locate the MPI# in the EMR database. It was stored in the EXTID table. This table stores various types of external IDs beyond the ExternalID in the PERSON table.
MPI # was stored in this table. The table has InternalID (which is the PID in the PERSON table) and ExternalID, which is the MPI, DAL, ppm_id, etc.
You have to link the EXTIDSPACE table on EXTERNALSPACE ID in order to get the EXTIDSPACE.DESCRIPTION which tells you what type of ID it is. In this case EXTIDSPACE.DESCRIPTION = MPI.
Hopefully this will help someone who is trying to locate this data in the tables.
Posted : November 28, 2012 12:20 am
