DW_CMP_SALARY_SIMPLE_COMPONENT_D (Preview)
This table requires activation of Salary Basis functional area. Captures salary data using Simple Components
Details
Module: Compensation
Key Columns
SIMPLE_SALARY_COMPONENT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SIMPLE_SALARY_COMPONENT_ID | NUMBER | 38 | 0 | True | Simple Salary Component identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| SALARY_ID | NUMBER | 38 | 0 | Salary Identifier | |||
| SALARY_BASIS_ID | NUMBER | 38 | 0 | Salary Basis Identifier | |||
| DATE_FROM | DATE | Salary effective from | |||||
| DATE_TO | DATE | Salary Effective to | |||||
| SALARY_BASES_SIMPLE_COMPONENT_ID | NUMBER | 38 | 0 | Salary Basis Simple Component Identifier | DW_CMP_SALARY_BASES_SIMPLE_COMPONENT_SETUP_D | SIMPLE_SALARY_COMPONENT_SETUP_ID | |
| AMOUNT | NUMBER | Simple Component Amount | |||||
| ANNUAL_AMOUNT | NUMBER | Annual Amount | |||||
| ANNUAL_FT_AMOUNT | NUMBER | Annualzied Ful Time Salary amount | |||||
| ADJUSTMENT_AMOUNT | NUMBER | Component Adjustment amount | |||||
| PREV_AMOUNT | NUMBER | Previous Component Amount | |||||
| PREV_ADJUSTMENT_AMOUNT | NUMBER | Previous Adjustment amount | |||||
| CURRENCY_CODE | VARCHAR2 | 32 | Currency | ||||
| FREQUENCY_CODE | VARCHAR2 | 32 | Frequency | ||||
| PERCENTAGE | NUMBER | Simple Component Percentage | |||||
| ADJUSTMENT_PERCENTAGE | NUMBER | Component Adjustment Percentage | |||||
| PREV_ADJUSTMENT_PERCENT | NUMBER | Previous Adjustment percentage |