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 | 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.