PersonalContacts
Personal emergency contacts.
Table Specific Information
Select
The provider 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 provider.
Columns
| Name | Type | References | Description |
| PersonName | String | ||
| AddressLine1 | String | ||
| AddressLine2 | String | ||
| AddressLine3 | String | ||
| AddressCityName | String | ||
| AddressCountrySubdivisionLevel1SubdivisionType | String | ||
| AddressCountrySubdivisionLevel1Code | String | ||
| AddressCountrySubdivisionLevel1ShortName | String | ||
| AddressCountrySubdivisionLevel1LongName | String | ||
| AddressCountryCode | String | ||
| AddressPostalCode | String | ||
| CommunicationLandlines | String | ||
| CommunicationMobiles | String | ||
| CommunicationEmails | String | ||
| ContactTypeCode | String | ||
| ContactTypeCodeShortName | String | ||
| RelationshipTypeCode | String | ||
| RelationshipTypeCodeShortName | String | ||
| PrecedenceCode | String | ||
| PrecedenceCodeShortName | String | ||
| ItemID | String | ||
| AssociateOID | String |
Workers.AssociateOID |