Administrative Information Services(AIS)Home Page

WELCOME to ADMINISTRATIVE INFORMATION SERVICES

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.

OUR SERVICES
MetaMart	MetaMart FAQs
Data Warehouse	Data Warehouse Status Data Warehouse Projects Request Data Warehouse Access Data Warehouse Overview -- summary of DW extracts Technical Documentation -- detail of DWHOUSE main tables, views, and snapshots. (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
Appworx	Appworx Policies Appworx Job User Documentation Appworx v6 Development Appworx v6 Test Appworx v6 Production Appworx Documentation System (requires login)
USF Portal	USF Portal (requires authentication) - access Enterprise Business Applications, incl. GEMS, FAST! and data marts.
USF Reporting Users' Group	The USF Reporting Users' Group meets monthly on the fourth Wednesday of the month, from 11am - 12pm in SVC 4011. Subscribe to our new Reporting listserv! Click subscribe or send an e-mail to: listserv@listserv.admin.usf.edu , and then in the body of your message, type: sub REPORTING
List of Reports: OASIS	OASIS List of Reports and detailed documentation - run many of them instantly on the web server!
List of Reports: Data Warehouse	Data Warehouse List of Reports and detailed documentation - run a report or view previously executed output.
Enterprise Business Systems	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.). EBS web pages are packed with useful resources and contain application login pages. User Service Requests (USR) can be submitted and the status of those requests reviewed through the EBS website.
Employee Directory	USF employee Directory Search (faculty, staff, OPS, courtesy, etc.)
Standards	Standards for Oracle Reports Development Crystal Report Development and Deployment Data Warehouse Column Naming Standards Data Warehouse Table/View Naming Standards Data Warehouse Table and Column Comment Standards REPO Standards for Usage
ORACLE and SQL Resources	ORACLE and SQL resource web links - references, guides, tutorials, forums, listservs, books, and more

AIS PROJECT 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@admin.usf.edu or by phone: (813) 974-3053. Staff members: Sylvia Pagan, Julie Schneider, Christine Frishett, Mimi Christien, Roselyne Christien, and Meera Krishnamoorthy. 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 PROJECT 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@admin.usf.edu or by phone: (813) 974-3053.

Staff members: Sylvia Pagan, Julie Schneider, Christine Frishett, Mimi Christien, Roselyne Christien, and Meera Krishnamoorthy.

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.

Last Updated: Jan. 8, 2008

Direct web site questions or comments to jschneid@admin.usf.edu

University of South Florida