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 This column is for Oracle Internal use only. 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