Systems
Services
System Overviews
Help
Payroll Data Sets for Ad Hoc Reporting
The Payroll data sets contain reformatted data from the M-Pathways HRMS and the legacy administrative data systems.
- Payroll data can be obtained from user-defined ad hoc queries as well as from predefined reports.
- For training and access requirements, see the Online Access Request System (OARS).
- Training and documentation for specific data sets and BusinessObjects is available on My LINC.
Payroll data sets are:
M-Pathways Payroll Data Set:
Contents
Contains information about any payments made by, or recorded in, the University of Michigan Payroll system. These payments include payroll payments; student financial payments; miscellaneous payments made outside of the University Payroll system that must be recorded for calendar year-end reporting; and the University contribution to any deductions, benefits, or taxes associated with the payments.
Information is available in these tables for payrolls run from July 1, 2001, forward.
Availability
The data set is generally available Sunday, noon - Saturday, 11:00 p.m., except when the data is being refreshed. Refer to the Refresh Information for specific refresh times.
Resources
- M-Pathways Payroll Data Dictionary (November 2012)
Note: Additional documentation and training for this data set is available on My LINC.
M-Pathways Time and Labor Data Set:
Contents
Contains information about time reported to the University of Michigan Time and Labor system and how that information is incorporated into the Payroll system. It also contains information about leave accruals, missing and no variance time, Time and Labor leave plan enrollment, and a calendar to identify holidays and days of the week.
Information in these tables is available for payrolls run beginning July 1, 2001, to the present, with the exception of the Payable Time and Reported Time tables that contain data for the current month and prior 24 months.
Availability
The data set is generally available Sunday, noon - Saturday, 11:00 p.m., except when the data is being refreshed. Refer to the Refresh Information for specific refresh times.
Resources
- M-Pathways Time and Labor Data Dictionary (August 2011)
Note: Additional documentation and training for this data set is available on My LINC.
Legacy Payroll (PAY) Data Set:
Contents
Contains detailed and summarized gross pay data and University contributions to fringe benefits from the legacy Payroll system, including prior year correction payroll transactions that occurred after the July 1, 2001 implementation of M-Pathways HRMS.
The Payroll legacy data set contains payroll report data from July 1, 1995, through June 30, 2001.
Usage
Examples of how this data can be used include analyzing total gross pay and total fringe benefits charges for an individual over this time period; reviewing historic work study charges; determining the ratio of benefit charges to salary expenses for an individual, department, or school/college over the period of July 1995 to June 2001.
