# DW_CMP_RATE_DEFINITION_D

Captures Rate Definition details

## Details

Module: Compensation

## Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, RATE_DEFINITION_ID

## Columns

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 |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.