The view that returns personal and emergency contact information for each associate. This view includes contact names, relationships, and communication details. This view supports compliance with workplace safety and Human Resources (HR) record-keeping requirements.

Table Specific Information

Select

The connector uses the ADP API to process WHERE clause conditions built with the AssociateOID column and '=' operator.

For example, the following queries are processed server-side:

SELECT * FROM PersonalContacts WHERE AssociateOID = 'G3349PZGBADQY8H7'

The rest of the filter is executed client-side within the connector.

Columns

Name	Type	References	Description
PersonName	String		The full name of the personal contact that is associated with the associate's record. This field identifies the individual designated as an emergency or personal contact in ADP.
AddressLine1	String		The first line of the contact's address. This field typically contains the street address or primary location information.
AddressLine2	String		The second line of the contact's address. This field provides space for apartment, suite, or building details that are associated with the contact.
AddressLine3	String		The third line of the contact's address. This field is used for additional address information when needed for international or multi-line formatting.
AddressCityName	String		The name of the city in which the contact resides. This value supports location-based reporting and correspondence.
AddressCountrySubdivisionLevel1SubdivisionType	String		The type of country subdivision (for example, State, Province, or Region) that is associated with the contact's address. This field standardizes geographic categorization.
AddressCountrySubdivisionLevel1Code	String		The code that identifies the first-level country subdivision that corresponds to the contact's address. This code ensures regional accuracy in HR records and reporting.
AddressCountrySubdivisionLevel1ShortName	String		The short descriptive name that represents the first-level country subdivision code. This field provides a readable label for use in dashboards and reports.
AddressCountrySubdivisionLevel1LongName	String		The long descriptive name that corresponds to the first-level country subdivision code. This field provides a complete region or state name for display and documentation.
AddressCountryCode	String		The code that identifies the country of the contact's address. This code ensures proper international standardization across ADP systems.
AddressPostalCode	String		The postal code that is associated with the contact's address. This value supports mailing accuracy and regional analysis.
CommunicationLandlines	String
CommunicationMobiles	String
CommunicationEmails	String
ContactTypeCode	String		The code that identifies the type of contact (for example, Emergency, Personal, or Dependent). This code supports classification and prioritization of contacts.
ContactTypeCodeShortName	String		The short descriptive name that corresponds to the contact type code. It provides a concise label for use in reports and HR systems.
RelationshipTypeCode	String		The code that identifies the type of relationship between the associate and the contact (for example, Spouse, Parent, or Friend). This code supports accurate representation of personal relationships in HR records.
RelationshipTypeCodeShortName	String		The short descriptive name that corresponds to the relationship type code. This field provides a readable label for dashboards and reporting.
PrecedenceCode	String		The code that identifies the contact precedence or ranking order (for example, Primary or Secondary). This code determines the order of priority when multiple contacts exist.
PrecedenceCodeShortName	String		The short descriptive name that corresponds to the precedence code. This field provides a readable label for use in dashboards and contact lists.
ItemID	String		The unique identifier (Id) that represents the personal contact record. This Id distinguishes one contact entry from another within the associate's profile.
AssociateOID	String	Workers.AssociateOID	The Id that identifies the associate to whom the personal contact belongs. This Id links the contact record to the associate's employment data in ADP.