Why SIS?

For close to ten years the University of Northern Iowa has been considering how best to replace its aging Student Information System. This system supports the academic program by fulfilling core functional needs like course registration, grade reporting, student recordkeeping, application for enrollment processing, financial aid awarding, student billing, and degree auditing. Further, it stores data essential to academic advising, Regents reporting, international enrollment reporting, space scheduling, career services, alumni relations and other functions.

Our current system went on line in 1982. It's outdated and dying. In today's world, a desktop computer is outdated and needs upgrading or replacement when it's 2.6 years old -- compare that to UNI's student information system, which is 26 years old. It's like we're still using a rotary telephone. You can make a call with it, but you can't get parts to fix it and it doesn't interface with today's technology.

With the support of key personnel in all of the University's divisions, we have begun to plan in earnest for a new system. Our process will be open and engaging of those who, in the end, will use the system and those who will operate the system. We will seek to provide students with the best possible set of services, support faculty and academic units in their delivery of the academic program (our core mission), and meet institutional obligations in a cost-efficient manner.

Jan Hanish, Assistant Vice President for Administration and Finance, will serve as project leader. Let Jan or me know if you have questions about this effort.

Terry Hogan

Vice President for Student Affairs Student Information System (SIS) Position Paper

(View PDF Printable Version)

Scope

The University's Student Information System (SIS) is made up of a number of distinct modules including Student Records, Registration, Financial Aid, Billing and Accounts Receivable, Prospective Students and Admissions, Advising, and Residence. The number and variety of modules underline the fact that there are many stakeholders who have a strong interest in student services activities at the University and that this project will be a major undertaking.

The current SIS was developed by ITS staff and end users over the past twenty five years. It is very functional, highly customized, and still reliable, but the underlying database is becoming dangerously outdated. We believe it is critical to the University's future that the SIS be replaced within five years.

Rationale

SUPRA, the database management system that has been the foundation of the SIS for the past 25 years, is non-standards based and is no longer being marketed by the vendor (CINCOM). This database is also outdated technically, making it difficult to communicate with other databases or applications on other platforms. Most importantly, however, continued support from the vendor is very questionable which, in the long term (4-7 years), could render our system unusable. The current architecture and applications were designed in a different era of information systems and, consequently, are not as flexible and easily extendable as needed. It is becoming increasingly difficult to provide the automated services desired by students and ESS staff. One crucial example is that the current applications are unable to provide 24X7 operations. Another example is that many of our web based self-service applications reside on separate hardware/software platforms and are not interactive with the base system.

In addition to 24X7 access, new self-service applications require web forms, EDI, e-commerce, workflow, modern security and authentication all to be closely integrated into the applications. To the extent these capabilities exist in our current system, they were developed as an add-on to the base system. Consequently, these applications are highly complex, and therefore more vulnerable to problems than would be the case with a new, integrated system. Along with the acquisition of the Oracle Financial System, UNI purchased a campus license for the ORACLE database management system. ITS has selected the ORACLE DBMS as the University standard for campus wide database applications. The ORACLE financial system runs on a UNIX platform using SUN hardware. The current SIS runs on an MVS platform using IBM hardware. It is very expensive to support two such different administrative platforms. Additional staff and expertise are required to support multiple operating systems, databases, and development platforms. Additional software, hardware, and interfaces are required to integrate the disparate systems and data. Maintaining the current patchwork of platforms is becoming increasingly expensive. A new, integrated system will allow us to maintain it more easily, concentrating more on functional improvements and new capabilities rather than maintaining several platforms and preventing, as well as troubleshooting, breakdowns.

The current SIS was developed at a time when the need to manage transactions was the predominant driving force in the development of applications. Today, student data has become of considerable strategic value. New systems are now designed with management and decision making, as well as transaction functionality, in mind. The current system was developed by many people over 20 years and represents a significant University investment. We estimate total development cost for the current system to have been in the $12 million range.