CDR Tickets

Issue Number 4696
Summary Update ZIP code Table 2019Q4
Created 2019-11-01 14:26:25
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2019-11-05 13:48:38
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.251949
Description

Hello Louise,

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

   License (user name and password are case sensitive):

         http://data.zipinfo.com/datanov/z5max/z5max.htm

         User Name: ECQHYP

         Password:  JUABZQ

    This is the second 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

    Cust #: ARL208

Comment entered 2019-11-01 14:27:26 by Englisch, Volker (NIH/NCI) [C]

, the new ZIP code data has been loaded to DEV and QA.

Comment entered 2019-11-01 14:29:39 by Englisch, Volker (NIH/NCI) [C]

Release Notes, November 2019

IMPORTANT CHANGES - PLEASE READ THIS

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

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

The number of active ZIP codes remains 41,702

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

Added 09101 M APO, AE
Added 09401 M APO, AE
Added 09877 M APO, AE

Deleted 17583 P West Willow, PA
Deleted 54472 U Marshfield, WI

The number of active ZIP codes is 41,702

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

Added 09240 M APO, AE
Added 09242 M APO, AE

Deleted 09101 M APO, AE
Deleted 34044 M APO, AA

The number of active ZIP codes is 41,701.

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

Comment entered 2019-11-01 14:30:55 by Englisch, Volker (NIH/NCI) [C]

Total number of rows loaded: 70397

Elapsed time: 0:02:25.800515

Comment entered 2019-11-05 13:48:27 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Comment entered 2019-11-05 14:34:18 by Englisch, Volker (NIH/NCI) [C]

The ZIP codes have been loaded to STAGE and PROD.

Please verify on PROD and close this ticket.

Comment entered 2019-11-05 14:53:58 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Elapsed: 0:00:00.001621