How to Report on all Employee Phone Numbers

Owned by Knowledge Assistant
Jun 05, 2024
1 min read
Description of Issue

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

Context

  • All versions of Enterprise ERP

  • SSRS reports

  • Crystal reports

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

  • Employee Master

Cause

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

Resolution

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.

Additional Information

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