Data Layout#

Introduction#

The ZIP+4 files enable businesses with computer capabilities to add ZIP+4 Codes to their mailing list address files. The files contain approximately 45 million records in total.

The files are sorted according to the EBCDIC collating sequence in ascending order, on the data fields, ZIP CODE and UPDATE KEY NO.

List of Files#

Fixed length (ASCII)
CSV

Layout and Definitions#

ZIP+4 (zip4) and ZIP+4 Transaction (z4trans)#

Column Name

Type

Definition

Copyright Detail Code

char(1)

The Copyright Detail Code identifies the type of record in a USPS® product file.

ZIP Code

char(5)

5-digit ZIP code

Update Key Number

char(10)

The “Update Key Number” field uniquely identifies this record and can be used to replace the current zip+4 record

Action Code

char(5)

The zip4 folder contains the base files, which will always contain “A”

The zip4trans folder will contain “A” to add record to file, or “D” to delete base master record.

Record Type Code

char(1)

Record Type Code

Carrier Route ID

char (4)

Carrier Route

Street Pre-direction Abbreviation

char(2)

Street Pre-Directional Abbreviation.

N, S, E, W, NE, NW, SE, SW

Street Name

char(28)

Street Name

Street Suffix Abbreviation

char(4)

Street suffix Abbreviation.

ST, RD, DR, LN, etc.

Street Post-direction Abbreviation

char(2)

N, S, E, W, NE, NW, SE, SW

Primary Address Low number

char(10)

Low-end address in address range

Primary Address-High number

char(10)

High-end address in address range

Primary Address-Odd/Even/Both Code

char(1)

Address Primary Odd/Even/Both Code.

Building/Firm Name

char(40)

Primarily firm or high-rise name

Secondary Address Abbreviation

char(4)

Secondary Address Abbreviation.

APT, STE, BLDG, etc.

Secondary Address-Low Number

char(8)

Secondary Address - Low Number

Only record types F, H

Apartment or Suite Number or Low end of range.

Secondary Address-High Number

char(8)

Secondary Address - High Number

Only record types F, H

Apartment or Suite Number or High end of range.

Secondary Address-Odd/Even/Both Code

char(1)

Address Secondary Odd/Even/Both Code Only record types F, H

Plus4-Low Number-Zip Sector Number

char(2)

ZIP Sector Number - first two digits of the Plus4

Plus4-Low Number-ZIP Segment Number

char(2)

ZIP Segment Number - last two digits of the Plus4

Plus4-High Number-Zip Sector Number

char(2)

ZIP Sector Number - first two digits of the Plus4

Plus4-High Number-ZIP Segment Number

char(2)

ZIP Segment Number - last two digits of the Plus4

Base Alternate Code

char(1)

Base Alternate Code

LACS Status Indicator

char(1)

LACS Status Indicator

Government Building Indicator

char(1)

Government Building Indicator

Finance Number

char(6)

Postal Facility Finance Code

State Abbreviation

char(2)

State Abbreviation. (Example: CA, NY, etc.)

County FIPS Code

char(3)

Federal Information Processing Standard code

Congressional District Number

char(2)

Congressional District number

Urbanization City State Key

char(6)

Urbanization City State Key that is an index to the City State File. (citystate.txt)

Preferred Last Line City State Key

char(6)

Preferred Last Line City State Key is the preferred city name record in the city-state file

Code and Definitions#

ZIP+4 (zip4) and ZIP+4 Transaction (z4trans)#

Column Name

Code

Definition

Copyright Detail Code

D

Detail record

Action Code

A

Add record to file

D

Delete record from base file

Record Type Code

G

General Delivery

H

High-rise

F

Firm

S

Street

P

PO Box

R

Rural Route/ Contract

Record Type Code

B###

PO Box

H###

Contract

R###

Rural Route

C###

City Delivery

G###

General Delivery

Primary Address - Odd/Even/Both code

O

Odd

E

Even

B

Both

Base Alternate Code

B

Base Record

A

Alternate Record

LACS Status Indicator

L

LACS Converted

Blank

Not Applicable

Government Building Indicator

A

City Government Building

B

Federal Government Building

C

State Government Building

D

Firm Only

E

City Government Building and Firm Only

F

Federal Government Building

G

State Government Building and Firm Only