DW_CMP_PLAN_COMPONENT_D_TL

This dimension captures the Compensation Plan Components translation information

Details

Module: Compensation

Key Columns

PLAN_ID, COMPONENT_ID, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
COMPONENT_ID NUMBER 38 0 True Compensation Identifier DW_CMP_PLAN_COMPONENT_D COMPONENT_ID
PLAN_ID NUMBER 38 0 True Plan Identifier DW_CMP_PLAN_D PLAN_ID
LANGUAGE VARCHAR2 16   True Language Identifier    
SOURCE_RECORD_ID VARCHAR2 256     Source Record Identifier    
COMPONENT_NAME VARCHAR2 128     Name of the Component