DW_ABS_TYPE_ENTRY_D

This table stores the header details of absences which have not been rejected or wihdrawn

Details

Module: Absence Management

Key Columns

ABSENCE_TYPE_ENTRY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_TYPE_ENTRY_ID NUMBER 38 0 True Absence type entry identifier
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier consisting of ABSENCE_TYPE_ENTRY_ID
ABSENCE_TYPE_ID NUMBER 38 0 Absence type identifier
ABSENCE_ENTRY_ID NUMBER 38 0 Absence header identifier
ENTERPRISE_ID NUMBER 38 0 Enterprise Identifier
ASSIGNMENT_ID NUMBER 38 0 Assignment Identifier
PERSON_ID NUMBER 38 0 Person Identifier
START_DATE DATE Absence start date
END_DATE DATE Absence end date
LEAVE_DURATION NUMBER duration of leaves
UOM_CODE VARCHAR2 32 unit of measurement code
START_DATE_DURATION NUMBER start date duration
END_DATE_DURATION NUMBER end date duration
END_DATETIME TIMESTAMP end date time
START_DATETIME TIMESTAMP start date time
ABSENCE_STATUS_CD VARCHAR2 32 status of absence
COMMENTS VARCHAR2 999 comments