SSIS Components for ADP

Build 25.0.9434

WorkAssignmentHistoryHomeOrganizationalUnits

The view that returns the historical record of home organizational units for each associate's work assignment. This view identifies an employee's primary business unit over time for historical analysis and payroll allocation.

Columns

Name Type References Description
NameCodeValue String The code value that identifies the name of the home organizational unit assigned to the worker. This field specifies the primary department, division, or team where the worker is based (for example, Operations, Sales, or Human Resources).
NameCodeshortName String The abbreviated name that corresponds to the code for the home organizational unit. This field provides a concise label that is used in dashboards, HR reports, and workforce summaries.
NameCodelongName String The full descriptive name of the code for the home organizational unit. This field provides the complete label that appears in Human Resources (HR) reports, payroll systems, and organizational charts.
TypeCodeValue String The code value that identifies the type of organizational unit (for example, Department, Cost Center, or Business Unit). This field defines the structural classification of the home unit within the organization.
TypeCodeshortName String The abbreviated name that corresponds to the type code for the organizational unit. This field provides a short label for reports and summary views.
TypeCodelongName String The full descriptive name of the type code for the organizational unit. This field provides the complete label used in HR and workforce structure documentation.
itemID String The unique identifier (Id) that represents the specific record for the home organizational unit within the worker's assignment history. This Id enables tracking of changes in primary organizational alignment over time.
AssociateOID String

Workers.AssociateOID

The Id that represents the associate to whom the record for home organizational unit belongs. This field links the organizational assignment to the correct worker profile within HR and payroll systems.

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