ODBC Driver for ADP

Build 26.0.9655

WorkAssignmentHistoryCommunicationsSocialNetworks

The view that returns historical social-network contact information that is linked to work assignments. This view captures professional network Ids used in Human Resources (HR) systems for profile completeness and compliance documentation.

View-Specific Information

Select

The driver uses the ADP API to process WHERE clause conditions built with the following column and operator. The AssociateOID is required to make a request, while the remaining filters are executed client-side within the driver.

  • AssociateOID supports the = operator.
For example:
SELECT * FROM WorkAssignmentHistoryCommunicationsSocialNetworks WHERE AssociateOID = 'AOID4J5VGEX1620N';

Columns

Name Type References Description
ItemID String The unique identifier (Id) that represents the individual social-network communication record within the worker's contact history. This Id enables tracking of external communication channels across assignments and HR systems.
NameCode.codeValue String The code value that identifies the classification of the social-network account. This field defines the platform or type of social connection (for example, LinkedIn, X (formerly Twitter), or Yammer).
NameCode.longName String The full descriptive name of the type code for the social-network account. This field provides the complete label that appears in HR communication directories and reports.
NameCode.shortName String The abbreviated name that corresponds to the type code for the social-network account. This field provides a concise label for dashboards, summaries, and HR analytics.
Uri String The uniform resource identifier (URI) that represents the worker's social network address. This field stores the profile link or network handle that is used for professional communication and collaboration.
AssociateOID String

Workers.AssociateOID

The Id that represents the associate to whom this social-network record belongs. This field links the communication record to the correct worker profile within HR and payroll systems.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655