Webnet home

e-Sampler: Doing campus business on the Web

This page is a companion to the Webnet User Group presentation given Friday, October 5, 2001.

Page Contents:
RSF e-signup
CNS Shopping Cart
Residence Hall Telephone Service
eParking
Paperless Payment Processing
ezSurePay

Introduction
e-Berkeley is a new Chancellor's initiative whose goal is to use the power of the Web to transform the way the university operates, from day-to-day functions to its central mission of teaching and research.

Major activities include:

e-Berkeley funded projects: e-Berkeley has funded 9 campus projects that will be "coming online" in the near future.

Contact information: Jon Conhaim, e-Berkeley Director, conhaim@uclink.berkeley.edu

Link to more information: http://eberkeley.berkeley.edu

Projects/Applications

RSF e-signup

General description of project: Online student enrollment in Cal Rec Club

Architecture of application: Oracle rdbms, J2EE app server (JBoss), Enterprise Java Beans, servlets, JavaServerPages RSF Deployment Architecture

Tools used: TogetherJ, Xemacs JDE, JUnit framework, JMeter, ant

Developer contact information: Randy Ballew, Student Information Systems randy@socrates.berkeley.edu

Links to more information:


Back to top

CNS Shopping Cart

General description of project: The CNS Shopping Cart allows users to order CNS products and services through a "shopping cart" interface. Users can browse products and services and get detailed product information, including prices, before ordering. The CNS Shopping Cart also takes some of the order entry burden from the CNS customer service representatives.

Architecture of application: Progress Database using 4GL and Webspeed (proprietary Progress languages). LDAP. Perl/PerLDap.

Tools used:

Developer contact information: Kellie Hobbs, IST-CNS kellie@socrates.berkeley.edu

Links to more information: CNS Online Services


Back to top

Residence Telephone Service

General description of project: Allow Residence Hall students to sign up for the Residence Hall long distance telephone service by logging into the http://rts.berkeley.edu/ Web site using their Calnet ID. They can read the terms & conditions of the service, accept the terms, and receive their new Individual Authorization Code. This service permits students to make long distance calls from their dorm room. Students can also view their bills on the same Web site.

Architecture of application: Progress database backend interacting with Webspeed and 4gl programs to create HTML pages. We use MySoft software from Compco to determine the cost of calls and to ftp bills to CARS. Payments are made through CARS.

Tools used: Webspeed, HomeSite

Developer contact information: Gil Hilliard, IST-CNS, hilliard@socrates.berkeley.edu

Links to more information: Residence Telephone Services and ORCA/RTS


Back to top

eParking

General description of project: The eParking application enables access to various University Parking services at all times (24/7) via the web without waiting in lines or physically going to the Parking office. The first phases of this project involve obtaining parking permits.

This project is in phases:
I. Faculty/staff permit renewals on-line for people with payroll deduction (implemented in June, 2001)
II. Student permit purchase on-line (implemented in August, 2001)
III. Citation Payments (targeted for January, 2002)

Future phases intend to allow for Citation appeal, Visitor parking (by departments), Public parking (for special events & direct), Faculty/staff new permit issuance, and transportation tickets

Architecture of application: In an effort to meet the challenge of implementing various eParking services online, Parking & Transportation chose a solution that extends the functionality of our existing proprietary business transaction system, "Power Park". Designed to meet the needs of a large institution, Power Park was developed by T2 Systems Incorporated, which represents one of the Parking Industries most sophisticated business applications.

The "Sales" Application Programming Interface (API) is a module developed by T2 that functions with our Oracle relational database and provides the ability to conduct sales through a web browser. The API was customized to meet the needs of the University using ASP programming.

Phase II of eParking enables registered students to purchase parking permits online using CARS (Campus Accounts Receivable System) as a method of payment. First a student is authenticated via the CalNet Authentication Web Server (AWS). If the student is successfully authenticated, an LDAP directory look-up retrieves the necessary attributes to determine that the student is currently registered and the information necessary to build a CARS billing record. For the Spring semester 2002 there are plans to enable the credit card method of payment by integrating with the campusÕ CyberSource paperless payment processing system.

Tools used: Visual InterDev and Notepad

Department contact information: Chris Jansen, Public Safety & Transportation, cjansen@uclink.berkeley.edu

Developer contact information: T2 Systems, info@t2systems.com

Links to more information: eParking and e-Parking Project: Parking & Transportation paves the way to online services


Back to top

Paperless Payment Processing

General description of project: Known today as ÒPaperless Payment ProcessingÓ, this project is one of the eBerkeley Initiatives for fiscal year 01/02. As a result, funding has been received for developing the technical solution, delivering the basic service to department/activity e-businesses, paying the vendor startup fee and annual maintenance, and at least for the first year, paying the monthly transaction fees. A campus agreement has been signed with CyberSource and a business relationship established to create a process for a payment gateway, to interface with processors and banks and make it possible for the campus to store credit card numbers off-site. IST and Business Services have been working with 2 pilot and 4 priority e-business application sponsors to refine our solution and services. From the technical point-of-view, the key consideration is security. This has led to the development of the ÒUCB Hub ProcessorÓ which handles all outbound and inbound transactions to and from the campus with CyberSource.

Architecture of application:SQL Server, Microsoft ASP

Tools used:Visual InterDev, 3rd party server to server tool

Developer contact information:Gary Thackeray, IST-ASD/DTS, cpthelp@uclink.berkeley.edu

Links to more information:

Credit-card processing solution for campus e-businesses now available (Nov-Dec 2001)
Update on credit-card processing solution for campus e-business (Spring 2001)
Credit-card processing solution for campus e-business (Winter 2001)


Back to top

ezSurePay

General description of project: EzSurePay is a web-based application that enables active UC Berkeley faculty and staff to access their current and past Surepay statements via the Internet.

Architecture of application: EzSurePay is a SQL Server 2000 based application that is accessed via a web server running MS IIS 5.0. The application layer was written in SQL and VB script, and the presentation layer was developed using a combination of PERL, Java script, HTML, and ASP. The system is accessed via a web browser through the standard CalNet authentication process and utilizes LDAP to resolve CalNet ID to employee ID.

Tools used: Dreamweaver UltraDev, Adobe Photoshop, Allaire Home Site, SQL2000, Active PERL

Developer contact information: Liz Church, Business Services, 643-6589, church@uclink.berkeley.edu

Links to more information: ezSurePay and BAS ezSurePay: Online SurePay statements



[Webnet Homepage] - [Webnet Calendar] - [Webnet Mailinglist] - [About Webnet]

Last updated: Thursday, 29-Nov-2001 12:38:41 PST
webnet@berkeley.edu