Runner Technologies Home
Banner Interface for CLEAN_Address()
 Top 10
 Key Benefits
 Features
 Reports
Banner® is a student information system for Oracle that supports institutions of all sizes and types as a tightly integrated suite of proven, scalable, enterprise-wide applications on a single database. Banner combines a premier administrative solution with portal, integration, information access, content management, and academic solutions.

Runner Technologies has certified their CLEAN_Address()™ address verification solution to work with Banner®, providing both real-time and batch address verification and telephone checking seamlessly integrated within Banner Forms, Internet Native Banner (INB), and Web self-service applications.

SunGard and Banner are trademarks or registered trademarks of SunGard Data Systems Inc. or its subsidiaries. Runner Technologies, CLEAN_Address, and CLEAN_Address() are trademarks or registered trademarks of Runner Technologies, Inc.

 Downloads:
· Address Verification in Banner Presentation PDF format
· CLEAN_Address_for_Banner_Architecture PDF format
· CLEAN_Address Banner Brochure PDF format
· Watch the Banner Forms video (2 min) Windows Media format
 Links:
· FREE Evaluation Version
· Request a Proposal
· User Group
· FAQs
Top 10 Reasons why CLEAN_Address is the best address solution for Higher Education:
 1) No client software to install
 2) Truly seamless real-time integration with no popup windows
 3) Integrated batch processing in the database without exporting / importing
 4) Customizable business rules and data standards down to address type level
 5) Address errors are recorded in the database for easy reporting
 6) Telephone number checking in real-time and batch
 7) Enterprise Service Oriented Architecture (SOA) - one installation serves all databases
 8) Complete solution for all entry points: Banner INB, Web self-service, and batch processing
 9) Low annual subscription pricing for the entire institution (Prospect to Alumni + HR and Finance)
 10) Support for every country in the world with Web service option
Key Benefits
 Banner Real-time Address Verification

CLEAN_Address supports a seamless real-time interface for address verification within Banner. This pre-developed solution saves you integration time and money, and insures that the initial price of the subscription covers the "last mile" of integration work. This is a true plug-and-play integrated solution for Banner, whether using the client-server Banner Forms, INB, or the web self-service modules. The integration from the Banner user interface is 100% seamless, requiring no additional popup screens or additional steps to learn. No additional training is required for end users, either.
 Banner Batch Address Verification

CLEAN_Address provides batch interfaces for ten Banner address tables, covering admissions, prospects, student, HR, alumni, finance, financial aid, and several others. Batch updates are integrated within the database, so the Banner address tables do not need to be exported and reloaded. This keeps the address data securely in place within the database. Several reports are provided for identifying duplicate addresses and reporting on address errors in summary and detail.
 DPV™ Product Option

Provides the most accurate level of address verification available, down to the house number and suite/apartment level (Delivery Point Validation). This will indicate if an address is missing an apartment number or if the one specified is out of range. This also includes the LACSLink™ data option for converting the older Rural Route/Box addresses to the new physical address for easier access by emergency personnel.

 Banner ZIP Code™ and County updates

CLEAN_Address contains an automatic seamless method for updating the Banner ZIP Code™ (GTVZIPC) and County (STVCNTY) tables. This keeps these tables up-to-date bimonthly at no additional cost and no additional data subscriptions. The update process is seamless and no manual intervention is required when you get bimonthly data updates for CLEAN_Address.
 Banner Telephone Verification

Updates the Banner telephone table (SPRTELE) in real-time and batch mode to provide cross-data validation between the telephone and address, area code splits, area code mismatches, invalid prefixes, and distance from the telephone wire center to the address.
 Enterprise Architecture

The CLEAN_Address server is scalable and can support seamless fail over, redundancy, and load balancing for Oracle databases.
 Centralized Architecture

The CLEAN_Address Service Oriented Architecture (SOA) can support multiple databases from a single installation. This centralized approach makes the bimonthly update very easy to apply, and can support a development, test, and production Oracle instance from one CLEAN_Address server, whether running Banner or any other Oracle application. Some institutions may have different solutions for Finance and HR (such as Oracle Applications and PeopleSoft), and CLEAN_Address will work seamlessly with any application that accesses Oracle.
 Postal Rate Discounts

The Mailers+4 software option provides a PAVE Gold certified solution for getting the best postage rate discounts based on a list you are processing for mailing. This is a standalone solution which works with address lists. After processing an address list through Mailers+4, the addresses are CASS certified and PAVE Gold sorted for the best postal rate discount.
Features
Runner Technologies has certified the batch program for CLEAN_Address to work with the Banner address and telephone tables.

Reports are provided to show before/after versions of the address so you can see what was changed after address verification (See Reports below).

Pre and Post verification user exits for Address Verification and Telephone Checking in real-time and batch modes
Complete customization of the address standards and any other business rule your institution may have. This is done through a separate package "CLEAN_Address_Banner_UE" (UE for User Exit). Here you can change several parameters which affect formatting and CASS™ standards, as well as add Pre and Post verification custom processing.

