DW_ABS_ENTRY_D

This table stores the header details of the absence transactions

Details

Module: Absence Management

Key Columns

ENTERPRISE_ID , ABSENCE_ENTRY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_ENTRY_ID NUMBER 38 0 True Primary key of Absence header    
ENTERPRISE_ID NUMBER 38 0 True Enterprise identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique Source Record Identifier consisting of absnec_entry_id and enterprise_id    
LEGAL_EMPLOYER_ID NUMBER 38 0   Legal Entity identifier    
LEGISLATIVE_DATA_GROUP_ID NUMBER 38 0   Legislative data group identifier    
PERSON_ID NUMBER 38 0   Person identifier    
ASSIGNMENT_ID NUMBER 38 0   Assignment identifier    
ABSENCE_TYPE_ID NUMBER 38 0   Absence type identifier    
ABSENCE_TYPE_REASON_ID NUMBER 38 0   Absence reason identifier    
START_DATE_DURATION NUMBER       Duration on the start date    
END_DATE_DURATION NUMBER       Duration on the end date    
UOM_CODE VARCHAR2 32     Unit of measurement code    
DURATION NUMBER       Total Duration    
ABSENCE_PATTERN_CD VARCHAR2 32     Code for absence pattern    
ABSENCE_STATUS_CD VARCHAR2 32     Code for Absence status    
APPROVAL_STATUS_CD VARCHAR2 32     Code for approval status    
SINGLE_DAY_FLAG VARCHAR2 16     Determines whether the absence applied is for single day    
START_TIME VARCHAR2 32     Absence Starting time    
END_TIME VARCHAR2 32     Absence Ending time    
OPEN_ENDED_FLAG VARCHAR2 16     Determines if the absence is open ended    
COMMENTS VARCHAR2 999     Comments    
LATE_NOTIFY_FLAG VARCHAR2 32     Determines whther the notification for absence was late    
ABSENCE_SOURCE VARCHAR2 16     Source    
START_DATETIME TIMESTAMP       Absence Start Date time and start time    
END_DATETIME TIMESTAMP       Absence End date and end time    
START_DATE DATE       Absence start date    
END_DATE DATE       Absence End date    
PLANNED_END_DATE DATE       For open absence planned end date    
SUBMITTED_DATE DATE       Absence submitted date    
CONDITION_START_DATE DATE       Condition start date    
NOTIFICATION_DATE DATE       Notification date    
ABSENCE_ENTRY_BASIC_FLAG VARCHAR2 32     Determines whether absence was entered in basic or advanced mode    
BLOCKED_LEAVE_CANDIDATE VARCHAR2 32     Determines whether it is a mandatory absence    
DW_START_DATE DATE       Warehouse Absence start date    

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