Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Payroll Distributions


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

HR_POSITION

Master data table containing position information, such as position title, position area/subarea and employee group/subgroup, for the current fiscal period.

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020

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

HR_ORG_UNIT

Master data table containing the new 8 digit department nuber, title, old department codes, and organization levels.

Dimension

Human Resources, SAP

MIT ONLY

Daily

08-JAN-2020

PAYROLL_EDACCA_DETAIL

This table contains salary distribution data for employees and students, beginning July 2006. Records are added to it after every payroll.

Fact

SAP HR Payroll

SENSITIVE

As Needed

08-JAN-2020

TIME_MONTH

Monthly calendar information. For use in joining tables to include a time dimension to the report. Use the Time_Month_Key to join.

Dimension

PUBLIC

As Needed

14-JUN-2003

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

COST_COLLECTOR

Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

PAYROLL_FOR_PERIOD

Information about payroll FOR-period, including the type of payroll (monthly vs.weekly), service start and end dates, payment date, etc. "For-period" specifies the period for which the employee is paid, as opposed to the "In-period" which specifies the period in which the payroll runs. 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_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

GL_ACCOUNT

GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020