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.
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.