DW_CMP_CWB_PERSON_RATE_F

Information about the various Compensation Rates for a person

Details

Module: Compensation

Key Columns

COMPONENT_ID, PERSON_EVENT_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     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