We pull data from many different tables into a new behind-the-scenes table called a view. When a search is performed we look at everything in that view and return a result wherever we got a hit in any column or row in that table.  

The view selects data from the following files:
  • MASTER membership info (account base, DBA name, employee #*, last name, first name, middle initial, reference*, SSN, member type)
  • MSNONMBR non-member info (SSN/TIN, first name, last name, middle initial, member type) 

Then gets additional information from the following tables for records found in MASTER or MSNONMBR:
  • CCCTGDAT (last 4 of card #)
  • PANCARD (last 4 of card #)
  • MASTRL (driver’s license #)
  • OBMBRSECIN (online banking user ID)
  • OTBMST2, OTBMST3 and OTBMST4 (last four digits of OTB account/card #)
  • MASTPH (phone #)
  • PCMBRCFG (email address)
  • MASTER membership info (account base, DBA name, employee #*, last name, first name, middle initial, reference*, SSN, member type)
  • MSNONMBR non-member info (SSN/TIN, first name, last name, middle initial, member type)
  • SECNAMES secondary names (owner type then name from MASTER or MSNONMBR depending if joint owner is a member or not)
  • ADSL loan co-signers (additional signer type then name from MASTER or MSNONMBR depending if additional signer is a member or not)
  • IRABEN IRA beneficiaries (name from MASTER or MSNONMBR depending if beneficiary is a member or not)
*These are optional fields in the MASTER table, used by some credit unions. This data is entered via the final Update Membership Information screen via Tool #15.
 
Note: When searching via Xpress Teller, the system automatically hides any results it finds from the non-member database, since Xpress Teller does not support non-member teller services.