Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR ABSENCE TYPE Table


A dimension table which contains the different types of absences for exempt and non-exempt employees. Eg.: Vacation, Sick, Personal Leave, Bereavement Leave, 5th Week Vacation, Sick - Family, Leave Without Pay.


Field Name

Description

Data Type

Length

ABSENCE_BALANCE_TYPE_1

XXX

VARCHAR2

40

ABSENCE_BALANCE_TYPE_2

XXX

VARCHAR2

40

ABSENCE_BALANCE_TYPE_3

XXX

VARCHAR2

40

ABSENCE_BALANCE_TYPE_4

XXX

VARCHAR2

40

ABSENCE_TYPE

XXX

VARCHAR2

25

ABSENCE_TYPE_CODE

XXX

VARCHAR2

4

EMPLOYEE_GROUP

Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External

VARCHAR2

30

HR_ABSENCE_TYPE_KEY

XXX

VARCHAR2

6

WAREHOUSE_LOAD_DATE

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

DATE

8