DW_ABS_REASON_D

Stores Absence Reason Details

Details

Module: Absence Management

Key Columns

ABSENCE_REASON_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_REASON_ID NUMBER 38 0 True Absence Reason Identifier    
EFFECTIVE_START_DATE DATE     True Effective Start Date    
EFFECTIVE_END_DATE DATE     True Effective End Date    
SOURCE_RECORD_ID VARCHAR2 512     Functional key of records. Combination of Absence Reason Id, Effective Start Date and Effective End Date    
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
LEGISLATION_CODE VARCHAR2 32     Legislation Code    
STATUS_CODE VARCHAR2 32     Status Code    

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