DW_ABS_MATERNITY_D

This table stores the maternity absence details

Details

Module: Absence Management

Key Columns

ENTERPRISE_ID, ABSENCE_MATERNITY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_MATERNITY_ID NUMBER 38 0 True Maternity Absence Identifier    
ENTERPRISE_ID NUMBER 38 0 True Enterprise identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique Source Record Identifier consisting of absence_category_id effective_start_date and effective_end_date    
ABSENCE_ENTRY_ID NUMBER 38 0   Absence header identifier    
EXPECTED_CHILD_BIRTH_DATE DATE       Expected date of chid birth    
PLANNED_START_DATE DATE       Planned Absence start date    
PLANNED_RETURN_DATE DATE       Planned return date    
ACTUAL_CHILD_BIRTH_DATE DATE       Actual date of child birth    
ACTUAL_START_DATE DATE       Actual absence start date    
ACTUAL_RETURN_DATE DATE       Actual return date    
EXPECTED_END_DATE DATE       Expected end date    
LEAVE_DURATION NUMBER       Duration of leave    
ACTUAL_DURATION NUMBER       Actual Duration    
INTEND_TO_WORK_FLAG VARCHAR2 32     Intention to work flag    
OPEN_ENDED_FLAG VARCHAR2 32     Open ended flag    

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