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