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