UMS data marts are comprised of data from our Oracle PeopleSoft databases. Fields from the database are organized into fact tables and dimension tables. Very generally, the fact tables store the measurements, and the dimension tables store the attributes. Querying combinations of facts and dimensions generates the results in rows of data.
Below are the fact and dimension tables in the Applicant Data Mart. The shape of the schema below, a star schema, consists of a center fact table with connections radiating outward to the dimension tables.