CDR Tickets

Issue Number 3758
Summary Update ZIP code Table 2014Q2
Created 2014-05-01 10:45:32
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2014-05-01 18:15:20
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.124236
Description

---Original Message---
From: sabine@zipinfo.com sabine@zipinfo.com
Sent: Wednesday, April 30, 2014 10:25 PM
To: Patten, Louise (NIH/NCI) [E]; NCI OCE Admin Services; Englisch, Volker (NIH/NCI) [C]; Zavala, Iris (NIH/NCI) [C]
Subject: ZIPList5 Max May 2014

Hi Louise,

Here is the download info for ZIPList5 Max May 2014, Enterprise License (user name and password are case sensitive):

http://data.zip-info.com/datamay/z5max/z5max.htm
User Name: DGLKNC
Password: DSTXFV

This is the last version (of four) of your 1-year subscription. We will email you a renewal invoice soon.

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 2014-05-01 18:14:11 by Englisch, Volker (NIH/NCI) [C]

Release Notes, May 2014

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

=====================================================================

For May 2014 the US Postal Service added four new 5-digit ZIP codes, deleted
one existing 5-digit ZIP code, and renamed two 5-digit ZIP codes.

Added 58803 P Williston, ND
Added 96631 M FPO, AP
Added 97003 Beaverton, OR
Added 97078 Beaverton, OR

Deleted 09301 M DPO, AE

Renamed 96542 from APO to FPO, AP
Renamed 96543 from APO to FPO, AP

The number of active ZIP codes is 41,755

=====================================================================

For April 2014 the US Postal Service added one new 5-digit ZIP codes, deleted
no existing 5-digit ZIP code, and renamed one 5-digit ZIP code.

Added 34094 M FPO, AA

Renamed 41021 from Erlanger to Hebron KY

The number of active ZIP codes is 41,752

=====================================================================

For March 2014 the US Postal Service added two new 5-digit ZIP codes, deleted
four existing 5-digit ZIP codes, and renamed one 5-digit ZIP code.

Added 09712 M FPO, AE
Added 09861 M APO, AE

Deleted 09102 M APO, AE
Deleted 09866 M APO, AE
Deleted 92326 P Crest Park, CA
Deleted 95887 Sacramento, CA

Renamed 09841 from APO to FPO AE

The number of active ZIP codes is 41,751

=====================================================================

Comment entered 2014-05-01 18:15:01 by Englisch, Volker (NIH/NCI) [C]

The new ZIP data has been loaded on DEV and William can go ahead and review.

Comment entered 2014-05-22 10:29:56 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV.

Comment entered 2014-06-02 18:12:40 by Englisch, Volker (NIH/NCI) [C]

I'm currently unable to load the data to the QA server. The account password has changed.

Comment entered 2014-06-03 18:15:45 by Englisch, Volker (NIH/NCI) [C]

The ZIP codes have been loaded to QA. This is ready for review.

Comment entered 2014-06-04 12:38:04 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA.

Comment entered 2014-06-12 19:56:51 by Englisch, Volker (NIH/NCI) [C]

I've submitted tickets to the DB and Web teams to have the ZIP code data backed up and loaded.

Comment entered 2014-06-13 16:06:22 by Englisch, Volker (NIH/NCI) [C]

The data has been updated on PROD. Please verify and close this ticket.

Comment entered 2014-07-22 14:28:33 by Englisch, Volker (NIH/NCI) [C]

William, you can go ahead and close this ticket after you confirmed the updates on PROD.

Comment entered 2014-07-23 22:34:06 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thank you!

Elapsed: 0:00:00.001342