Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Benefits Detail


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

BENEFITS_PLAN

Benefits Plans: health, insurance and flexible benefits accounts.

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

BENEFITS_RECIPIENT

A record exists in this table for each person who receives health, insurance, or flexible spending account benefits at MIT. Therefore, there are records not just for employees, but for their dependents.

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

BENEFITS_PERSON_EMPLOYEE

MIT employee data including benefits-related fields which are excluded from other employee views

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

BENEFITS_ADJUSTMENT_REASON

This table contains benefits adjustment reason codes and descriptions.

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

BENEFITS_DETAIL

Benefits Enrollments: history of health, insurance and FSA enrollments of employees and their dependents

Fact

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020