Student Data Warehouse

This page contains various reports about the data within the data warehouse.  Please review the information and email any comments to Cheri Harwell.

Reporting Tables

These tables are used for all reporting.  The data is derived from the ODS Base Tables.  It is denormalized for easier access and standardized for system wide reporting.  Some information is summarized for faster, easier reporting.  Missing and questionable SIS data is cleansed in the load process.  The original SIS data is included for institutional reference.

There are three types of tables:

  1. Fact tables contain keys that point to dimensions and quantitative information.
     
  2. Summary tables also contain keys that point to dimensions as well as summarized quantitative information.
     
  3. Dimension tables contain descriptive information about the fact or summary tables.

The tables are grouped into star-schemas.  Each schema contains a subject area that consists of a fact or summary table surrounded by dimension tables.

Star Schema Diagrams

These diagrams illustrate the contents of each subject area and relationships between the fact/summary table and the dimension tables:

This report documents all fact, summary and dimension tables and columns available for reporting:

Operational Data Store (ODS) Base Tables

These tables contain all the information that is extracted from SIS.  This data is used to load the Reporting Tables.  The column names are the same as the field names in SIS except the table name is added at the end.  So the column GENDER_NAME is the GENDER field from the NAME table in SIS.  This data is not used for reporting.  It is not standardized for system wide reporting and some of the data is missing and of questionable quality.  However, as time goes on, we hope to cleanse and add all elements to the Reporting Tables.

This diagram illustrates all tables and columns that have been extracted from the SIS databases:

This report documents all tables and columns that have been extracted from the SIS databases:

SIS and Standard Codes

Each institution has its own codes within their SIS database.  In order to provide system-wide reporting, those codes have been translated to standard codes.  All original SIS codes are maintained in the data warehouse for institution reference.  The following documents describe the relationship between the institutional SIS codes and the standard data warehouse codes.

These reports list all SIS codes and the standard code that has been assigned to each one.  Program and Degree codes have their own report.  The rest are together in the second report.  Every SIS code must translate to a standard code!  The reports are indexed by institution for easy access:

These reports list all standardized codes and all SIS codes that have been assigned to them.  Use these reports to see all SIS codes from all institutions that are assigned to a particular standard code:

This report lists all of the standardized codes that the System Administration Office will use for reporting.  Use this report to look up all the possible standard codes:

Note to SIS users:  If you see any translations for your institution that are incorrect, please send an email with the correct standard code to Cheri Harwell.