This table stores absence type information.
Module: Absence Management
ABSENCE_TYPE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ABSENCE_TYPE_ID | NUMBER | 38 | 0 | True | Absence Type Identifier | DW_ABS_TYPE_D_TL | ABSENCE_TYPE_ID |
| EFFECTIVE_START_DATE | DATE | True | Start date of Absence type | ||||
| EFFECTIVE_END_DATE | DATE | True | End date of Absence type | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Unique Identifier | ||||
| LEGISLATIVE_DATA_GROUP_ID | NUMBER | 38 | 0 | Legislative data group identifier | |||
| ENTERPRISE_ID | NUMBER | 38 | 0 | Enterprise identifier | |||
| PATTERN_CD | VARCHAR2 | 256 | Absence Type Pattern | ||||
| MANAGEMENT_TYPE_CD | VARCHAR2 | 256 | Management type code | ||||
| LEGISLATION_CODE | VARCHAR2 | 32 | Legislation Code | ||||
| STATUS_CODE | VARCHAR2 | 256 | Status | ||||
| DURATION_UOM_CD | VARCHAR2 | 32 | Durataion Unit of measurement | ||||
| MIN_DURATION | NUMBER | Minimum Duration | |||||
| MAX_DURATION | NUMBER | Maximum Duration | |||||
| PARTIAL_DAY | VARCHAR2 | 32 | Partial day flag |
Copyright © 2019, 2024, Oracle and/or its affiliates.