Postal Codes Tables Filter Dialog Box

This dialog box appears when you select the Postal Codes database table for an organization in the Administration Explorer tree view. Use the dialog box to filter the rows in the Postal Codes table before the table is opened.

Important:
Unfiltered, the Postal Codes table takes some time to load because at implementation it may contain all the U.S. Postal Service Zip codes and/or Canadian postal codes—over 850,000 entries.

To set the filters you want to apply to the Postal Codes table:

• Country - Select the country’s checkbox to include the country’s postal codes, or clear the checkbox to exclude them. At least one country must be selected. The default selection is based on the Default Country setting in the system record.
• States/Provinces - States or provinces or listed depending on the selected country. Select All to include the entire list, or select individual states or provinces.
• County, city, postal code - These free-text fields are case-insensitive. You can use the asterisk wild-card character * at the beginning or end of the text string. You can also use the pound sign #, which stands for one character only, at any point in the text string.

Counts at the top of the filter dialog box show how many postal codes will be loaded with the filters you have set. When you change the filter criteria, you can click the refresh button  to see the new counts. When you are ready to load the Postal Codes table, click Apply Filter. See Setting System Postal Codes.