Banners being used in Centricity EMR

Trading Post

Last Post by Anonymous 1 second ago

2 Posts

2 Users

0 Reactions

119 Views

RSS

dorotheatrusty

(@dorotheatrusty)

Posts: 148

Reputable Member

Topic starter

Does anyone have a report that shows what banner is being used by what user in Centricity EMR?

Thanks in advance.

Posted : June 7, 2016 6:04 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

This works in Oracle:

select firstname, lastname, prefvalue, grouplist from ml.pref, ml.usrinfo where groupid = pvid and prefname = 'BANNERPREF' and status = 'A' order by pref.prefvalue

Posted : June 7, 2016 12:19 pm

24 Forums
9,943 Topics
39.9 K Posts
8 Online
6,472 Members

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

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