DW_CMP_SALARY_RATE_COMPONENT_D (Preview)
This table requires activation of Salary Basis functional area. Captures salary data using Rate Components
Details
Module: Compensation
Key Columns
RATE_SALARY_COMPONENT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| RATE_SALARY_COMPONENT_ID | NUMBER | 38 | 0 | True | Salary pay rate 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 | |||||
| RATE_DEFINITION_ID | NUMBER | 38 | 0 | Rate Definition Identifier | DW_CMP_RATE_DEFINITION_D | RATE_DEFINITION_ID | |
| RATE_AMOUNT | NUMBER | Rate Amount | |||||
| RATE_ANNUAL_AMOUNT | NUMBER | Rate Annual Amount | |||||
| RATE_ANNUAL_FT_AMOUNT | NUMBER | Rate Annualized Full Time Amount | |||||
| RATE_CURRENCY_CODE | VARCHAR2 | 32 | Rate Currency | ||||
| RATE_PERIODICITY_CODE | VARCHAR2 | 32 | Rate Frequency | ||||
| RATE_FACTOR | NUMBER | Rate Percentage |