# DW_CMP_PLAN_PERIOD_D

This dimension captures the Plan period Information

## Details

Module: Compensation

## Key Columns

PERIOD_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PERIOD_ID | NUMBER | 38 | 0 | True | Period 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
START_DATE | DATE |  |  |  | Plan Period Start Date |  |
END_DATE | DATE |  |  |  | Plan Period End Date |  |
PERIOD_NAME | VARCHAR2 | 128 |  |  | Period Name |  |
DISPLAY_NAME | VARCHAR2 | 32 |  |  | Display Name |  |
AVAIL_START_DATE | DATE |  |  |  | Plan Access Avail Start Date |  |
AVAIL_END_DATE | DATE |  |  |  | Plan Access Avail End Date |  |
DEFAULT_DUE_DATE | DATE |  |  |  | Default Due Date |  |
ELIGIBILITY_DATE | DATE |  |  |  | Eligibility Determination Date |  |
FREEZE_DATE | DATE |  |  |  | Freeze Date. HR Data Extraction |  |
PERFORMANCE_DATE | DATE |  |  |  | Performance Rating Date |  |
EXCHANGE_RATE_DATE | DATE |  |  |  | Currency Conversion Date |  |
ASSIGNMENT_CHANGE_DATE | DATE |  |  |  | Assignment Change Date |  |
UPDATE_START_DATE | DATE |  |  |  | Worksheet Update Start Date |  |
UPDATE_END_DATE | DATE |  |  |  | Worksheet Update End Date |  |

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