DW_CMP_PLAN_DEFINITION_D
This dimension captures the Plan Definition Details
Details
Module: Compensation
Key Columns
PLAN_DEFINITION_ID
Columns
| 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 | This column is for Oracle Internal use only. 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 |