- BOG SUDS Conversion Project
|
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, must convert
all master files and any other ad hoc reporting for submission in
the new client server environment.
The architecture needed for the conversion will be created in the
Data Warehouse. Data necessary to produce the submission files will
be stored within that architectural structure.
This project is currently in the analysis and planning phrase.
Development is scheduled to begin soon. Additional details will be
posted to this page, as they become available.
The following master SUS files are scheduled to be converted:
| CONTEXTS |
| ADM |
Admissions |
RET |
Retention |
| CP |
College Prep |
SCD |
Salary Category Detail |
| EMP |
University Employee |
SFA |
Student Financial Aid |
| HTD |
Hours to Degree |
SPA |
Physical Facilities Space |
| IRD |
Instruction and Research Data |
STU |
Student Data Course File |
| LAP |
Limited Access Programs |
STUP |
Student Data Course File - Preliminary |
| OB |
Operating Budget |
TEF |
Teacher Education File |
|
- Oracle Databases Upgrade to 10g
|
Status: Completed
Completion Date: 3/2008 |
The following Oracle database instances were upgraded
to 10g:
-
FAST instances (FASTDVLP, FASTEST, and FASTPRO)
-
GEMS instances (GEMSDVLP, GEMSTEST, and GEMSPRO)
-
TAS instances (TASDVLP, TASTEST, and TASPRO)
The Data Warehouse test, production, and development instances (DWTEST, DWHOUSE and DWUPG)
and the Repository test instance (REP2) were successfully upgraded in May 2007.
The Repository development and production instances (REPDEV and REPO)
are scheduled to be upgraded at a future date (TBA).
|
- Appworx Upgrade to 6.1.3 (application)
|
Status: Completed
Inception Date: 1/2008 |
The Appworx application 5.1.1 is in the process of being upgraded to 6.1.3.
We are analyzing how this upgrade will affect Data Warehouse and REPO processes
and will notify users of any pertinent information.
The comparison report below shows the changes between the production and
pre-production databases. The Appworx production (current) database,
Version 5, is USFX2 (schema: APPWORX). The Appworx pre-production (upgrade) database,
Version 6, is USFX1 (schema: APPWORX3). An asterisk in the report represents a change to
an element within a table. Only tables that have changes appear in the report.
To view the database comparison report:
Please note: This report is less than 1MB in size.
Appworx V5 to
Appworx V6
The working document below is an Appworx Upgrade Analysis pertaining to the Data
Warehouse and the Repository.
Appworx
Upgrade Analysis (DWHOUSE & REPO)
|
- Oracle Business Intelligence (BI)
Proof of Concept Support
|
Status: Completed
Completed Date: 11/2007 |
USF has partnered with Oracle to demonstrate a set of Oracle BI tools, of which, USF currently holds licenses for use. Oracle will use student data to demonstrate how Oracle products, already licensed to USF, can benefit USF. These tools include, Oracle Portal, Oracle Internet Directories (OID), Oracle BI Publisher, Oracle Discoverer, and Oracle Warehouse Builder (OWB). Additionally, Oracle will demonstrate several tools that are not currently licensed to USF, including Oracle OLAP and Oracle BT Extended Addition.
|
- GEMS 8.9 Upgrade (application)
|
Status: Completed
Completion Date: 9/2007 |
The GEMS 8.9 upgrade is now complete. Some Data Warehouse tables were be affected by this upgrade. Below is a summary of the changes.
| COLUMNS TO BE ADDED |
| GEMS_APPOINTMENT Column |
Current Source Column/Table |
| USF_ID |
SPRIDEN in OASIS (using SWBEMID crosswalk table in
OASIS) |
| COLUMNS TO BE REMOVED |
| GEMS_APPOINTMENT Column |
Current Source Column/Table |
| NATIONAL_ID |
PS_PERS_NID.NATIONAL_ID |
| BACKGROUND_CHECK_FLG |
PS_POSITION_DATA.U_BACKGROUND_CHECK |
| DUAL_COMP_APPROV_FLG |
PS_JOB.U_DUAL_COMP_APPROV |
| LAW_ENF_DATE |
PS_JOB.U_LAW_ENF_DATE |
| ONCALL_FLG |
PS_POSITION_DATA.U_ONCALL |
| OVERLAP_FLG |
PS_JOB.U_OVERLAP_FLAG |
| CAMP_LOC_BLDG |
PS_JOB.U_CMP_LOC_BLDG |
| CAMP_LOC_ROOM |
PS_JOB.U_CMP_LOC_ROOM |
| ADMIN_CODE_DATE |
PS_JOB.U_ADMIN_CODE_DTE |
| L0_EMPL_DIRECTORY Column |
Current Source Column/Table |
| PHY_LOC |
GEMS_APPOINTMENT.CAMP_LOCN_BLDG||
GEMS_APPOINTMENT.CAMP_LOCN_ROOM |
| COLUMNS with SOURCE CHANGES ONLY |
| GEMS_APPOINTMENT Column |
Current Source Column/Table |
New Source Column/Table |
| CONTINUOUS_SRVC_DATE |
PS_PERSONAL_DATA.U_CONTINUOUS_SRVCE |
PS_PERSON.U_CONTINUOUS_SRVCE |
| HIGHEST_DEGREE_YR |
PS_PERSONAL_DATA.U_YR_HIGHEST_DEGRE |
PS_PERSON.U_YR_HIGHEST_DEGRE |
| LEADWORKER_FLG |
PS_POSITION_DATA.U_LEADWORKER |
PS_POSITION_DATA.MANAGER_LEVEL |
| MED_CLINICAL_FLG |
PS_U_PERSONAL_DATA.U_MED_CLINICAL |
PS_PERSON.U_MED_CLINICAL |
| MED_SPECIALTY |
PS_U_PERSONAL_DATA.U_MED_SPECIALTY |
PS_PERSON.U_MED_SPECIALTY |
| MONTHS_PRIOR_SRVC |
PS_PERSONAL_DATA.U_MNTHS_PRIOR_SRVC |
PS_PERSON.U_MNTHS_PRIOR_SRVC |
| PHONE_WORK |
PS_EMPLOYMENT.PHONE |
PS_EMPLOYMENT.POSITION_PHONE |
| SELECTIVE_SRVC |
PS_PERSONAL_DATA.U_SELECTIVE_SRVCE |
PS_PERSON.U_SELECTIVE_SRVCE |
| YRS_PRIOR_SRVC |
PS_PERSONAL_DATA.U_YRS_PRIOR_SRVCE |
PS_PERSON.U_YRS_PRIOR_SRVCE |
| COLUMNS with NAME and SOURCE CHANGES |
| Current Column - GEMS_APPOINTMENT |
Current Source Column/Table |
New Column - GEMS_APPOINTMENT |
New Source Column/Table |
| FAC_ADMIN_CODE |
PS_JOB.U_FAC_ADMIN_CODE |
SUPV_LVL_ID |
PS_JOB.SUPV_LVL_ID |
| FAC_ADMIN_CODE_DESC |
PS_U_ADM_TITLE_TBL.DESCR |
SUPV_LVL_DESC |
PS_SUPVSR_LVL_TBL.DESCR |
| FIN_DISCLOSE_FLG |
PS_POSITION_DATA.U_FIN_DISCLOSE_IND |
KEY_POSITION_FLG |
PS_POSITION_DATA.KEY_POSITION |
| PROBATION_END_DATE |
PS_JOB.U_PROBATION_ENDDTE |
PROBATION_DATE |
PS_PER_ORG_ASGN.PROBATION_DT |
| TIME_LIMITED_FLG |
PS_POSITION_DATA.U_TIME_LIMITED |
REG_TEMP_FLG |
PS_POSITION.REG_TEMP |
| COLUMNS with SOURCE and DATA LENGTH CHANGES |
Current Column in GEMS_APPOINTMENT |
Current Source Column/Table |
New Source Column/Table |
Current data type/length |
New data type/length |
| JOB_ACTION_DESC |
PSXLATITEM.XLATLONGNAME |
PS_ACTION_TBL.ACTION_DESCR |
VARCHAR2(30) |
VARCHAR2(50) |
| POSITION_ACTION_DESC |
PSXLATITEM.XLATLONGNAME |
PS_ACTION_TBL.ACTION_DESCR |
VARCHAR2(30) |
VARCHAR2(50) |
| COLUMNS with DATA LENGTH CHANGES |
| Current Column - GEMS_APPOINTMENT |
Current Data Type/Length in GEMS_APPOINTMENT |
New Data Type/Length in GEMS_APPOINTMENT |
| ETHNIC_GROUP_CODE |
VARCHAR2(1) |
VARCHAR2(8) |
The comparison reports below show the changes between the production and
pre-production databases. GEMSPRO is the production database and GEMSTMP3 is the pre-production
(upgrade) database. An asterisk in the report represents a change to an element within a table. Only tables that have changes appear in the report.
To view the database comparison report: Please note: These reports
range from less than 1 MB to almost 3MB in size.

