# DW_CMP_PLAN_D_TL

This dimension captures the Compensation Plan translation information

## Details

Module: Compensation

## Key Columns

LANGUAGE, BUSINESS_GROUP_ID, PLAN_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 |  |  | 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 |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.