DW_CMP_CWB_PERSON_RATE_F

Information about the various Compensation Rates for a person

Details

Module: Compensation

Key Columns

PERSON_EVENT_ID, COMPONENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_EVENT_ID NUMBER 38 0 True Person Event Identifier
COMPONENT_ID NUMBER 38 0 True Component Identifier DW_CMP_PLAN_COMPONENT_D COMPONENT_ID
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
PLAN_ID NUMBER 38 0 Plan Identifier DW_CMP_PLAN_D PLAN_ID
PERIOD_ID NUMBER 38 0 Plan Period Identifier DW_CMP_PLAN_PERIOD_D PERIOD_ID
PERSON_ID NUMBER 38 0 Person Identifier DW_PERSON_D PERSON_ID
ASSIGNMENT_ID NUMBER 38 0 Assignment Identifier
ELIG_FLAG VARCHAR2 16 Eligibility Flag
INELIG_REASON_CODE VARCHAR2 32 Ineligibility Reason
CURRENCY VARCHAR2 32 Currency of person rates
WS_VAL NUMBER Worksheet Compensation Amount
WS_MIN_VAL NUMBER Worksheet Compensation Amount Minimum Value
WS_MAX_VAL NUMBER Worksheet Compensation Amount Maximum Value
ELIG_SAL_VAL NUMBER Eligible Salary Value
MISC1_VAL NUMBER Miscellaneous Values
MISC2_VAL NUMBER Miscellaneous Values
MISC3_VAL NUMBER Miscellaneous Values
MISC4_VAL NUMBER Miscellaneous Values
MISC5_VAL NUMBER Miscellaneous Values
MISC6_VAL NUMBER Miscellaneous Values
REC_VAL NUMBER Target Compensation Value
REC_MIN_VAL NUMBER Target Compensation Minimum Value
REC_MAX_VAL NUMBER Target Compensation Maximum Value
PRIOR_WS_VAL NUMBER Prior Worksheet Compensation Amount
PRIOR_ELIG_SAL_VAL NUMBER Prior Eligible Salary Value
EMP_BDGT_VAL NUMBER Employee Budget Value
EMP_BDGT_MIN_VAL NUMBER Employee Budget Value Minimum
EMP_BDGT_MAX_VAL NUMBER Employee Budget Value Mazimum
PRIOR_WS_VAL_DATE DATE Prios Worksheet Value Date
COMP_POSTED_DATE DATE Compensation Posted Date
COMP_POSTING_DATE DATE Compensation Posting Date
ELIG_OVERRIDE_DATE DATE Date when Eligibility is overriden
ELIG_OVERRIDE_PERSON_ID NUMBER 38 0 Person identifier who overrided eligibility DW_PERSON_D PERSON_ID
WS_VAL_LAST_UPD_DATE DATE Worksheet Value Last Updated Date
CREATION_DATE TIMESTAMP creation date