Stores Absence Entry Details
Module: Absence Management
ABS_ENTRY_DTL_ID, ENTERPRISE_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 | 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, 2022, Oracle and/or its affiliates.