Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR Vacation Balances


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

HR_ABSENCE_BALANCE

In this table, for a non-exempt employee, there is one balance quota record for each of these balance quotas: Vacation, Fifth Week Vacation, Sick Leave, and Personal Leave. For exempt employees, there is one balance quota record for the Vacation quotas, and a balance quota record for the Fifth Week Vacation quotas.

Fact

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

HR_PERSON_EMPLOYEE

Table containing information about MIT employees as recorded and maintained in SAP HR.

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

HR_ABSENCE_BALANCE_TYPE

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.

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020

HR_ABSENCE_DETAIL

This table contains absence data for non-exempt employees (beginning in July 2006) and exempt employees (beginning in September 2006). It shows the dates and the number of hours/days taken as an absence day for vacation, fifth week vacation, sick leave, personal leave, etc.

Fact

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020