DW_ABS_TYPE_D

This table stores absence type information.

Details

Module: Absence Management

Key Columns

ABSENCE_TYPE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
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