The Current Employee Contact report uses the HR Profile - Current Contact Information topic to display a list of employees with current contact information details such as address, phone number, and email address.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee | A to Z | ||
| Address | |||
| Mobile Phone | |||
| Home Phone | |||
| Personal Email | |||
| Business Email |
Custom Fields
This report contains the following custom field:
Address
The Address custom field displays all of the details of the employee's address as one field. It uses the following expression:
CASE WHEN [DenormEmployeeContact].[PrimaryAddress1] IS NOT NULL THEN (([DenormEmployeeContact].[PrimaryAddress1] + (CASE WHEN NULLIF([DenormEmployeeContact].[PrimaryAddress2], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmployeeContact].[PrimaryAddress2], '') + (CASE WHEN NULLIF([DenormEmployeeContact].[PrimaryAddress3], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmployeeContact].[PrimaryAddress3], '') + (CASE WHEN NULLIF([DenormEmployeeContact].[PrimaryAddressCity], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmployeeContact].[PrimaryAddressCity], '') + (CASE WHEN NULLIF([DenormEmployeeContact].[PrimaryAddressStateShortName], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmployeeContact].[PrimaryAddressStateShortName], '') + (CASE WHEN NULLIF([DenormEmployeeContact].[PrimaryAddressPostalCode], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmployeeContact].[PrimaryAddressPostalCode], '') + (CASE WHEN NULLIF([DenormEmployeeContact].[PrimaryAddressCountryShortName], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmployeeContact].[PrimaryAddressCountryShortName],''))) END
Filters
The template includes the following filters: