Power BI Connector for Oracle Fusion Cloud HCM

Build 24.0.9060

SalariessalarySimpleComponents

SalariessalarySimpleComponents

Columns

Name Type Description
SalariesSalaryId [KEY] Long SalariesSalaryId of SalariessalarySimpleComponents
AdjustmentAmount Decimal Change amount for a simple component.
AdjustmentPercent Decimal Change percentage for a simple component.
Amount Decimal Amount of the person's salary entered on the simple component
AnnualAmount Decimal Annual value of the simple component amount.
AnnualFtAmount Decimal Annual value of the simple component amount, if the person worked full time.
BasedOnComponentCode String Code of the simple component that the percentage applies to.
BasisSimpleComponentId Long Unique identifier of the simple component that the percentage applies to.
ComponentCode String Code of the salary simple component, such as ORA_BASIC.
ComponentType String Code for the simple component type.
CurrencyCode String Currency code that the simple component value is stored in, such as USD.
DisplaySequence Int Display sequence of the simple component.
Percentage Decimal Percentage entered for the simple component. This percentage is applied to the specified based on simple component, to calculate the component amount. For example, apply 5% to the Base Salary simplified component.
SalaryId Long Unique identifier of the salary.
SimpleSalaryCompntId [KEY] Long Unique identifier of the salary simple component.
ComponentName String Name of the simple component, which can be configured to accept an amount or percentage.
BasedOnComponentName String Name of the simple component that the percentage applies to.
Scale Int Decimal precision of the salary amount, configured in salary basis.
PreviousAmount Decimal Previous simple component amount.
UserSelectedComponent String Property used to specify whether the incremental components type is SELECTED_COMPONENTS or USER_DECIDES_USAGE.
OverallSalaryAffect String Code for the effect of overall salary.
OverrideGspRate String Indicates whether a user can override the value defaulted from the progression ladder.
AssigGradeLadderId Long AssigGradeLadderId of SalariessalarySimpleComponents
AssigGradeStepId Long AssigGradeStepId of SalariessalarySimpleComponents
AssignmentId Long AssignmentId of SalariessalarySimpleComponents
BusinessUnitId Long BusinessUnitId of SalariessalarySimpleComponents
DateFrom Date DateFrom of SalariessalarySimpleComponents
DateTo Date DateTo of SalariessalarySimpleComponents
EffectiveDate Date EffectiveDate of SalariessalarySimpleComponents
EffectiveStartDate Date EffectiveStartDate of SalariessalarySimpleComponents
Finder String Finder of SalariessalarySimpleComponents
FTEValue String FTEValue of SalariessalarySimpleComponents
GradeId Long GradeId of SalariessalarySimpleComponents
JobId Long JobId of SalariessalarySimpleComponents
LocationId Long LocationId of SalariessalarySimpleComponents
OfferId Long OfferId of SalariessalarySimpleComponents
PersonId Long PersonId of SalariessalarySimpleComponents
ReloadTransactionId Long ReloadTransactionId of SalariessalarySimpleComponents
RestFlow String RestFlow of SalariessalarySimpleComponents
SalaryAmount String SalaryAmount of SalariessalarySimpleComponents
SalaryBasisId Long SalaryBasisId of SalariessalarySimpleComponents
SearchDate Date SearchDate of SalariessalarySimpleComponents
WorkAtHome String WorkAtHome of SalariessalarySimpleComponents

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060