This dimension captures the Plan Definition Details
Module: Compensation
PLAN_DEFINITION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PLAN_DEFINITION_ID | NUMBER | 38 | 0 | True | Plan Definition Identifier | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source Record Identifier | |||
PLAN_ID | NUMBER | 38 | 0 | Plan Identifier | DW_CMP_PLAN_D | PLAN_ID | |
PERIOD_ID | NUMBER | 38 | 0 | Period Identifier | DW_CMP_PLAN_PERIOD_D | PERIOD_ID | |
DEFINITION_TYPE | VARCHAR2 | 32 | Definition Type | ||||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business_Group Identifier | |||
STATUS_CODE | VARCHAR2 | 32 | Status Code | DW_CMP_PLAN_PERIOD_STATUS_D_TL | PLAN_PERIOD_STATUS_CODE | ||
CORPORATE_CURRENCY | VARCHAR2 | 32 | Corporate Currency | ||||
PLAN_COMPONENT_COUNT | NUMBER | Plan_Component Count | |||||
APPROVAL_MODE | VARCHAR2 | 32 | Approval Mode | ||||
SUBMIT_MODE | VARCHAR2 | 32 | Submit Mode | ||||
BUDGETING_STYLE | VARCHAR2 | 32 | Budgeting Style | ||||
POST_AS_SALARY_FLAG | VARCHAR2 | 16 | Post_As_Salary Flag |
Copyright © 2019, 2023, Oracle and/or its affiliates.