This table stores the header details of the absence transactions
Module: Absence Management
ABSENCE_ENTRY_ID , ENTERPRISE_ID
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 | 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 |