Notifications
Clear all
Topic starter
Does anyone know if there is a table and field that would indicate if the "sign clinical list changes" checkbox is marked in a visit. Thanks!
Posted : June 15, 2018 8:51 am
I believe this is it:
select loginname from pref inner join
DoctorFacility df on df.DoctorFacilityId=pref.DoctorFacilityId inner join
usr on usr.pvid=df.PVId
where prefname = 'SignClinicalList' and prefvalue = 'T'
order by prefname
Posted : June 18, 2018 3:56 am
