DW_CMP_PLAN_D_TL

This dimension captures the Compensation Plan translation information

Details

Module: Compensation

Key Columns

BUSINESS_GROUP_ID, PLAN_ID, LANGUAGE

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 This column is for Oracle Internal use only. Source Record Identifier
PLAN_NAME VARCHAR2 128 Name of the Plan
PLAN_DESCRIPTION VARCHAR2 512 Description of the Plan