SETA Southeast Regional Conference RTS Payment Gateway by iht11609

VIEWS: 0 PAGES: 49

									        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

								
To top