DW_CMP_PLAN_D_TL

This dimension captures the Compensation Plan translation information

Details

Module: Compensation

Key Columns

LANGUAGE, PLAN_ID, BUSINESS_GROUP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_ID NUMBER 38 0 True Plan Identifier DW_CMP_PLAN_D PLAN_ID
LANGUAGE VARCHAR2 16   True Translation language    
BUSINESS_GROUP_ID NUMBER 38 0 True Business Group Identifier    
SOURCE_RECORD_ID VARCHAR2 256     Source Record Identifier    
PLAN_NAME VARCHAR2 128     Name of the Plan    
PLAN_DESCRIPTION VARCHAR2 512     Description of the Plan