Search Database

The Search Database feature provides you with several methods by which to search your database. Basically, each of the categorical screens (accessed by the labeled icons in the white part of the screen) operates in the same manner.

Payments Search

NOTE: YOU MAY SEARCH A PAYMENT CODE FROM THE NAME LOCATION SEARCH SCREEN OR FROM THE PAYMENTS SEARCH SCREEN IN THE SAME WAY. SIMPLY ENTER THE PAYMENT CODE IN THE SEARCH BOX PROVIDED.

 
 

When using the National Routing Code box, you may choose the country from the drop down menu to target your search. If you are unsure of the type of routing code, choose the type "Any Payment Code" from the drop down menu. You will get matches from all of the ACTIVE National Routing Codes, including SWIFT/BIC and CHIPS UID and even some routing codes that are not in the drop down menu. These extra codes have been submitted by banks in countries that we do not have complete country coverage, so they are not listed in our drop down menu. When you know only part of a routing code or just a few numbers, you can search for it using 'wildcard' characters as placeholders.

? is used as a specific placeholder for an unknown digit

* is used as a replacement for a string of unknown digits

For example: Let's say you know only four digits of a code. You could search several different ways:

  1. Enter 0842 in the routing code field, then click on Search. You retrieve active routing codes that begin with the numbers you were able to enter.
    You would retrieve: 0842 0292 9, 0842 0312 9, 0842 0352 9, etc.
  2. If you entered *0842 in the routing code field, you would get active codes that end in 0842.
    You would retrieve: 000300842, 000400842, 020842, etc.
  3. If you entered *0842* in the routing code field, you would get:
    000308429, 00308421, 084201058 PLUS over 700 other active routing number matches
  4. If you entered ???0842? in the routing code field, you would retrieve ONLY active 8 digit codes with 0842 as the fourth, fifth, sixth and seventh digits:
    00308420, 00308421, 20408420

If there are no active routing codes matching your search criteria, inactive payment code files will be searched to see if there are any matches. If there is an inactive payment code that matches the search criteria you will see a link to view the search results list of inactive codes. Click on the code for information regarding the institution previously associated with this code.

If you have a preferred National Routing Code, you may set this code to be your default by going to My Account/Preferences, Preferences, and choosing the appropriate code from the Drop Down Menu.

If you have the Payments Module and would like to see specific help tips on how to do a Routing Code Search, click here.