SalariessalaryComponents

Columns


Name	Type	Description
SalariesSalaryId [KEY]	Long	Unique identifier of the salary for a worker assignment.
SalaryComponentId [KEY]	Long	Unique identifier of the salary component.
SalaryId	Long	Unique identifier of the salary.
ComponentReasonCode	String	Incremental component code for salary adjustments itemized by reasons, such as merit, location, and cost of living.
AdjustmentAmount	Double	Change amount for a component used to itemize salary into different reasons.
AdjustmentPercentage	Double	Change percentage for a component used to itemize salary into different reasons.
ComponentName	String	Incremental component that itemizes salary adjustments by reasons, such as merit, location, and cost of living.

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