This table stores the maternity absence details
Module: Absence Management
ABSENCE_MATERNITY_ID, ENTERPRISE_ID
| 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.