SSIS Components for ADP

Build 25.0.9434

WorkAssignmentHistoryCommunicationsEmails

The view that returns historical email communication details that are associated with work assignments. This view maintains a record of email addresses used by workers over time for internal correspondence and audit verification.

Columns

Name Type References Description
EmailUri String The uniform resource identifier (URI) that represents the worker's email address. This field stores the primary or alternate email contact used for official communications (for example, work, personal, or notification).
ItemID String The unique identifier (Id) that represents the individual email record within the worker's communication history. This Id enables tracking of historical contact information across assignment periods.
NameCodeCodeValue String The code value that identifies the type of email address associated with the worker. This field defines the classification of the email (for example, Business, Personal, or Emergency Contact).
NameCodeLongName String The full descriptive name of the email-address type code. This field provides the complete label that appears in Human Resources (HR) reports and communication records.
NameCodeShortName String The abbreviated name that corresponds to the email-address type code. This field provides a short label for dashboards, reports, and HR analytics.
AssociateOID String

Workers.AssociateOID

The Id that represents the associate to whom this email record belongs. This field links the communication record to the correct worker profile in HR and payroll systems.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434