Administrative Information Services(AIS)Home Page

Administrative Information Services (AIS)

AIS Services
MetaMart	The MetaMart is an interactive tool that allows business and technical users to easily locate information about USF enterprise business systems metadata. MetaMart FAQs
Data Warehouse	Data Warehouse Status Data Warehouse Projects Request Data Warehouse Access Data Warehouse Overview - DWHOUSE extracts summary 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.) Change Data Warehouse Oracle Password Report a Data Warehouse Issue Data Warehouse Reports
OASIS	OASIS Reports
USF Employee Directory	USF Employee Directory - search for faculty, staff, OPS, and courtesy employees
Resources
AppWorx	AppWorx Job Documentation AppWorx Documentation System (requires login) AppWorx Application - Development (requires login) AppWorx Application - Test (requires login) AppWorx Application - Production (requires login) AppWorx Policies
Enterprise Business Systems (EBS)	The EBS 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) Page
Portals	USF 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	AppWorx JobDoc Standards for BOG Documentation Business Requirements (BRD) Template Crystal Report Development and Deployment Data Warehouse Column Naming Standards Data Warehouse Table/View and Column Comment Standards Data Warehouse Table/View Naming Standards Oracle Reports Development 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

AIS Team
The AIS project team, located in SVC 4010, operates within the University Services Division of Information Technologies. David Soniat, AIS Team Coordinator, can be contacted by email: dsoniat@usf.edu or by phone: (813) 974-3053. Staff members: Sylvia Pagan (spagan@usf.edu), Julie Schneider (julies@usf.edu), Christine Frishett (cfrishet@usf.edu), Sunitha Balasubramanian (sunitha@usf.edu), and Meera Krishnamoorthy (mkrishna@usf.edu). Our goal is to build a Data Warehouse which will be easier, more efficient, and less costly to report from than the production databases. Our mission is to work in partnership with users, as we assist them in turning University DATA into useful information.

AIS Team

The AIS project team, located in SVC 4010, operates within the University Services Division of Information Technologies. David Soniat, AIS Team Coordinator, can be contacted by email: dsoniat@usf.edu or by phone: (813) 974-3053.

Staff members: Sylvia Pagan (spagan@usf.edu), Julie Schneider (julies@usf.edu), Christine Frishett (cfrishet@usf.edu), Sunitha Balasubramanian (sunitha@usf.edu), and Meera Krishnamoorthy (mkrishna@usf.edu).

Our goal is to build a Data Warehouse which will be easier, more efficient, and less costly to report from than the production databases.
Our mission is to work in partnership with users, as we assist them in turning University DATA into useful information.

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: September 25, 2009

Direct web site questions or comments to julies@usf.edu

University of South Florida