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:

• Data Warehouse status

• Data Warehouse

• Tables and Views Available to Users (available to DWHOUSE users based DAL security)

• Understanding DAL Security

• Request Data Warehouse access (Note: to log in and request a Data Warehouse account, you must use a computer with a USF IP address and use your NetID).

• Data Warehouse Maintenance Application

• Change your Data Warehouse Oracle password (DWHOUSE)

• Data Warehouse User Entitlement and Review Process
• Data Warehouse Reports - Email Subscriptions

• Report a Data Warehouse issue

Standards for Development and Documentation

Standards for Development and Documentation AnchorStandards for Development and DocumentationStandards for Development and DocumentationRead about standards for Data Warehouse database tables and views and, Applications Manager (AppWorx) process and job documentation, and repository usage. Back to Top

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

Doc Mart

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.

Data Marts Page.

Back to Top

Application Manager (AppWorx)

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

• Applications Manager process/job documentation (PDFs)Manager (AppWorx) job documentation

• AppWorx Documentation System (requires login)

• Applications Manager (requires login)

• Production instance (AMPROD) installation
• Production instance (AMPROD) client
• Test
instance 
• instance (AMUAT) installation
• Test instance instance (AMUAT) client
• Test upgrade instance (AMUATU) installation
• Test upgrade instance (AMUATU) client
• Development
instance 
• instance (AMDVLP) installation
• Development instance instance (AMDVLP) client
• Development upgrade instance (AMDVLPU) installation
• Development upgrade instance (AMDVLPU) client
• Applications Manager policies

Back to Top

Reporting AnchorReportingReporting

Report Documentation

Back to Top

USF Reports Documentation 

IT Analytics, SVC4010, Contact Us