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

IsNull

Trading Post

Last Post by Anonymous 1 second ago

5 Posts

5 Users

0 Reactions

68 Views

RSS

kmarsh

(@kmarsh)

Posts: 85

Estimable Member

Topic starter

I'm trying to write a crystal report that would return the names of physicians (or nurses, MAs) who do NOT have credential information entered. I tried using IsNull({USR_CREDENTIALEDSTATES.STATE}) but it does not return any names and there should be at least 1 name (a "test" user whose job title is "Physician" but no other info has been entered ). Can anyone help?I'm not even sure I'm looking at the right table.
Thanks
Kate

Posted : August 10, 2016 1:23 pm

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

In CPS the DoctorFacility table contains pertinent fields including: StateLicenseNo, SpecialtyLicenseNo, AdditionalLicenseNo, DEA, NPI. The USR_CredentialedStates contains the states the user is licensed in and dates of licensure, and links to the DoctorFacility table via PVID field. Feel free to contact me directly.

Posted : August 10, 2016 1:46 pm

swhite

(@sbrooks)

Posts: 84

Trusted Member

It has been my experience when you add an account in administration, the suffix is added to the last name for the LastName field in the USR table. But it doesn't always behave.
It is important to me because the MEL symbols like User.LoginName and User.RealName appear to use data out of the USR table not doctorFacility.
I haven't checked since our upgrade to CPS 12.0.12 but User_Roles and User_Title haven't worked properly since we went from 9.5 to version 10. They both return that everyone is a physician. So, I use the MEL lastname and realname to look for suffix credentials in some of my forms and text components to check for/enable/disable items for nurses or assistants versus providers.
I also built a text component that gathers our users into drop down lists based on their credential/sufffix. I have fields all over my forms that give a drop down list of user in credtial groups like all students, all dentists, or all physicians. The drop down is handy for little things like storing the patient's inhouse social worker or behavioral health counselor in an obsterm that I can display in the patient banner. Or if you want to give the physicians a button to send a flag to their nurse with a drop down of all nurses.

Posted : August 11, 2016 4:39 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

In our database the USR_CREDENTIALEDSTATES table is completely empty. I don't know if that is normal. We only operate in one state so maybe if we had more than one it might have data.

I think you should be using the view USRINFO if you are writing it in crystal. The USRINFO view is the same as the USR table without the passowrd info. (crystal will have an access denied on the USR table)

Inside of the USRINFO table you will see columns for: DEANUMBER LICNUMBER PRESCRIBERID NPI UPIN DATA2000.

There is also a column called IS_EP which indicates if they are an Eligible Professional and IS_CREDENT which indicates if they are credentialed.

Posted : August 18, 2016 8:47 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

That's the table we use, so I think you're on the right track. My first thought is to be sure you're doing a LEFT JOIN to the USR_CredentialedStates table, not an INNER.

Posted : August 30, 2016 3:03 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
7 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