Notifications
Clear all
Topic starter
Checking to see if there is a way to print out the Service Provider list from CPS or export into an electronic document.
Posted : February 14, 2019 1:50 am
If you have access to this database, this will pull some information for you. It can be modified to include more:
select name as OrganizationName, PROVLASTNAME + ', ' + PROVFIRSTNAME as ServiceProvider, SPECIALTY as Specialty, SecureElectronicAddress from SERVPROV s
inner join SERVPROVORG sp on s.BUSID = sp.SERVPROVORGID
Posted : February 14, 2019 2:31 am