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 | 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 |