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
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.Projects/ApplicationsMajor activities include:
- Reducing paperwork by putting more information services and transactions online
- Collecting far-flung campus services and functions into easily accessible "portal" Web sites specially tailored to the needs of each community
- Streamlining access to course information and content
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
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:
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
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
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
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)
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
Last updated: Thursday, 29-Nov-2001 12:38:41 PST
webnet@berkeley.edu