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. Fact tables contain keys that point to dimensions and quantitative information. Summary tables also contain keys that point to dimensions as well as summarized quantitative information.
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. This report documents all fact, summary and dimension tables and columns available for reporting. 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.