Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Payroll Deductions


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

PAYROLL_WAGE_TYPE

Most of payroll reporting occurs by wage types and this table contains all wage types used in payroll reporting. Wage types are combined into Wage Type Categories that have been created to facilitate reporting. Some of the wage type categories are: Gross Pay, Deductions, Taxes. Each deduction, each type of tax, gross pay, and gross pay component is identified as a specific wage type.

Dimension

SAP HR Payroll

SENSITIVE

Daily

08-JAN-2020

PAYROLL_PERSON

This table is used for payroll reporting. It contains all employees and students at MIT who have been paid through SAP payroll beginning July 2006.

Dimension

SAP HR Payroll

SENSITIVE

Daily

08-JAN-2020

PAYROLL_IN_PERIOD

Information about payroll IN-period, including the type of payroll (monthly vs.weekly), service start and end dates, payment date, etc. "In-period" specifies the period in which a payroll runs, as opposed to the "For-period" which specifies the period for which the person is paid. The two are usually identical, e.g., an employee paid in August 2006 for his work in August 2006, but can be different, as in case of retroactive adjustments, when an August payroll may be recalculated in September. In this case the For-period will be August, and the In-period, September.

Dimension

SAP HR Payroll

SENSITIVE

Daily

08-JAN-2020

PAYROLL_DEDUCTION_DETAIL

This table contains payroll deductions information, including requested deduction amount, the amount taken during the payroll run, arrears/deduction not taken amount, as well as -- for some types of deductions -- the amount paid-to-date and the remaining balance. The data starts in July 2006 and records are added to this table after every payroll.

Fact

SAP HR Payroll

SENSITIVE

As Needed

08-JAN-2020