Notifications
Clear all
Topic starter
Does anyone know what field and table name the Eligible Professional (EP) stored in the the database?
Posted : February 16, 2016 12:23 pm
There is no field for "Eligible Professional". You can search DoctorFacility table for entries with DEA number, NPI, UPIN, State License Number, etc.
Posted : February 16, 2016 12:44 pm
It is in the USR table, generally accessed in Crystal Report as the USERINFO view.
in the field IS_EP
Posted : February 16, 2016 12:58 pm
Topic starter
Thank you, that is exactly what I am looking for, but I don't see IS_EP in the USERINFO view.
Posted : February 17, 2016 5:31 am
For both CPS and C-EMR, you can find IS_EP in the USR table
SELECT IS_EP, USR.*
FROM USR
Hopefully this helps you.
Posted : February 17, 2016 6:01 am
You may need to gain access to the USR table, as by default you may not be able to see it.
If I remember correctly, on the DB, you would issue the following two commands:
Grant all on USR to report;
commit;
Posted : February 17, 2016 6:17 am
Topic starter
AWESOME! Thank you!
Posted : February 17, 2016 7:04 am
