DW_ABS_PLAN_ENTRY_D

Stores Absence Plan and Type Mapping Details

Details

Module: Absence Management

Key Columns

ABS_PLAN_ENTRY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABS_PLAN_ENTRY_ID NUMBER 38 0 True Absence Plan Entry Identifier
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Functional key of records. Absence Plan Entry Identifier
START_DATETIME DATE Start Date
END_DATETIME DATE End Date
ABS_TYPE_ENTRY_ID NUMBER 38 0 Absence Type Entry Identifier
ENTERPRISE_ID NUMBER 38 0 Enterprise Identifier
ABSENCE_PLAN_ID NUMBER 38 0 Absence Plan Identifier DW_ABS_PLAN_D_TL ABSENCE_PLAN_ID
ASSIGNMENT_ID NUMBER 38 0 Assignment Identifier
START_DATE DATE Start Date
END_DATE DATE End Date
UOM_CODE VARCHAR2 32 Unit of Measure
SCHEDULED_UNITS NUMBER Scheduled Units
ABS_UNITS NUMBER Absence Units
PERSON_ID NUMBER 38 0 Person Identifier
ABSENCE_ENTRY_ID NUMBER 38 0 Absence Entry Identifier
ABSENCE_PLAN_SUMMARY_ENTRY_ID NUMBER 38 0 Plan summary Identifier
QUALIFICATION_DATE DATE Qulification Date
ENTITLEMENT_DATE DATE Entitlement Date
ABSENCE_PAY_FACTOR NUMBER 38 0 Absence Pay Factor
ABS_PAY_FACTOR NUMBER Absence Pay Factor