Notifications
Clear all
Topic starter
Does anyone happen to have a report which will run a report on how users have their preferences set up as. We are trying to clean-up our banners and would be sure we do not remove any banners which may be selected as the preferences.
Thanks so much
Posted : June 7, 2016 5:47 am
SQL Script to see who is using the Centricity Standard Banner:
select df.LAST, df.First, df.LoginUser, p.PREFNAME
from PREF p, DoctorFacility df
where p.PREFNAME like'%ban%'
and p.PREFNAME ='STANDARDBANNER'
and p.DoctorFacilityId = df.DoctorFacilityId
and df.Inactive = 0
and p.PREFVALUE <>'F'
SQL Script to see who are not using the Centricity Standard Banner and what Banner they are using:
select df.LAST, df.First, df.LoginUser, p.PREFVALUE
from PREF p, DoctorFacility df
where p.PREFNAME like'%ban%'
and p.PREFNAME <>'STANDARDBANNER'
and p.DoctorFacilityId = df.DoctorFacilityId
and df.Inactive = 0
Posted : June 7, 2016 6:23 am
Here is one from emr. I have a crystal report also if you need it.
SELECT P.PREFNAME, P.PREFVALUE, U.SEARCHNAME, U.STATUS
FROM ML.PREF P INNER JOIN ML.USRINFO U ON P.GROUPID=U.PVID
WHERE U.STATUS='A' AND P.PREFNAME LIKE '%BAN%'
ORDER BY U.SEARCHNAME
Posted : June 7, 2016 7:02 am
Topic starter
If you would please send the Crystal Report to [email protected]
That would be terrific, thanks so much and have a wonderful rest of your week.
Posted : June 7, 2016 10:09 am
