DW_ABS_TYPE_D

This table stores absence type information.

Details

Module: Absence Management

Key Columns

EFFECTIVE_END_DATE, ABSENCE_TYPE_ID, 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    

Copyright © 2019, 2024, Oracle and/or its affiliates.