ADO.NET Provider for Oracle Fusion Cloud HCM

Build 26.0.9770

CompensationPeerSalaryPercentiles

Returns Peer salary percentile analytics comparing a worker's salary against peers with a similar grade, legal employer, and currency.

Columns

Name Type SupportedFinders Description
PersonId Long Unique identifier for the person.
AssignmentId Long FindByAssignmentId, findByAssignmentIdAndDate Unique identifier for a worker assignment.
AssignmentNumber String Unique number for the given assignment.
SalaryId [KEY] Long PrimaryKey, findBySalaryId Unique identifier for the salary.
DateFrom Date Start date for the salary.
DateTo Date End date for the salary.
GradeId Long Unique identifier for the assignment grade.
LegalEntityId Long Unique identifier for the legal entity
AnnualFtSalary Decimal Annual value of the worker's salary, when working full time per adjusted full-time equivalent.
PercentileRank Decimal The salary rank where a particular salary stands relative to the rest of the peer salary data.
Salary25Percentile Decimal Annual FTE salary below which 25% of peers are paid.
Salary75Percentile Decimal Annual FTE salary below which 75% of peers are paid.
MedianSalary Decimal The middle value of all peer annual FTE salaries with active assignments at the same grade, legal employer, and currency.
ErrorWarningMessage String Message text for the error or warning.
GradeCode String Unique code for the assignment grade.
Finder String The named finder used to filter the records returned for this resource.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770