The user exits allow you to set standards on the fly, bypass address verification completely based on certain address types (i.e. campus addresses not in USPS®), and correct specific exceptions that your users typically enter.
Address Verification Features
 Updates the Banner address tables directly without exporting any data. Ten address tables are currently supported.
 Works with 3 address lines
 Identifies and updates Banner County Code based on state and county name
 Includes Suite/Apt on the same line as the street address if there is room (<= 30 characters)
 Appends Delivery Point, Check Digit, Carrier Route to address
 Adds address error code and verified date to address (reviewed_ind, reviewed_user)
 Uses USPS® city abbreviation if city name is over 20 characters
 Supports the DPV™ Product option
   - identifies missing/invalid suites and apartments or invalid house numbers
 Requires no table modifications to the Banner schema
 Configurable Address Verification parameters and Get/Set procedures.
   These can be easily set and modified in the User Exit package, even by address type
   - Use_ZIP_Plus4
   => defaults TRUE to always use ZIP + 4® concatenated to the 5 digit ZIP Code™
   => set to FALSE to only use the 5 digit ZIP Code™ in SPRADDR
   - Expand_Street_Suffix
   => defaults to FALSE to use standard CASS™ street suffix abbreviation
   => set to TRUE to show the full street suffix in an address (i.e.. "Avenue" instead of "Ave")
   - Suite_Apt_Before_Street
   => defaults FALSE to put the suite / apartment line after the address line if the apartment
         can not be appended to the address
   => set to TRUE to put the apartment line before the address if it can not be appended to
         the address
   - Append_Suite_To_Street
   => defaults TRUE to always try to append the apartment to the address line
   => set to FALSE to keep suite / apartment on a separate line always
 Batch Address Verification parameter: Batch_Update_Existing
   - This determines if the Batch Address Verification should update existing SPRADDR records, or
      inactivate and create a new address record
 Replaces "#" with "Apt" in address lines to prevent errors in downstream print applications
Telephone Verification Features
 Updates the Banner telephone table (SPRTELE) directly without exporting any data
 Identifies invalid telephone numbers using area code and prefix
 Returns a telephone error code indicating the problem with the telephone number
 Returns the Distance (in miles) from the telephone number to the address
 Returns the suggested new area code based on the ZIP Code™ and telephone prefix
 Identifies and updates area codes based on area code splits
 Adds missing area codes based on the ZIP Code™
 Requires no table modifications to the Banner schema
 Configurable parameter in User Exit to set your own threshold for alerting telephone errors
   (default 100 miles)
 Forms integration guide include Telephone number checking copy-paste code and steps
   - Optionally pass Address Type into Address Verify API to drive custom business rules
Reports
Several SQL reports are supplied and best run from a SQL tool like "PL/SQL Developer" or "Toad".
 
Report Description
 identify_duplicate_addresses.sql   Shows duplicate records after a batch verification has standardized all records
 compare_record_changes.sql Compare the OLD and NEW records after a batch address verification
 address_error_summary.sql Show a summary of all address errors after batch or real-time verification
 address_error_detail.sql Show the detail of all addresses with deliverability errors after batch or real-time verification
 batch_verify_address.sql Shows how to call the batch verification procedure with all available parameters
 telephone_verify_detail.sql Show the detail of all telephones in the SPRTELE table after a batch verification
 telephone_error_detail.sql Show the detail of all telephones with errors in the SPRTELE table after a batch verification
 batch_verify_telephone.sql Shows how to call the batch telephone verification procedure with all available parameters
·

Pricing: Our all-inclusive subscription pricing includes all technical support and maintenance for the term of the subscription, including the bimonthly data updates as well as the Banner integration code and support. We have a tiered pricing model based on student FTE headcount and product options. Please contact us for a simple proposal based on your needs. We have eliminated all red tape, requiring no formal software licensing agreement.
·

Support: Runner Technologies fully supports all of the products, demo code, and integration code we provide. This gives you a single point of contact for all address verification support questions. We pride ourselves on our level and quality of technical support, and we will go to all lengths to make sure our customers are delighted with our support and the solutions we recommend. We are committed to supporting CLEAN_Address for all current and future versions of the Banner software completely at our cost.

·  For additional information please contact our Account Representatives:
   Toll Free: 877-784-0003
   Phone: 561-395-9322
   Email: sales@runnertechnologies.com
   Online: Contact us
 CLEAN_Address 3.5
 SurveyDIG 2.0
 SalesOE 2.0
 MentorPRO 2.0
 Orbit Track 5.0
 Orbit 5.1

"CLEAN_Address() integrated into our Oracle application in a seamless manner to both users and developers" - Oracle Developer

"Address verification in our student information system is a ten-year dream come true." - Community College

"This low-maintenance application has already saved us tens-of-thousands of dollars each year" - Distribution Facility

"We have seen significant savings in increased customer satisfaction and enabling quick and easy address entry by call center representatives" - IT Manager, Unicity Network

"CLEAN_Address() is saving us over $250,000 per year in address correction charges from UPS." - Book Publisher

"The address verification runs very smoothly. It has taken quite a load off the records and registration process" - State University
Copyright © 1997-2005 Runner Technologies, Inc. All rights reserved.