DW_ABS_MATERNITY_D

This table stores the maternity absence details

Details

Module: Absence Management

Key Columns

ABSENCE_MATERNITY_ID, ENTERPRISE_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