Campus Solutions Data

The resources on this page are intended for staff who will be writing and running their own queries using database tools, a SQL tool, or other data querying and manipulation tools. These resources do not provide instruction on querying data, but instead cover Campus Solutions data in-depth for staff who write and run their own queries.

Reporting Decision Tree

The Reporting Decision Tree is a resource provided to help users evaluate different campus data resources in order to meet data needs. This information is available within a flowchart format and an accessible format.

Self-paced Training

MSU Information Governance Catalog v11.5 – Purpose and Navigation

This course will provide an introduction to MSU’s Information Governance Catalog tool. The IGC tool serves as MSU’s data dictionary for the Campus Solutions system. IGC contains column definitions, mapping tips for legacy SIS, and data protection/classifications to help us protect MSU data.

This course is intended for MSU staff who will need to query data from MSUEDW.

This course is available in D2L for self-enrollment. 

Additional Resources

  • Campus Solutions (CS) Code Book. The Code Book helps end-users of Campus Solutions data become familiar with the various codes and descriptions for commonly used elements of the system. The sections of this Code Book are in the SIS Reporting Center. If you have the security permissions to do so, log in to SIS, navigate to the Admin Home page, and click on the Reporting Center tile. The Code Book sections can be found in the “Codes and Resources” topical section in the left-hand side menu of the Reporting Center. If you have any questions, please utilize the contact form from the Staff Help & Support page > Reporting Center > Contact Form. Please note: The Campus Solutions Code Book in Excel format has been discontinued.
  • Job Aid - How to Schedule a Query

Academic Data Community

The Academic Data Community is a Microsoft Team that supports the Campus Solutions SIS data-using community at MSU. The information shared in monthly meetings, team channels and resources is geared toward those who write queries against the SIS data warehouse for reporting, application development and maintenance, longitudinal analysis, dashboard support, etc. This community offers support via regular meetings and provides a place for education, discussion, peer support, and resolution of data-related issues.

The Academic Data Community Team includes:

  • A "General" channel for messages of interest to the entire community, as well as
    • A "Resources" tab that provides information on how to get access to the SIS data warehouse, links to training documents and videos, and sample queries to get started in the data
    • Recordings of previous meetings and copies of presentations and supporting materials
    • End-user education training documents and videos for Campus Solutions data use
  • A "SIS Data Drop-In Help" channel, a very active, peer-supported forum where data users can ask questions, seek help, and find in-depth resources for SIS data and the derived reporting views and crosswalks in the data warehouse

Please note that access is restricted to MSU Staff and Faculty who have a business need to query SIS data. To gain access to the Academic Data Community Team please use this link to request access.

Training