Untitled Document

GWRRA Recent News | Insurance Information | Officer Handbook

Officer Resources | Wing Ding News | Zip Codes

Assigned Zip Codes by Region

ASSIGNED ZIP CODE LISTS BY REGION

Region	Date Updated	Region	Date Updated	Helpful LInks	Description
Reg A_ZIPS	7/21/10	Reg I ZIPS	7/21/10	United States Postal Service	Find zip/postal codes, check addresses, check city names,etc.
Reg B ZIPS	7/21/10	Reg J ZIPS	7/21/10	Canada Post
Reg D ZIPS	7/21/10	Reg K ZIPS	7/21/10	Free US Zip Code Maps	Maps may be out of date, reference the USPS website.
Reg E ZIPS	7/21/10	Reg L ZIPS	7/21/10	Free US Zip Code Maps	Maps may be out of date, reference the USPS website.
Reg F ZIPS	7/21/10	Reg N ZIPS	3/1/10
Reg H ZIPS	5/6/09			Send additional links or comments.

FREQUENTLY ASKED QUESTIONS

What is the Assigned Zip Report?
How do I submit Assigned Zip Report updates?
What is the Unassigned Zip Report?
How do I submit Unassigned Zip Report updates?

What is the Assigned Zip Report?

When a new Member is entered into the database or existing Member updates their address zip code field, this triggers the database to update the Member's Chapter field. The database compares the Member's zip code to an internal reference table and auto fills the Member's Chapter field according to the Chapter assigned to that zip code. This internal reference table, more commonly known as the Assigned Zip Report, associates a unique zip code (or State) to a Chapter.

This report, see ASSIGNED ZIP REPORT example below, is useful when Chapters are opened or closed.

Assigned Zip Report Example

How do I submit Assigned Zip Report updates?

If there are only a few updates, you may send your updates in the body of your email. Be sure to include the Current Chapter, Zip and New Chapter. For a large number of updates, submit the updated file in an email and be sure to eliminate any unecessary zip codes to keep the file size small. Send your updates to your District Director or designated individual. Compiled updates should then be submitted, by month end to be reflected in the following month's Area Report run, to the Home Office (dshaw@gwrra.org).

Assigned Zip Report updates will be posted around the 10th of the month. When a new file is posted, disregard any previous versions. Compare the Date Posted date to cell B2 within your file, to ensure you have the most recent version.

What is the Unassigned Zip Report ?

When a new or prospective Member joins GWRRA, occasionally their zip code is not associated with a Chapter. Each month all the unassigned (UA) zip codes for each Region are compiled and distributed to the Region Directors as the UNASSIGNED ZIP REPORT, see example below. Ideally a zip code should be assigned to the nearest Chapter, either by the Chapter Director or District Director.

If a City Name is mispelled or is incorrect, please note that Member Services enters Member information into the database as printed on the Member's submitted application. A zip code that is listed on the Assigned Zip Code may be listed again under the Unassigned Zip Code list usually because of a hidden character in the Member's zip code field. Submit these errors when submitting your updates.

How do I submit Unassigned Zip Report updates?

To assign a UA zip code, enter the designated Chapter name under the New Chapter column, next to corresponding UA zip. Any future Members in that zip code will automatically be assigned to the designated Chapter. Occasionally there will be issues that arise, such as zip code assignments crossing State lines and/or Region boundaries. It will be up to the District and/or Designated person on how to handle their reporting.

If there are only a few updates, send the Zip and New Chapter updates in the body of your email. For a large number of updates, submit the updated file in an email. To keep the file size small be sure to eliminate any unecessary items, like any additional excel sheets or zip codes . Send your updates to your District Director or designated individual. Compiled updates should then be submitted, by month end to be reflected in the following month's Area Report run, to the Home Office (dshaw@gwrra.org).