This UMS Finance data mart is comprised of data from our Oracle PeopleSoft databases, mostly from UM_GLQ_REPRTING table and UM_GLQ_ACCTA table. 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 Finance Data Mart. The shape of the schema below, a star schema, consists of a central fact table with connections radiating outward to the dimension tables.