Summit Data Marts

A data mart is a subset of the data warehouse. These marts are concentrated subjects specific to a business area in the University. Summit currently has 17 active data marts ranging from Finance, to HR, to Student information. Data marts pertain each department and work to get this specific data out to the users. The table below provides insight into the different subject areas provided in each data mart.

Data Mart Data Mart Subject Description Status
Analytics Any

Integrated database for developing and deploying advanced analytics content with proximity to “live” data and campus user direct database access

2017
Executive Dashboard - Mobile Executive

Summarized information for executives and Board of Trustee users

Live
Asset Management Finance

Fixed Asset

Live
Combined Payroll Finance

Combines Medical school and Memorial payroll with Retro charges

Live (WOR)
Finance Finance

Month End data including GL, Commitment Control, Grants (Pre & Post), Contracts, Projects, Hr Acctg Ln, Expense Module, AP, PO, Student Financials, External Acctg Ln, Balance Sheet, Equifax, and NAICS using Row Level

Live
Payroll Projection Finance, HR

Future payroll projection based on finance and HR data

Live
Position Management Finance, HR

Position Budget Management, projected Step Increases, and vacancy Management

Live
Procurement Finance

BuyWays

Live
Worcester Executive Finance

Business Line Data

Live (WOR)
Contract Costing HR

Costing solution with pay rate snapshots

Live (WOR)
HR HR

Time and Labor, leave accruals, payroll and pay rate, employee job management, rating, and immigration

Live
IR HR, Student

Snapshots of student and HR data, reporting tables for integration with ‘live’ data, and campus user direct database access

Ongoing
Legacy Reporting HR

1968 to 2002 W2, pay and time data

Live
Payroll Projection Finance, HR

Future payroll projection based on finance and HR data

Live
Position Management Finance, HR

Position Budget Management, projected Step Increases, and vacancy Management

Live
International International

Student and employee visa information

Live
Security Security

Information on user access to systems

Live
Degree Audit Student

Academic advising & course planner

Live (BDL)
Financial Aid Student

ISIR, parents’ financial information, packages, budgets, and awards

Live (BDL)
IR HR, Student

Snapshots of student and HR data, reporting tables for integration with ‘live’ data, and campus user direct database access

Ongoing
Recruiting and Admission Student

Applicants and recruits bio-demo Applications details External academic information

Live (BDL)
Student Records Student

Classes, enrollments, grades, course catalog, colleges, programs, majors, minors/concentrations, and advising

Live (BDL)