This table stores absence type information.
Module: Absence Management
EFFECTIVE_END_DATE, ABSENCE_TYPE_ID, EFFECTIVE_START_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 | 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 |