DW_CMP_PLAN_D
This dimension captures the Plan Details
Details
Module: Compensation
Key Columns
PLAN_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 38 | 0 | True | Plan Identifier | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Source Record Identifier | |||
| STATUS_CODE | VARCHAR2 | 32 | Plan Status Code | DW_CMP_PLAN_STATUS_D_TL | PLAN_STATUS_CODE | ||
| ANNUALIZATION_FACTOR | NUMBER | Plan Annualization Factor | |||||
| CORPORATE_CURRENCY | VARCHAR2 | 16 | Corporate Currency of the Plan | ||||
| BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Group Identifier | |||
| APPROVAL_MODE | VARCHAR2 | 32 | Approval Mode of the Plan | DW_CMP_APPROVAL_MODE_D_TL | APPROVAL_MODE_CODE | ||
| SUBMIT_MODE | VARCHAR2 | 32 | Submit Mode of the Plan | DW_CMP_SUBMIT_MODE_D_TL | SUBMIT_MODE_CODE | ||
| COMP_TYPE | VARCHAR2 | 32 | Component Type of the Plan | DW_CMP_COMP_TYPE_D_TL | COMP_TYPE_CODE | ||
| FREQUENCY | VARCHAR2 | 32 | Frequency of the Plan | DW_CMP_PLAN_FREQUENCY_D_TL | PLAN_FREQUENCY_CODE |