|Assigned Zip Codes by Region|
ASSIGNED ZIP CODE LISTS BY REGION
FREQUENTLY ASKED QUESTIONS
When a new Member is entered into the database or an 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.
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 (firstname.lastname@example.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.
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 misspelled or 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.
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 (email@example.com).