DW_ABS_PLAN_SUMMARY_D

This table stores the absence plan summary details

Details

Module: Absence Management

Key Columns

ABSENCE_PLAN_SUMMARY_ENTRY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_PLAN_SUMMARY_ENTRY_ID NUMBER 38 0 True Plan summary Identifier    
SOURCE_RECORD_ID VARCHAR2 64     Unique Source Record Identifier consisting of ABSENCE_PLAN_SUMMARY_ENTRY_ID    
ENTERPRISE_ID NUMBER 38 0   Enterprise identifier    
ABSENCE_ENTRY_ID NUMBER 38 0   Absence header identifier    
PERSON_ID NUMBER 38 0   Person Identifier    
PLAN_ID NUMBER 38 0   Plan identifier    
ABSENCE_END_DATETIME DATE       Absence end date    
ABSENCE_START_DATETIME DATE       Absence start date    
CALCULATION_DATE DATE       Date of calculation    
ENTITLEMENT_DATE DATE       Date of entitlement    
PLAN_PERIOD_START_DATE DATE       plan perios start date    
QUALIFICATION_DATE DATE       date of qulaification    
PAY_FACTOR NUMBER       Pay factor    
UNITS NUMBER       Units qualified    
UOM_CODE VARCHAR2 32     Unit of measurement code    
ACTIVITY_CODE VARCHAR2 256     Activity code    
OVERRIDE_REASON_CODE VARCHAR2 256     Override reason code    
SOURCE VARCHAR2 256     Source    

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