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 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)