This dimension captures the Plan period Information
Module: Compensation
PERIOD_ID
| 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.