Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Pension 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

PENSION_PERSON

SAP HR Pension Person data

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

BENEFITS_PLAN

Benefits Plans: health, insurance and flexible benefits accounts.

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

PENSION_BENEFITS_DETAIL

Pension Benefits data

Fact

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

PENSION_BENEFITS_RECIPIENT

SAP HR Pension Benefits Recipients

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020