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    

Copyright © 2019, 2024, Oracle and/or its affiliates.