Administrative Information Services (AIS)

AIS Services

MetaMart

 bullet 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: http://panacea.fastmail.usf.edu/pls/ax_repo/f?p=1056:1

Data Warehouse

bullet Data Warehouse status
bullet Data Warehouse projects
bullet Request Data Warehouse access (requires NetID login). Activate your NetID!
bullet Data Warehouse Application (requires NetID login).  Activate your NetID!
bullet Data Warehouse Technical Documentation - DWHOUSE main tables, views, and snapshots detail information. (Some tables and views related to main tables are not included in the tech documentation.  For specific  information on related tables and views, read the individual table/view comments in the MetaMart.)
bullet Change Data Warehouse Oracle password
bullet Report a Data Warehouse issue
bullet Data Warehouse reports

OASIS

bullet OASIS reports

USF Employee Directory

USF Employee Directory - search for faculty, staff, OPS, and courtesy employees
Resources

Applications Manager (formerly known as AppWorx)

 bullet Applications Manager process and job documentation
bullet AppWorx (Applications Manager) Documentation System (requires login)
bullet Applications Manager production instance (requires login)
bullet Applications Manager test instance (requires login)
bullet Applications Manager development (requires login)
bullet Applications Manager policies

Business Systems Reengineering (BSR)

 The BSR website contains information about the University enterprise-wide information systems (i.e. OASIS, GEMS, FAST, and Data Warehouse) and ancillary systems (e.g. Blackboard, ID Card System, etc.). 
PMO User Service Request (USR) (search page)
Submit a USR
Submit a Project Change Request (PCR)

Portals

MyUSF Portal (requires authentication) - Enterprise Business Applications: GEMS, FAST! and Data Marts
IT Portal (requires authentication) - Staff Announcements, Department Information and Documentations, etc.

Standards for Development and Documentation

Applications Manager (AppWorx) Process and Job Documentation Standards
Data Warehouse Column Naming Standards
Data Warehouse Table/View and Column Comment Standards
Data Warehouse Table/View Naming Standards
REPO Standards for Usage
SQL and PL/SQL Best Practices and Standards

ORACLE and SQL Resources

ORACLE and SQL resource web links - references, guides, tutorials, forums, listservs, books, and more

Administrative Information Services (AIS) Team

Our goal is to make reporting easier, more efficient, and less costly through Data Warehousing information harvested from the production systems.

Our mission is to work in partnership with Data Warehouse consumers by assisting them in turning University data into useful information.


Administrative Information Services (AIS) operates within the University Services Division of Information Technologies
David Soniat, Associate Director - Information Technologies, dsoniat@usf.edu, (813) 974-5053, SVC4010, AISteam@usf.edu.

& A USF IP address is required to view this web site. This web site is best viewed with a display resolution of 1024 x 768 pixels using Internet Explorer 5.5 or higher.
Last Updated:  January 13, 2012

spacer
Copyright © 2002, University of South Florida, 4202 E. Fowler Avenue, Tampa, FL 33620 -- (813) 974-2011/font>
spacer
Direct web site questions or comments to AISteam@usf.edu