DW_ABS_TYPE_REASON_D

Stores Absence Type Reason Mapping Details

Details

Module: Absence Management

Key Columns

EFFECTIVE_END_DATE, ABSENCE_TYPE_REASON_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_TYPE_REASON_ID NUMBER 38 0 True Absence Type Reason Identifier    
EFFECTIVE_START_DATE DATE     True Effective Start Date    
EFFECTIVE_END_DATE DATE     True Effective End Date    
SOURCE_RECORD_ID VARCHAR2 512     This column is for Oracle Internal use only. Functional key of records. Combination of Absence Type Reason Identifier, Effective Start Date and Effective End Date    
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
ABSENCE_TYPE_ID NUMBER 38 0   Absence Type Identifier DW_ABS_TYPE_D_TL ABSENCE_TYPE_ID
ABSENCE_REASON_ID NUMBER 38 0   Absence Reason Identifier DW_ABS_REASON_D_TL ABSENCE_REASON_ID

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