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 | 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, 2022, Oracle and/or its affiliates.