SalariessalarySimpleComponents

Columns


Name	Type	Description
SalariesSalaryId [KEY]	Long	Unique identifier of the salary for a worker assignment.
AdjustmentAmount	Double	Change amount for a simple component.
AdjustmentPercent	Double	Change percentage for a simple component.
Amount	Double	Amount of the person's salary entered on the simple component
AnnualAmount	Double	Annual value of the simple component amount.
AnnualFtAmount	Double	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.
CurrencyCode	String	Currency code that the simple component value is stored in, such as USD.
DisplaySequence	Int	Display sequence of the simple component.
Percentage	Double	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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。