SalariessalarySimpleComponents
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
AssignmentId | Long | AssignmentId |
EffectiveDate | Date | EffectiveDate |
Finder | String | finder |