|
- FAST 8.9 Upgrade (application)
|
Status: Completed
Completion Date: 8/2007 |
The FAST 8.9 upgrade is now complete.
The FAST Financials system underwent an application upgrade from version
8.4 to version 8.9. The upgraded version provides FAST users with new features and an updated
appearance. FAST's financial management system integrates USF's administrative services and
its business, financial and accounting systems. The 8.9 upgrade increases delivered systems functionality
and provides enhanced business and financial operations for the University's financial and administrative
services systems.
FAST Financials 8.9 Upgrade Highlights:
• New features for Navigation, Commitment Control and Grants Management
• Enhanced functionality to financial systems integration
• Improvements to data integrity and regulatory reporting capabilities
Upgrade information, including FAST 8.9 Delta Training, is published on the FAST website. If you have any questions about the FAST 8.9 upgrade cutover, please contact J.R. Reed, PeopleSoft Functional Project Director, at Jrreed@admin.usf.edu or by telephone at 974-5457.
The comparison report below shows the changes between the production and
pre-production databases. FASTPRO is the production database and FASTTMP4 is the pre-production
(upgrade) database. An asterisk in the report represents a change to an element within a table. Only tables that have changes appear in the report.
To view the database comparison report:
Please note: This report is almost 4MB in size.
|
- Oracle Application Server Upgrade to 10g
|
Status: Completed
Completion Date: 4/2007 |
All Oracle application servers, including Panacea, have been upgraded from Oracle 6i to Oracle 10g. Upgrade of the development instances is complete. Some of the applications on Panacea are the MetaMart, Appworx Documentation System, Application Express, and the AIS website.
|