This table stores the header details of absences which have not been rejected or wihdrawn
Module: Absence Management
ABSENCE_TYPE_ENTRY_ID
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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.