Campus HR Staff

HR Data Management

The Data Management Division of MnSCU Human Resources performs system-wide human resources data research and serves as a resource to MnSCU campus HR offices for data management and reporting.

Request for System-wide HR Data (for internal use only)
Request for Minnesota State Colleges and Universities HR Public Data
Calendar of recurring data pulls and matching Hyperion/Brio queries
Hyperion/Brio login page
Hyperion/Brio Rc Id List by college/university
Hyperion/Brio Operational Data Security Form
Hyperion/Brio Reference for the HR Professional
Hyperion/Brio Reports Criteria
Hyperion/Brio eLearning - Self-Paced Training
Institution Profiles
Demographic Reports

Request for System-wide HR Public Data in Word Format – for internal use only

Request for Minnesota State Colleges and Universities HR Public Data in Word Format

Calendar of recurring data pulls and matching Hyperion/Brio queries (.pdf)

Hyperion/Brio Login page

Hyperion/Brio Rc Id List by college/university (.pdf)

Hyperion/Brio Operational Data Security Form

Hyperion/Brio Reference for the HR Professional (.pdf)

Hyperion/Brio Reports Criteria

Operational Data is ‘live’ data and is refreshed every 24 hours. There maybe one-day lag (or 24 hours) from when you entered data into SCUPPS and when you see the data in Hyperion/Brio.

The list below is all the queries available in Hyperion/Brio, along with a brief description of what the query will accomplish and the criteria used to create the query (coming soon!). To access these queries, you must be logged into Hyperion/Brio and have security rights of HR_H (HR staff only).

Reports HR Human Resources Folder

All HR SCUPPS Data - New HR SCUPPS query detailing employee demographic, assignment, supervisor, and bargaining data. Data source is Operational Data.
Annuitant Earnings Report - This query should give you all the information you need to complete the TRA Annuitant Earnings after Retirement report that is due each year to TRA by February 15. Since the query uses data from the accounting module (payroll) security access of AC_L (or AC_H) is required to run this query properly. If you do not have those security rights, you will have to submit a security clearance form. Data Source is Operational Data.
HR 3020 Report - This query was requested through ASRP group and has the same data fields as the SCUPPS HR3020 report. By putting this into Brio, you can request information by specific BU's instead of running the entire report to get what you want. Data Source is Operational Data.
HR Bargaining Review - Review employee bargain records and dates. Data source is Operational Data.
HR Credentials Field
HR Demographic Report
HR Education Info
HR Faculty Workload FY2002 - Data Source is Operational Data.
HR Faculty Workload FY2003 - Data Source is Operational Data.
HR Faculty Workload FY2004 - Data Source is Operational Data.
HR Faculty Workload FY2005 - Data Source is Operational Data.
HR Faculty Workload FY2006 - Data Source is Operational Data.
HR Faculty Workload FY2007 - Data Source is Operational Data.
HR Faculty Workload FY2008 - Data Source is Operational Data.
HR Institution Profile
HR Insurance All Employees - Includes employee insurance information from SCUPPS. Data Source is Operational Data.
HR Multiple Appointments - This report shows employees with assignments at more than one college/university within a fiscal year. You can also use this report to assist you in calculating insurance and retirement eligibility. It is recommended that you take a look at this query at least once during a pay period. Data Source is Operational Data.
HR Salary Units History – For TC’s only. Summarizes TC faculty salary unit activity statewide.
HR SSN Lookup – Data Source is Operational Data.
HR TRA Annual Year End Report
HR Unit 209 Rosters – For SU’s only. Summarize IFO employee payroll - Data source is Operational Data
HR Unit 210 Rosters – For College’s only. Summarize MSCF employee payroll - Data source is Operational Data
HR Unit 211 Rosters – For SU’s only. Summarize MSUAASF employee payroll - Data source is Operational Data
MSCF Adjunct TPT Credentialing - Summarize MSCF TPT by Semester. Data source is Operational Data.
MSCF Hiring Practices World of Work - Query to assist in completing the MSCF Hiring Practices report. Data Source is Operational Data.
MSCF Sabbatical Replacements - This query shows all assignment cat '90' or sabbatical replacements and is also used in preparing the annual Hiring Practice Report for MSCF. Data Source is Operational Data.

Affirmative Action Folder

HR AA All by EEO4 cat – this query provides the EEO4 category for each employee. The EEO4 category (compiled by DOER) is based on the job class code each employee is assigned. Data Source is Operational Data.
HR AA All Employees – this query includes data such as military status, disability flag, gender, ethnicity, and supervisor’s name. Data Source is Operational Data.
HR AA All exc temps – this query contains the same data as the HR AA All but excludes any employee (usually temporary) with an appointment status code 3, 5, 8, 9, T, or X. Data Source is Operational Data.
HR AA All Promotions – this query contains data on promotions for all bargaining units except for 209 (IFO), 210 (MSCF), 218 (Non-unit), and 223 (Exam monitors). Data Source is Operational Data.
HR AA All Separations – this query shows all separations for the current and previous fiscal years. Data Source is Operational Data.
HR Appt Status Cd is Blank – this is an exception reporting query. You will only get results if the appointment status code is BLANK. Data Source is Operational Data.

HR Reconciliation Folder
Within the Reports HR Campus folder you will find several sub-folders, one called ‘HR Reconciliation.’ The queries in this folder were built to assist with completing the HR Dashboard project. These queries are all ‘exception reporting’ type queries – you will only see results if there is an error. No results mean your data is free of errors in this query.

HR Demo Birthdate Incorrect – this query was created as part of the HR dashboard project. It captures any employee whose birth date is outside the standard parameters in SCUPPS. Data Source is Operational Data.
HR Demo Cross Campus Errors – this query Identify employees with demographic differences across any college/university. Data Source is Operational Data.
HR Demo Ethnicity or Gender Codes Blank – this query was created as part of the HR dashboard project. It captures all employees that are missing ethnicity or gender codes in SCUPPS. Data Source is Operational Data.
HR Demo Supervisor Field Blank – this query was created as part of the HR dashboard project. It captures all ACTIVE employees without a supervisor listed in the supervisor field by SEMA4 record number in SCUPPS. DOES NOT INCLUDE Faculty. Data Source is Operational Data.
HR Phased Retr Coding Errors – Data Sources is Operational Data.
HR Retr AEP Coding Errors – Data Sources is Operational Data.
HR Retr Cd & .25 FTE Unclass – Data Sources is Operational Data.
HR Retr Cd AN Class – Data Sources is Operational Data.
HR Retr Cd is Blank – Data Sources is Operational Data.
HR Retr Status Cd is Blank – Data Sources is Operational Data.

SRP Queries Folder

HR SRP Code is Blank – Data Sources is Operational Data.
HR SRP Code of Y and blank deduct cd – Data Sources is Operational Data.
HR SRP data all assignments for FY – Data Sources is Operational Data.
HR SRP deduction information in SCUPPS – Data Sources is Operational Data.
SRP possible newly eligible – Data Sources is Operational Data.

Hyperion/Brio eLearning - Self-Paced Training

Institution Profiles

Institution profiles for all Minnesota State Colleges and Universities are now available in PDF format:

Institution Profiles

Demographic Reports

The following Demographic Reports are available in PDF format:

Questions about HR Reporting using the MnSCU Data Warehouse should be directed to Karen Cejka (651-297-4711), karen.cejka@so.mnscu.edu) in the Office of the Chancellor.

Human Resources: A Division of the Office of the Chancellor