Dss-Decision-Support-System

(6/29/01 - advanced copy from Tammy Murray)
Description of the System:

Decision Support System (DSS) provides specific data to University staff members who need information to perform their jobs. This service facilitates the manipulation of data so that sound quality management decisions can be made. It integrates data from multiple sources, such as Financial, Human Resources and Student systems. It also provides a presentation format that is more user-friendly, and facilitates cross functionality among the University Staff.

DSS uses operational files from Purdue's human resources, financial, and student information systems to create DSS tables which are easy to use and designed to provide quick and accurate responses to users' queries. Academic schools and business offices can use this information to manage their operations.

The Decision Support System allows access to an Oracle database server that contains much of the University's administrative data. By using Oracle query tools (such as Brio) or other software that support Open Database Connections (ODBC) such as Microsoft Excel, this data can be retrieved.   Custom reports, graphs and tables can be created from this retrieved data.

Period of Agreement:

This agreement will be reviewed annually and will be modified by mutual agreement when there are changes that impact the agreed upon service levels.

Main Roles:

Roles that will be used to support DSS are as follows:
System Owners:   Mike Szczepanski , Peg Jasper, Barb Stahura, Data Stewards
Business Analyst:   Tammy Murray, Dan Whiteley, WAI Analysts
Data Base Administrator:   Ernest Stalnaker, Data Base Administrator
Production Control:   Production Control Administrators, Ted Weidner, Dick Spear, Don Marshall, Production Control Group Leaders: Student - Lorna (Autosys), Business - Karen Sturgeon (Autosys)
Additional Technical Support:   WAI Team (Debbie Belter, Melissa Burton, Clif Ivy, Wendy Huston, Amy Prior) and UNIX administration (Bob...