1
CBM: UBC's "One Stop" Billing and Payment Web Service
Gordon Uyeda, Project Manager
Fred Wang, Systems Analyst
Nancy Low, Manager Registration & Systems Support
Copyright Gordon Uyeda, Fred Wang, Nancy Low (2004). This work is the intellectual property of the authors. Permission is granted for this material to be shared for non-commercial, educational purposes, provided that this copyright statement appears on the reproduced materials and notice is given that the copying is by permission of the authors. To disseminate otherwise or to republish requires written permission from the authors.
2
What is CBM?
• combined bill of partner merchant’s Charges
• multiple payment options
• Components1. CBM
2. CBM web service
3. EFT payment module
4. CBM administration module• CBM will not:
– assess Charges– determine Payment Due Dates– update Merchant’s records
3
• CBM - invoice Nov 2002
• CBM - CC payment Dec
2002• CBM - EFT payment
Dec 2003
The University of British Columbia
Student Services
Report of the Customer Service
Business Process Reengineering Team
Student Information Management Plan
On the Edge of the Future
• SIMPL BPR Fall 2000
• Credit Card payment July
2000
History
4
Customers• Types:
– prospects– applicants– students– alumni
• Origins– 145 countries
• Types of Study– Full and Part Time– Life Long Learning– Exchange programs
5
Customers
• Convenience– “One-Stop” Bill payment– 24 x 7 access– remote access
• Flexibility– multiple payment options– multiple payment plans
• Peace of Mind– Transactions are secure– Data secure
6
Merchants
• 12 Faculties
• 11 Schools
• 1 College
• >100 Academic departments/units• > 30 Administrative units
– Registrar’s Office– Housing– Food Services– Career Services– Student societies
7
Merchants - Benefits
• flexibility – Merchant specified options– phased implementation
• cost savings– automatic generation of GL transactions– auto-reconciliation process and tools– “favorable” Credit Card rates
• Payment reports available• Refund process
8
Partners
• TD Bank Financial Group
• First Data
• Canadian Payments Association
US references:• Electronic Funds Transfer Association (www.efta.org)
• Federal Reserve Board (www.federalreserve.gov)• Moneris-USA (www.monerisusa.com)• Vital (www.vitalps.com)
• Beanstream(www.beanststream.com)
9
CBM Components
CBM
Web Service
Primary financial
Institution
Web PaymentService Provider
CBMAdmin
CBM
FinancialManagement
System Tuition
HousingParking
10
Design Highlights
• Open system• Reliable messaging between CBM
and merchants• One reference number across
domain• Auto reconciliation between every
system
11
Tools and Technologies used
• J2EE (JBoss/Tomcat/JMS)• Castor Java/XML Binding• Oracle• Ant/Perforce• JUnit/Webload
12
CBM Credit Card Payment
AuthenticationWeb
Service
Student Service
Center
CBM
JVs
FinancialManagement
System
BankStatement
BankReconciliationfile
Merchant Web
Service
FinancialServices
Department
Primary Financial
Institution
Secondary Financial
Institution
Web PaymentService Provider
13
CBM EFT Payment
AuthenticationWeb
Service
Student Service
Center
CBM
Merchant Web
Service
University’s Financial
Institution
Student’s Financial
Institution
Automated ClearingSettlement System
Web PaymentService Provider
JVFinancialServices
Department
14
The Bill
15
Credit Card Payment
16
Payment Confirmation
17
EFT Payment
18
Housing10.26%
Tuition82.36%
Admissions2%
Transcripts0.26%
Workshops0.02%
Food Services5%
CBM Payments
19
Paid in-person (through banks)
19.1%
Internet banking11.3%
Debit cards4.8%
Other3.5%
CBM Credit Card
37.7%
CBM EFT0.4% Paid from
Awards23.2%
Tuition Payments
20
Lessons Learned
• First on the block
• enthusiastic, stable partners
• Costs vs Benefits
• be careful what you wish for
21
CBM Tomorrow
• Pre-Authorized Debit agreements• direct deposit into Student’s Bank Accounts
• SFM redevelopment• Credit Card verification • integration with Student Card
• increase EFT promotion• expand participating Merchants
22
Questions?
Gord Uyeda [email protected]
Fred Wang [email protected]
Nancy Low [email protected]
UBC SIMPL BPR Projecthttp://students.UBC.ca/facultystaff/simpl.cfm
eStrategywww.e-strategy.UBC.ca