Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Benefits Adjustments


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_ADJ_REASON_DETAIL

This table contains a history of changes to employees' benefits, complete with reasons for these changes

Fact

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