DW_CMP_SALARY_COMPONENT_D (Preview)
This table requires activation of Salary Basis functional area. Holds Salary by Components
Details
Module: Compensation
Key Columns
SALARY_COMPONENT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SALARY_COMPONENT_ID | NUMBER | 38 | 0 | True | Primary Key for Salary Components in Fusion Source. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| SALARY_ID | NUMBER | 38 | 0 | Salary Identifier | |||
| CHANGE_AMOUNT | NUMBER | Component Amount change | |||||
| CHANGE_PERCENTAGE | NUMBER | Component % change | |||||
| COMPONENT_REASON_CODE | VARCHAR2 | 32 | Component code | DW_CMP_SALARY_COMPONENTS_D_TL | SALARY_COMPONENTS_CODE |