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