How to Report on all Employee Phone Numbers

User would like to report on all phone numbers for an employee.

• All versions of Enterprise ERP

• SSRS reports

• Crystal reports

• SaaS, Tyler-hosted clients

• OnPrem, Self-hosted clients

• Employee Master

Primary phone numbers and alternative numbers are stored in two different Tyler Reporting Services Views.

The primary number for an employee is e_home_phone in pr_employee_master. All alternative numbers will be found in pr_employee_phone. If you want them combined, we recommend creating a union of both objects.

SELECT

a_employee_number

,  e_home_phone

, 'Primary' as [Type]

, e_primary_text_opt_in

FROM pr_employee_master 

 UNION

SELECT DISTINCT

 a_employee_number

, e_phone_number

 , ph_phone_type

, e_phone_text_opt_in

FROM pr_employee_phone