# 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 |  |

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