DW_CMP_RATE_DEFINITION_D (Preview)
This table requires activation of Salary Basis functional area. Captures Rate Definition details
Details
Module: Compensation
Key Columns
EFFECTIVE_END_DATE, RATE_DEFINITION_ID, EFFECTIVE_START_DATE
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| RATE_DEFINITION_ID | NUMBER | 38 | 0 | True | Rate definition Identifier | ||
| EFFECTIVE_START_DATE | DATE | True | Effective Start date | ||||
| EFFECTIVE_END_DATE | DATE | True | Effective End date | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| RATE_DEFINITION_CODE | VARCHAR2 | 256 | Rate Definition Code | ||||
| CATEGORY | VARCHAR2 | 32 | Type Of Rate definition | ||||
| STATUS | VARCHAR2 | 32 | Status of Rate Definition | ||||
| FREQUENCY | VARCHAR2 | 32 | Rate Frequency | ||||
| CURRENCY | VARCHAR2 | 32 | Rate currency | ||||
| BASE_SALARY_FLAG | VARCHAR2 | 32 | Base Salary indicator | ||||
| OVERALL_SALARY_FLAG | VARCHAR2 | 32 | Overall Salary indicator | ||||
| AMOUNT_OVERRIDE_ALLOWED | VARCHAR2 | 32 | Amount Override Allowed | ||||
| FACTOR_OVERRIDE_ALLOWED | VARCHAR2 | 32 | Factor Override Allowed | ||||
| FTE_FLAG | VARCHAR2 | 32 | Component return Full-Time Rate (yes or no) | ||||
| DEFAULT_SOURCE_TYPE | VARCHAR2 | 32 | Default source type (Value, Value by Criteria, Formula) | ||||
| DEFAULT_SOURCE_VALUE | VARCHAR2 | 32 | Default source value | ||||
| MINIMUM_VALUE | VARCHAR2 | 32 | Rate Defintion Minimum Value | ||||
| MAXIMUM_VALUE | VARCHAR2 | 32 | Rate Definition Maximum Value |