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