Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR ABSENCE BALANCE TYPE Table


A dimension table which contains the different types of absence balance quotas for exempt and non-exempt employees. There are Vacation and 5th Week Vacation quotas for exempt employees; and the quotas for non-exempt employees are: Vacation, 5th Week Vacation, Sick, and Personal.


Field Name

Description

Data Type

Length

ABSENCE_BALANCE_TYPE

XXX

VARCHAR2

25

ABSENCE_BALANCE_TYPE_CODE

XXX

VARCHAR2

2

HR_ABSENCE_BALANCE_TYPE_KEY

XXX

VARCHAR2

5

IS_TYPE_WITH_BALANCE

XXX

VARCHAR2

1

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8