Supported operations
| DELETE /salaries/{id} |
| GET /salaries |
| GET /salaries/{id} |
| PATCH /salaries/{id} |
| POST /salaries |
Queryable q fields (76)
Only these fields can appear in a q filter expression on
/salaries. Filtering on any other field returns
400 Bad Request.
Example q request
GET /hcmRestApi/resources/11.13.18.05/salaries?q=ActionCode='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| ActionCode | string | = != |
| ActionId | integer | = != |
| ActionName | string | = != |
| ActionOccurrenceId | integer | = != |
| ActionReason | string | = != |
| ActionReasonCode | string | = != |
| ActionReasonId | integer | = != |
| AdjustedAnnualFtSalary | number | = != |
| AdjustedAnnualSalary | number | = != |
| AdjustedFTEUsage | string | = != |
| AdjustedFTEValue | number | = != |
| AdjustmentAmount | number | = != |
| AdjustmentPercentage | number | = != |
| AmountDecimalPrecision | number | = != |
| AmountRoundingCode | string | = != |
| AnnualFullTimeSalary | number | = != |
| AnnualRoundingCode | string | = != |
| AnnualSalary | number | = != |
| AssignmentId | integer | = != |
| AssignmentNumber | string | = != |
| AssignmentType | string | = != |
| BusinessTitle | string | = != |
| Code | string | = != |
| CompaRatio | number | = != |
| ComponentUsage | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| CurrencyCode | string | = != |
| DateFrom | string | = != |
| DateTo | string | = != |
| DisplayName | string | = != |
| DisplaySalaryAmount | number | = != |
| FTEValue | number | = != |
| FrequencyName | string | = != |
| GeographyName | string | = != |
| GeographyTypeName | string | = != |
| GradeCode | string | = != |
| GradeId | integer | = != |
| GradeLadderName | string | = != |
| GradeName | string | = != |
| GradeStepName | string | = != |
| LastUpdateDate | string | = != |
| LastUpdatedBy | string | = != |
| LegalEmployerName | string | = != |
| LegislativeDataGroupId | integer | = != |
| MultipleComponents | string | = != |
| NextSalReviewDate | string | = != |
| PayrollFactor | number | = != |
| PayrollFrequencyCode | string | = != |
| PendingTransactionExists | string | = != |
| PersonDisplayName | string | = != |
| PersonId | integer | = != |
| PersonNumber | string | = != |
| Quartile | string | = |
| QuartileMeaning | string | = != |
| Quintile | string | = |
| QuintileMeaning | string | = != |
| RangeErrorWarning | string | = != |
| RangePosition | number | = != |
| RangeRoundingCode | string | = != |
| SalaryAmount | number | = != |
| SalaryAmountScale | integer | = != |
| SalaryBasisId | integer | = != |
| SalaryBasisName | string | = != |
| SalaryBasisType | string | = != |
| SalaryFactor | number | = != |
| SalaryFrequencyCode | string | = != |
| SalaryId | integer | = != |
| SalaryRangeDefaultValue | number | = != |
| SalaryRangeMaximum | number | = != |
| SalaryRangeMidPoint | number | = != |
| SalaryRangeMinimum | number | = != |
| SalaryTransactionStatus | string | = != |
| SearchDate | string | = != |
| WorkAtHome | string | = != |
| hasFutureSalary | string | = != |
Child resources (3)
Each child is reachable at
/salaries/{id}/child/<name>
and most can also be inlined with expand.
salaryComponentssalaryPayRateComponentssalarySimpleComponents Response fields (79)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
ActionCodeActionIdActionNameActionOccurrenceIdActionReasonActionReasonCodeActionReasonIdAdjustedAnnualFtSalaryAdjustedAnnualSalaryAdjustedFTEUsageAdjustedFTEValueAdjustmentAmountAdjustmentPercentageAmountDecimalPrecisionAmountRoundingCodeAnnualFullTimeSalaryAnnualRoundingCodeAnnualSalaryAssignmentIdAssignmentNumberAssignmentTypeBusinessTitleCodeCompaRatioComponentUsageCreatedByCreationDateCurrencyCodeDateFromDateToDisplayNameDisplaySalaryAmountFTEValueFrequencyNameGeographyNameGeographyTypeNameGradeCodeGradeIdGradeLadderNameGradeNameGradeStepNameLastUpdateDateLastUpdatedByLegalEmployerNameLegislativeDataGroupIdMultipleComponentsNextSalReviewDatePayrollFactorPayrollFrequencyCodePendingTransactionExistsPersonDisplayNamePersonIdPersonNumberQuartileQuartileMeaningQuintileQuintileMeaningRangeErrorWarningRangePositionRangeRoundingCodeSalaryAmountSalaryAmountScaleSalaryBasisIdSalaryBasisNameSalaryBasisTypeSalaryFactorSalaryFrequencyCodeSalaryIdSalaryRangeDefaultValueSalaryRangeMaximumSalaryRangeMidPointSalaryRangeMinimumSalaryTransactionStatusSearchDateWorkAtHomehasFutureSalarysalaryComponentssalaryPayRateComponentssalarySimpleComponents Build this query visually in OPAL
OPAL bundles this endpoint — and 59,000+ more — fully searchable offline, with a visual Q Builder and Finder Builder that only offer the fields listed above, so your filter can't 400. Download free · see features.
Related reference & reading
- /absences Get all absence records
- /learnerLearningRecords Get all assignment records
- /positions Get all positions
- /recruitingJobRequisitions Get all recruiting job requisitions
- /personProcessResults Unique identifier for the payroll
- Oracle HCM API guide
- Why the q parameter fails and how to fix it
- Finders: named queries in Oracle Fusion REST APIs
- All endpoint reference pages