Data Warehouse, Data Marts, & Application Manager (AppWorx) Information

Owned by Anonymous
Last updated: Oct 05, 2022 by Julie Schneider

Overview

The Data Analytics & Reporting Team (DART) manages data in the Data Warehouse and the Repository that is used to support state and USF operational reporting.  

Data Warehouse

Data Warehouse is a collection of tables, views, snapshots, and other objects designed for the purpose of state and operational reporting. Information on the main objects in the Data Warehouse can be obtained in the document Data Warehouse Tables and Views Available to Users. 

Some tables and views related to the main tables are not included in the above documentation. Detailed information on these and other Data Warehouse tables and views is available in the MetaMart.  

Data Warehouse application, forms, and documentation:


Standards for Development and Documentation

Read about standards for Data Warehouse database tables and views and, Applications Manager (AppWorx) process and job documentation, and repository usage. 

Data Marts Applications

Data marts provide access to subject oriented data in a data warehouse environment, such as student admissions data or data reported to the Board of Governors. 

Security privileges are required to access data in USF data marts. Privileges could be one of, or any combination of, the security privileges listed below:

  • USF Net ID and password
  • Security privileges granted to a specific mart and/or specific pages within that mart (these privileges are usually granted manually)
  • Security privileges granted to a specific group, such as a data steward group

Data Marts Page

Data Marts Page contains links to the data marts listed below. To bookmark the Data Marts Page, use the URL https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=103:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is only good for that one browser session. 

MetaMart

The MetaMart is an interactive tool that allows business and technical users to easily locate information about USF enterprise business systems metadata. To bookmark the MetaMart, use the link https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is only good for that one browser session. 

Hub Mart

Hub Mart provides access to the data collected for BOG reporting and Operational uses. This application also provides functionality needed to upload data to select tables and functionality to give data steward groups access to select views. To bookmark the Hub Mart, use the URL https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=110:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is only good for that one browser session.

Doc Mart

Doc Mart provides access to documentation on the data extracted and stored for the BOG file submission. This includes information on data sources and identifies which USF data element meets which SUDS data element. To bookmark the Doc Mart, use the URL https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=123:1, not the URL generated when you follow it in your web browser. Your web browser will add a session ID that is only good for that one browser session. 

Finance Mart

Finance Mart provides access the Department Ledger reports. 

Admissions Mart 

Admissions Mart is a series of reports returning key indicators on the current University application pool allowing for year comparisons and providing critical data to support enrollment management decisions.

Application Manager (AppWorx)

Applications Manager is an administrative systems automation tool with which Banner users, with the appropriate privileges, can do process-dependent scheduling.

Report Documentation 

USF Reports Documentation 

IT Analytics, SVC4010, Contact Us