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
| 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 |