DW_ABS_ENTRY_DETAIL_F

Stores Absence Entry Details

Details

Module: Absence Management

Key Columns

ENTERPRISE_ID, ABS_ENTRY_DTL_ID

Columns

Columns
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