PersonalContacts

Personal emergency contacts.

Table Specific Information

Select

The add-in 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 add-in.

Columns

References Description String String String String String String String String String String String String String String String String String String String String String String

Name Type style="white-space:nowrap">PersonName AddressLine1 AddressLine2 AddressLine3 AddressCityName AddressCountrySubdivisionLevel1SubdivisionType AddressCountrySubdivisionLevel1Code AddressCountrySubdivisionLevel1ShortName AddressCountrySubdivisionLevel1LongName AddressCountryCode AddressPostalCode CommunicationLandlines CommunicationMobiles CommunicationEmails ContactTypeCode ContactTypeCodeShortName RelationshipTypeCode RelationshipTypeCodeShortName PrecedenceCode PrecedenceCodeShortName ItemID AssociateOID e-workers.htm">Workers.AssociateOID

Excel Add-In for ADP

PersonalContacts

Table Specific Information

Select

Columns