SETA Southeast Regional Conference RTS Payment Gateway

Document Sample
SETA Southeast Regional Conference RTS Payment Gateway Powered By Docstoc
					        SETA Southeast Regional
              Conference

        RTS Payment Gateway
                   Doug Cackett
                   RTS Incorporated
                   www.rtsdba.com


          Wednesday, May 21, 2003 12:45 PM

Session Code
   Session Rules of Etiquette
• Please turn off your cell
  phone/beeper
• If you must leave the session
  early, please do so as
  discretely as possible
• Please avoid side
  conversation during the
  presentation

Thank you for your cooperation!
               Introduction
• RTS Payment Gateways
  – Pro Version
  – Link Version
 Topics of Discussion

• E-Commerce and Banner
• RTS Payment Gateway
  – Review Features
  – Advantages
 Campus E-commerce Needs
• Serving Students
  –   Accept, Authorize, and Process payments online
  –   Value Added to Banner’s On-Line Self-Service Modules
  –   Updates Student Database in “Real Time”.
  –   Process transactions all the time, anytime


• Serving Administration
  – Less paperwork
  – Shorter Lines
  – Collect $$$ faster … anytime, anywhere
       Credit Cards Online
• Process transactions all the time,
  anytime
       Electronic Checks/ACH
• Acceptance checks online, in real-time
• Offering payment via electronic check (ACH), in
  addition to credit card or physical checks, enhances
  payment options, convenience, and satisfaction
• Usually a per transaction fee rather than a discount rate.
   – Saves lots of $$$ over credit cards
      Developed for Banner
• Plug into your existing Banner environment

  – PL/SQL Packages
     • Installed into the Oracle Database
     • Stand-Alone packages – no mods to Banner
  – JSP
     • Installed on existing Web Server

  – Runs on Oracle8i or Oracle9i
  – Runs on Oracle Application Server or 9iAS
      Developed for Banner

• Rule Based
  – Processing Rules are defined by the Institution
  – Rules are maintained in Banner by the Users
               Topic Three
• Details about this
  topic
• Supporting
  information and
  example
• How it relates to
  your audience
    Rules Based (examples)

–   PAY BY TERM                        –   POP UP TIME
–   PAY IN FULL                        –   PMT SOURCE
                                       –   CCARD
–   PRE PAY
                                       –   ADDRTYPE
–   PRE PAY TERM
                                       –   EMAIL CODE
–   AR HOLD
                                       –   CC DETAIL CODE
–   ALLOW CCARD                        –   CK DETAIL CODE
–   ALLOW CHECK                        –   MIN CK PAY
–   CASHIER                            –   MAX CK PAY
–   MAX CC PAY                         –   NOTEFAID
–   MIN CC PAY                         –   POPSEL



    Defined by Module (Student Accounts/Admissions)
                   Benefits
• Cost are more in line for Small schools
• Costs Less
  – No additional hardware/Licenses
     • Runs on your current OAS/iAS and RDBMS Servers
  – Up to 80% cheaper
• Implementation easy and painless.
                   RTS Payment Gateway “Pro”
                    Example – Credit Card Transaction



• Add Link to any existing Banner Web Page via Web Tailor
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
Example – Credit Card Transaction
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
 Example – Credit Card Transaction
RTS Payment Gateway “Pro”
  Example – Check Transaction
RTS Payment Gateway “Pro”
  Example – Check Transaction
RTS Payment Gateway “Pro”
  Example – Check Transaction
RTS Payment Gateway “Pro”
  Example – Check Transaction
RTS Payment Gateway “Pro”
  Example – Check Transaction
RTS Payment Gateway “Pro”
  Example – Check Transaction
RTS Payment Gateway “Pro”
  Example – Check Transaction
                              WGRCPMT Report
                                                Runs via Jobsub
                                              Uses Banner Security




28-Feb-2002                                   RTS University TEST                                            PAGE 1
WGRCPMT                                        Web CC Payments

Transaction Period:       28-Feb-02 to 01-Mar-02


ID              Name                       Code           Order No.             Invoice TransDate Amount
-------------   ------------------------- -------------- -------------------- ---------- ------------- --------------
566636441        Student, Sussie B.         WDCC           V63A10663264 2021               28-Feb-02        6,060.00
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
-------------   ------------------------- -------------- -------------------- ---------- ------------- --------------
                                                                                                           94,175.00
         Additional Features

* Automatic Email Confirmation to Student
   RTS Payment Gateway “Link” Version

