CDR Tickets

Issue Number 4644
Summary Update ZIP code Table 2019Q3
Created 2019-08-01 11:29:40
Issue Type Task
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2019-08-01 11:31:23
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.247852
Description

On 7/31/19, 18:22, "sabine@zipinfo.com" <sabine@zipinfo.com> wrote:

    Hello Louise,

    Here is the download info for ZIPList5 Max August 2019, Enterprise

    License (user name and password are case sensitive):

         http://data.zip-info.com/dataaug/z5max/z5max.htm

         User Name: AFGARG

         Password:  NGRXPL

    This is the first version (of four) of your 1-year subscription.

    If you have any questions please let me know.

    We appreciate your business!

    Best regards,

    Sabine Chamberlain

    ZipInfo.com

    866-256-2042

Comment entered 2019-08-01 11:31:15 by Englisch, Volker (NIH/NCI) [C]

The data has been downloaded and imported into DEV and QA.

Please review the new data.

Comment entered 2019-08-01 11:57:56 by Englisch, Volker (NIH/NCI) [C]

Release Notes, August 2019

IMPORTANT CHANGES - PLEASE READ THIS

The USPS removed the three-digit ZIP code 889 from its active ZIP
code list. ZIP codes 88901 and 88905 still exist in the CtyState file
but these ZIP codes have no assigned ZIP+4 address records.

Here is the list of ZIP codes that the US Postal Service has recently added,
deleted, or renamed:

=====================================================================
For August 2019 the US Postal Service added one new ZIP code, deleted one
existing 5-digit ZIP code, and renamed no 5-digit ZIP code.

Added 96311 M FPO, AP
Deleted 97313 U Salem, OR

The number of active ZIP codes is 41,701.

=====================================================================
For July 2019 the US Postal Service added two new ZIP codes, deleted no
existing 5-digit ZIP code, and renamed no 5-digit ZIP code.

Added 09277 M DPO, AE
Added 09456 M APO, AE

The number of active ZIP codes is 41,701.

=====================================================================
For June 2019 the US Postal Service added five new ZIP codes, deleted two
existing 5-digit ZIP codes, and renamed one 5-digit ZIP code.

Added 09241 M FPO, AE
Added 09266 M FPO, AE
Added 11437 U Jamaica, NY
Added 34044 M APO, AA
Added 72405 Jonesboro, AR

Deleted 09641 M FPO, AE
Deleted 09665 M FPO, AE

Renamed 96538 from FPO to APO AP

The number of active ZIP codes is 41,699.

=====================================================================
#

Comment entered 2019-09-12 14:47:41 by Englisch, Volker (NIH/NCI) [C]

Adding as a watcher.

If the ZIP code data looks OK on the lower tiers we can load it to STAGE and PROD.

Comment entered 2019-09-12 16:25:10 by Osei-Poku, William (NIH/NCI) [C]

I am testing on QA and it looks like the Additions are not working as they should. They are coming up with validation error messages while the deletions are good.

Comment entered 2019-09-12 16:43:19 by Englisch, Volker (NIH/NCI) [C]

Oh, I bet the data needs to be reloaded due to the database refresh we did recently.

Comment entered 2019-09-12 17:40:46 by Englisch, Volker (NIH/NCI) [C]

The ZIP codes have been reloaded on DEV, QA, and STAGE.

Comment entered 2019-09-19 12:49:43 by Osei-Poku, William (NIH/NCI) [C]

Verified on STAGE. Thanks!

Comment entered 2019-09-19 13:16:42 by Englisch, Volker (NIH/NCI) [C]

The ZIP code data has been loaded to PROD.

Please verify and close this ticket.

Comment entered 2019-10-10 11:55:02 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Elapsed: 0:00:00.001946