SSIS Components for ADP

Build 25.0.9434

WorkAssignmentCustomHistoryCustomGroupDateTimeFields

The view that returns historical data for date-time fields that are defined in work-assignment custom groups. This view captures both date and timestamp information for work-assignment changes and related Human Resources (HR) events.

Columns

Name Type References Description
CategoryCodeCodeValue String The code value that identifies the category associated with this custom-group field. This field classifies the date and time record by business or payroll category (for example, Attendance, Scheduling, Compliance, and so on).
CategoryCodeLongName String The full descriptive name of the category code value. This field provides the complete label that appears in reports and analytics for date and time records.
CategoryCodeShortName String The short or abbreviated name that corresponds to the category code. This field provides a simplified label that is used in dashboards, exports, and compact layouts.
DateTimeValue Datetime The date and time value that represents a specific moment recorded within the custom history group. This field captures precise timestamps for events related to a worker's assignment (for example, clock-in time, approval timestamp, or policy activation date).
ItemID String The unique identifier (Id) that represents the specific custom-group datetime entry. This Id is used to differentiate and track individual timestamped records within a worker's historical assignment data.
NameCodeCodeValue String The code value that identifies the name of the custom field that is being tracked in this group. This field defines the purpose or type of datetime information recorded in the worker's history.
NameCodeLongName String The full name of the code that describes the custom field name. This field provides a complete, human-readable description for reporting and audit review.
NameCodeShortName String The abbreviated name that corresponds to the name code. This field provides a short reference label for use in summaries, dashboards, and reports.
AssociateOID String

Workers.AssociateOID

The Id that represents the associate to whom this custom-group datetime record belongs. This field links the timestamped entry to the correct worker profile within HR and payroll systems.

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