• Overview
  – Works with VeriSign Payment solutions
  – Credit Card data is collected and processed
    on a secure server.
  – Real-Time
• Benefits
  – For small school looking for an easy
    Student Accounts payment module.
RTS Payment Gateway “Link”
          Example


 Step 1: Click on CC Link
RTS Payment Gateway “Link”
          Example


  Step 2: Enter Amount
RTS Payment Gateway “Link”
          Example


  Step 3: Verify Amount
RTS Payment Gateway
    “Link” Example

      Step 4:

  Enter Required
   Information
RTS Payment Gateway “Link”
          Example


Step 5: Confirm Transaction
RTS Payment Gateway “Link”
          Example


     Step 6: Return
          RTS Payment Gateway “Link”
                    Example


Step 6: 2nd Confirmation with New Acct Balance
RTS Payment Gateway “Link”
          Example
Student System Updated
      RTS Payment Gateway “Link”
                Example


* Automatic Email Confirmation to Student
RTS Payment Gateway “Link”
          Example


Confirmation Email Body….
  RTS Payment Gateway “Link”
             Example


Institution Email Confirmation …
                    RTS Payment Gateway “Link”
                                 Example


                             Reports ….

      Transaction Report: Daily Activity Summary
                                       for


                       Fri Mar 01, 2002
                       Sorted By: Transaction Time


                                                                ResultPage 1 of 1
  Transaction ID      Time      Type Tender Type    Amount

                   Mar 01, 2002
1. V63A10627461                 Sale   MasterCard   $900.00            0
                   10:09:22 AM
                   Mar 01, 2002
2. V64A10661067                 Sale         Visa   $750.00            0
                   08:15:30 PM
                   Mar 01, 2002
3. V54A09937586                 Sale   MasterCard   $110.00            0
                   09:00:37 PM
                   Mar 01, 2002
4. V54A09937614                 Sale         Visa   $5,000.00          0
                   09:01:54 PM
                   Mar 01, 2002
5. V54A09937698                 Sale   MasterCard   $5,050.00          0
                   09:06:11 PM
                   Mar 01, 2002
6. V53A09938000                 Sale   MasterCard   $6,069.00          0
                   09:17:52 PM
                   Mar 01, 2002
7. V63A10663264                 Sale   MasterCard   $7,500.00          0
                   09:50:45 PM
                               RTS Payment Gateway “Link”
                                                Example


                                           Reports ….

                                                                        Transaction Detail
This report provides information on a specific transaction.
V53A09938000
Request Data
Trans ID:        V53A09938000                          Login Name:      RTS
Timestamp:       2002-03-01 21:17:52                   Trans Type:      Sale
Duration:        0.00                                  Tender Type:     MasterCard
Client IP:       216.168.254.142                       Account Number: 5105XXXXXXXX5100
Client Version: 3.00                                   Expiration:      0302
AVS Street:      123 Univeristy Drive                  Amount:          $6,069.00
AVS Zip:         30339                                 Email:           Student@rts.edu
Comment1:                                              Comment2:


Results
Result Code:        0                                Response Message: Approved
Auth. Code:         204PNI                           Orig Trans ID:
AVS Street Match: N                                  Orig Amount:       $0.00
AVS Zip Match:      N                                Batch ID:
CIN Match:                                           CIN Result Code:
                                     RTS Payment Gateway “Link”
                                                         Example


                                                   Reports ….




28-Feb-2002                                   RTS University TEST                                            PAGE 1
WGRCPMT                                        Web CC Payments

Transaction Period:       28-Feb-02 to 01-Mar-02


ID              Name                       Code           Order No.             Invoice TransDate Amount
-------------   ------------------------- -------------- -------------------- ---------- ------------- --------------
566636441        Student, Sussie B.         WDCC           V63A10663264 2021               28-Feb-02        6,060.00
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
      “                   “                     “                   “               “           “                 “
-------------   ------------------------- -------------- -------------------- ---------- ------------- --------------
                                                                                                           94,175.00
       Secure and Reliable
• Security
  – All Transaction data is handle via SSL
  – Accepts Transaction ONLY from your web site.
  – Credit Card/Check Information is not stored in
    Student System
• Reliable
  - Handshake technology b/w broker and cc
    software.
                 Summary
• RTS Payment Gateways
  – Pro
  – Link


• Cost effective solution
Questions and Answers
     RTS Incorporated
     Oracle DBA Professionals

     Doug Cackett
     dcackett@rtsdba.com
     (404) 316-8375


For more information visit: www.rtsdba.com