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 |