Data Warehouse

IS&T Home >   Data Warehouse

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

Dimension Table for Pension Action Detail, consists information about Pension Action Types and Action Reasons (Types:Initial Pension Set-up, Pension Termination, etc, Reason: Deceased, Suspension,etc)

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

PENSION_ACTION_DETAIL

Pension Actions data (Action Begin and End date,SAP Status, Last Update Date,etc)

Fact

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020

PENSION_PERSON

SAP HR Pension Person data

Dimension

Human Resources, SAP

SENSITIVE

Daily

08-JAN-2020