Inquiry: Advanced Search

Screen ID: IMSTTB-02
Screen Title: Advanced Search
Panel ID: 7167
Tool Number: n/a
    Click here to magnify

Access this screen by selecting Advanced Search on the Inquiry Search screen.

Helpful Resources

Explain how the new search engine works when it comes to searching for a member name.

How can you tell in which field a number was found in when using Xpress Teller Search and Inquiry Search?

Why might I not find a joint owner or coborrower record in the Search results on Xpress Teller Search or Inquiry Search?

How will the new search work when it comes to hyphenated names, or names that end with something like Jr., Sr., II, and III?

How is the data gathered for the new search engine that's used by Member Inquiry and Xpress Teller?

Screen Overview

This powerful Advanced Search also allows you to search only certain fields by checking them.  This will limit your search to these criteria.  

Enter your data in the Search for field and check the fields in which you would like to search for that data. Click Search to return to the Inquiry screen to see the members (and their secondary members, if applicable) that fit the results of your search.

If you are not narrowing your results enough, a good strategy is to only search one field, and if possible to search more specific data. Click the Check All and Uncheck All buttons to check or uncheck all of the selections.

Tables Used for Advanced Search

Advanced Search allows you to search the following:

  • Account # -  Searches the MASTER table (member records)

  • SSN/TIN - Searches the MASTER and MSNONMBR tables (member and non member records)

  • OTB account # - Searches the OTBMSTx tables (off trial balance tables)

  • First name - Searches the MASTER and MSNONMBR table (member and non member records)

  • Driver's licence - Searches the MASTRL and MSNONMBR tables (member and non member records)

  • ATM/Debit/Credit card #

  • Email address - Searches the PCMBRCFG table.

  • Last name - Searches the MASTER and MSNONMBR table (member and non member records)

  • Phone # (all phone numbers are used)

  • DBA name - Searches the MASTER and MSNONMBR tables (member and non member records)

  • Employee number - Searches the MASTRL table (member records)

  • Online banking user name.  Searches the USERNAME field in the Online Banking Security Views (MBROBSECQ or MBROBSDEMQ)

  • Reference - Searches the MASTER table (member records)