The Current Employee Emergency Contact report uses the HR Profile - Current Contact Information topic to display a list of employees with current emergency contact information details such as contact name, relationship, address, phone number.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee | A to Z | ||
| Emergency Contact 1 | |||
| Contact 1 Relationship | |||
| Contact 1 Address | |||
| Contact 1 Phone | |||
| Emergency Contact 2 | |||
| Contact 2 Relationship | |||
| Contact 2 Address | |||
| Contact 2 Phone |
Custom Fields
This report contains the following custom fields:
Contact 1 Address
The Contact 1 Address custom field displays the first emergency contact's address. It uses the following expression:
CASE WHEN [DenormEmergencyContact].[EmergencyContact1PrimaryAddress1] IS NOT NULL THEN (([DenormEmergencyContact].[EmergencyContact1PrimaryAddress1] + (CASE WHEN NULLIF([DenormEmergencyContact].[EmergencyContact1PrimaryAddress2], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmergencyContact].[EmergencyContact1PrimaryAddress2], '') + (CASE WHEN NULLIF([DenormEmergencyContact].[EmergencyContact1PrimaryAddressCity], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmergencyContact].[EmergencyContact1PrimaryAddressCity], '') + (CASE WHEN NULLIF([DenormEmergencyContact].[EmergencyContact1PrimaryAddressStateShortName], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmergencyContact].[EmergencyContact1PrimaryAddressStateShortName], '') + (CASE WHEN NULLIF([DenormEmergencyContact].[EmergencyContact1PrimaryAddressPostalCode], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmergencyContact].[EmergencyContact1PrimaryAddressPostalCode],'') + (CASE WHEN NULLIF([DenormEmergencyContact].[EmergencyContact1PrimaryAddressCountryShortName], '') IS NULL THEN '' ELSE ', ' END) + ISNULL([DenormEmergencyContact].[EmergencyContact1PrimaryAddressCountryShortName],''))) END
Contact 2 Address
The Contact 2 Address custom field displays the second emergency contact's address. The expression it uses is similar expression the one above for the Contact 1 Address field, but it includes the address fields for the second contact instead of the first.
Contact 1 Phone
The Contact 1 Phone custom field displays the mobile phone and home phone information for the first emergency contact. It uses the following expression:
CASE WHEN DenormEmergencyContact.EmergencyContact1MobilePhone IS NOT NULL THEN 'Mobile: ' + DenormEmergencyContact.EmergencyContact1MobilePhone + CASE WHEN DenormEmergencyContact.EmergencyContact1HomePhone IS NOT NULL THEN ', Home: ' + DenormEmergencyContact.EmergencyContact1HomePhone ELSE '' END WHEN DenormEmergencyContact.EmergencyContact1HomePhone IS NOT NULL THEN 'Home: ' + DenormEmergencyContact.EmergencyContact1HomePhone ELSE NULL END
Contact 2 Phone
The Contact 2 Phone custom field displays the second emergency contact's phone information. The expression it uses is similar expression the one above for the Contact 1 Phone field, but it includes the phone number fields for the second contact instead of the first.
Filters
The template includes the following filters: