Power BI Connector for ADP

Build 25.0.9454

WorkAssignmentHistoryAdditionalRemunerations

The view that returns historical records of additional remunerations that are associated with work assignments. This view captures supplemental earnings (for example, bonuses or allowances) that are applied to past payroll periods for auditing and reconciliation.

Columns

Name Type References Description
TypeCodeValue String The code value that identifies the type of additional remuneration assigned to the worker. This field classifies supplemental pay categories (for example, Bonus, Commission, or Allowance).
TypeCodeCodeshortName String The abbreviated name that corresponds to the additional-remuneration type code. This field provides a concise label used in Human Resources (HR) and payroll reports.
TypeCodeCodelongName String The full descriptive name of the additional-remuneration type code. This field provides the complete label displayed in HR, payroll, and compensation analytics.
IntervalCodeCodeValue String The code value that identifies the interval or frequency associated with the additional remuneration (for example, Weekly, Monthly, or Annual). This field defines how often the remuneration is applied.
IntervalCodeCodeCodeshortName String The abbreviated name that corresponds to the remuneration interval code. This field provides a short label for dashboards and payroll reports.
IntervalCodeCodeCodelongName String The full descriptive name of the remuneration interval code. This field provides the complete label that appears in HR and payroll documentation.
NameCodeCodeValue String The code value that identifies the name or type of the additional remuneration record. This field defines what the remuneration represents within the worker's compensation history.
NameCodeCodeCodeshortName String The abbreviated name that corresponds to the remuneration name code. This field provides a short label for quick reference in dashboards and HR reports.
NameCodeCodeCodelongName String The full descriptive name of the remuneration name code. This field provides a complete label used in payroll configuration and compensation analysis.
RateAmountValue Integer The numeric value that represents the rate amount for the additional remuneration. This field defines the specific monetary value that is applied during payroll processing.
RateCurrencyCode String The three-letter ISO currency code that identifies the currency in which the remuneration amount is paid (for example, USD, CAD, or GBP). This field ensures consistency in multi-currency payroll environments.
RateUnitCode String The code value that identifies the unit of measure associated with the remuneration rate (for example, Hourly, Daily, or Annual). This field defines how the rate is calculated or applied.
RateshortName String The abbreviated name that corresponds to the remuneration rate code. This field provides a short label for display in dashboards and summary reports.
RateLongName String The full descriptive name of the remuneration rate code. This field provides the complete label used in HR and payroll documentation.
RateBaseUnitCode String The code value that identifies the base unit of measure that is used to determine the remuneration rate (for example, Hour, Day, or Month). This field defines the unit basis for payroll calculations.
RateBaseshortName String The abbreviated name that corresponds to the base unit code for the remuneration rate. This field provides a concise label for reports and dashboards.
RateBaseLongName String The full descriptive name of the base unit code for the remuneration rate. This field provides a clear label that appears in HR, payroll, and compensation reports.
BaseMultiplierValue Integer The numeric multiplier value that is applied to the base rate to calculate the final remuneration amount. This field supports pay differentials and complex compensation structures.
ItemID String The unique identifier (Id) that represents the specific additional remuneration record within the worker's assignment history. This Id enables tracking and audit of supplemental pay transactions.
EffectiveDate Date The date on which the additional remuneration becomes effective. This field is used to determine when the change or adjustment takes effect in payroll processing.
AssociateOID String

Workers.AssociateOID

The Id that represents the associate to whom this additional remuneration record belongs. This field links the pay record to the correct worker profile within HR and payroll systems.

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