DW_CMP_SALARY_BASES_SIMPLE_COMPONENT_D (Preview)
This table requires activation of Salary Basis functional area. Captures Simple Components associated to the Salary Bases
Details
Module: Compensation
Key Columns
SALARY_BASES_SIMPLE_COMPONENT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SALARY_BASES_SIMPLE_COMPONENT_ID | NUMBER | 38 | 0 | True | Salary basis Simple Component identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| SALARY_BASIS_ID | NUMBER | 38 | 0 | Salary Basis Identifier | |||
| SIMPLE_COMPONENT_CODE | VARCHAR2 | 32 | Simple Component Code | ||||
| COMPONENT_TYPE | VARCHAR2 | 32 | Simple Component Type | ||||
| OVERALL_SALARY_IMPACT | VARCHAR2 | 32 | Effect on Overall Salary | ||||
| OPTIONAL_FLAG | VARCHAR2 | 32 | Mandatory / Optional | ||||
| BASE_COMPONENT_CODE | VARCHAR2 | 32 | Base Component used to apply Percentage |