1 cbm: ubc's "one stop" billing and payment web service gordon uyeda, project manager...

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 gord.uyeda@ubc.ca

Fred Wang fred.wang@ubc.ca

Nancy Low nancy.low@ubc.ca

UBC SIMPL BPR Projecthttp://students.UBC.ca/facultystaff/simpl.cfm

eStrategywww.e-strategy.UBC.ca