Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Eligible Professional (EP) in the the database

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

5 Users

0 Reactions

60 Views

RSS

[email protected]

(@omailhotadclinic-com)

Posts: 26

Trusted Member

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

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

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

sonnenbe

(@sonnenbe)

Posts: 33

Trusted Member

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

[email protected]

(@omailhotadclinic-com)

Posts: 26

Trusted Member

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

acantu

(@acantu)

Posts: 722

Prominent Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

[email protected]

(@omailhotadclinic-com)

Posts: 26

Trusted Member

Topic starter

AWESOME! Thank you!

Posted : February 17, 2016 7:04 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
10 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0