Tableau Connector for ADP

Build 25.0.9434

WorkAssignmentCustomHistoryCustomGroupAmountFields

The view that returns historical data for custom amount fields that are defined within work-assignment custom groups. This view tracks numeric compensation or allocation values that are associated with each work assignment.

Columns

Name Type References Description
AmountValue Integer The numeric amount that represents the recorded value for the custom history group field. This field is used to capture a measurable figure, such as wages, bonuses, or adjustments that are associated with a worker's historical assignment data.
CategoryCodeCodeValue String The code value that identifies the category assigned to this amount field. This field classifies the amount type for reporting or analytics (for example, Base Pay, Commission, Adjustment, and so on).
CategoryCodeLongName String The full descriptive name of the category code value. This field provides clarity in reports and dashboards by displaying the complete name instead of a coded reference.
CategoryCodeShortName String The abbreviated name that corresponds to the category code. This field provides a concise label that is used in screens, exports, and quick summaries.
CurrencyCode String The three-letter ISO currency code that specifies the currency of the amount value (for example, USD, CAD, or EUR). This field ensures that the monetary value is correctly interpreted in multi-currency reporting environments.
ItemID String The unique identifier (Id) that represents the specific item or entry within the custom history group. This Id is used to differentiate and track individual custom amount records across worker assignments.
NameCodeCodeValue String The code value that identifies the type or name of the custom field recorded in this group. This field defines what the amount represents within the context of the worker's history.
NameCodeLongName String The full name of the code that describes the custom field name. This field provides a clear, human-readable label for data presentation and auditing.
NameCodeShortName String The short name for the code value that identifies the custom field. This field allows for concise display in user interfaces and report headers.
AssociateOID String

Workers.AssociateOID

The Id that represents the associate to whom the historical group amount record belongs. This field links the data to the correct worker profile in Human Resources (HR) and payroll systems.

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