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

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