SalariessalaryComponents
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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AssignmentId | Long | AssignmentId |
EffectiveDate | Date | EffectiveDate |
Finder | String | finder |