This dimension captures the Compensation Plan Components translation information
Module: Compensation
PLAN_ID, COMPONENT_ID, LANGUAGE
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 |