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.

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: this Code Book will help end-users of Campus Solutions data become familiar with the various codes and descriptions for commonly used elements of the system. Included where appropriate are crosswalks to legacy SIS codes to assist in the transition to CS. 

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.