Data Warehouse Projects

     
  • FAST and GEMS Maintenance Pack 11
     
    (ABS Operations maintenance)
Status: In Progress
Inception Date:
02/2009

Maintenance Pack 11 will be applied to FAST and GEMS database instances.  The pack has been applied to the FAST and GEMS upgrade instances, FASTUPG and GEMSUPG.  The application of this pack is currently undergoing testing.

The comparison reports below show the changes between the production and pre-production (upgrade) databases. FASTPRO and GEMSPRO are the production databases and FASTUPG and GEMSUPG are the pre-production databases. An asterisk in the report represents a change to an element within a table. Only tables that have changes appear in the report.

View the database comparison reports:
Please note: The reports are large in file size.

 
  • BOG SUDS Conversion Project
    (USR 07-0165)
Status: In Progress
Inception Date:
10/2007
The Florida Board of Governors' (BOG) Information Resource Management (IRM) is converting the State's Reporting System from a mainframe environment to a client server (ORACLE) environment. As a result, the institutions within the SUS, including USF, were required to convert all master files and other ad hoc reporting for submission in the new client server environment.

The architecture needed for the conversion was created in the Data Warehouse.  Data necessary to produce the submission files is now stored within that architectural structure. 

This project has been implemented and is currently in its final stage. Master SUS files for the following areas have been converted:

CONTEXT AREAS
ADM Admissions OB Operating Budget
CIM Central Identity Management System RET Retention
CPC College Prep Completion SCD Salary Category Detail
EA Expenditure Analysis SFA Student Financial Aid
EMPL University Employee SIF Student Information  File
HTD Hours to Degree SIFP Student Information File - Preliminary
IRD Instruction and Research Data SPA Physical Facilities Space
LAP Limited Access Programs TEF Teacher Education File



Last Updated:   February 25, 2009


spacer
Copyright © 2002, University of South Florida, 4202 E. Fowler Avenue, Tampa, FL 33620 -- (813) 974-2011
spacer
Direct questions or comments about the Web site to Julie Schneider, jschneid@admin.usf.edu.