JDBC Driver for ADP

Build 24.0.9062

PersonalContacts

Personal emergency contacts.

Table Specific Information

Select

The 本製品 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 本製品.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062