HR Absences
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 |
|---|---|---|---|---|---|---|
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 |
01-JAN-2025 |
|
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. |
Dimension |
Human Resources, SAP |
MIT ONLY |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Table containing information about MIT employees as recorded and maintained in SAP HR. |
Dimension |
Human Resources, SAP |
SENSITIVE |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Daily calendar information. For use in joining tables to include a time dimension to the report. |
Dimension |
PUBLIC |
As Needed |
01-JAN-2025 |