Stores Absence Entry Details
Module: Absence Management
ENTERPRISE_ID, ABS_ENTRY_DTL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ABS_ENTRY_DTL_ID | NUMBER | 38 | 0 | True | Absence Entry Detail Identifier | ||
| ENTERPRISE_ID | NUMBER | 38 | 0 | True | Enterprise Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. Functional key of records. Combination of Absence Entry Detail Identifier and Enterprise Identifier | ||||
| ABSENCE_ENTRY_ID | NUMBER | 38 | 0 | Absence Entry Identifier | DW_ABS_ENTRY_D | ABSENCE_ENTRY_ID | |
| ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment Identifier | |||
| ABSENCE_DATE | DATE | Absence Date | |||||
| ABSENCE_DATETIME | TIMESTAMP | Absence Date Time | |||||
| ABSENCE_END_DATETIME | TIMESTAMP | Absence End Date Time | |||||
| ABSENCE_START_TIME | VARCHAR2 | 32 | Absence Start Time | ||||
| ABSENCE_END_TIME | VARCHAR2 | 32 | Absence End Time | ||||
| ABSENCE_DURATION | NUMBER | Absence Duration |
Copyright © 2019, 2024, Oracle and/or its affiliates.