# DW_CMP_PLAN_D

This dimension captures the Plan Details

## Details

Module: Compensation

## Key Columns

PLAN_ID

## Columns

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

Copyright © 2019, 2025, Oracle and/or its affiliates.