US Addressing return codes

 

Depending on your product you will get back these codes with some slight variations, below listings are primarily focused on mSQL addressing, with notes of variations from other products, which primarily is just the column name in most cases.

This section describes the following return codes:

A) AddrScore
B) ErrorCode
C) DPV
D) DPVNotes
E) PafFlag and PafDesc and UpdateFlag

 

A) AddrScore

mSQL - this is the value returned in addrscore when running generatecorrectedaddresses or generatencoaaddresses its returned in ncoaResult

matchIT Web - this is the value returned when calling the confirmAddressXML if it fails CASS validation

 

-1 An Error occurred when processing the address.
0 Address was successfully verified.  *this can depend on your product being used, see below
1 Address is coded but undeliverable (i.e. on side of street known to contain no houses).
2 The zip code was not found and the city and state cannot be used to determine a geographical area to search.
3 Coding would result in changing both the zip and city.
4  The best match would result in too many suspicious changes.
5  The street was identified as an alias, but was out of the range restricted for that alias.
6  No street address was given.
7 There are no street name matches in the given zip code or in any geographically-related zip code.
8  The street may contain superfluous components which cannot be discarded with confidence.
9

The house number could not be matched.

10  The best match was made to a zip move record but was not an exact match.
11  A zip move match was made, but no exact match could be found in the new zip.
12  Insufficient address information. It’s not even possible to guess as to what might be correct.
13  There are multiple matches with the same degree of confidence.
14  Incorrect suffix, directional, street name or unit resulted in multiple matches with the same degree of confidence.
15  Incorrect zip, city or urbanization resulted in multiple matches with the same degree of confidence.
16 A Corrected field was too long to fit into the supplied field.
17 Media Error. The database could not be read because of a hardware or system problem.
18 Process Fault. Processing was interrupted due to serious  program error. Please contact technical support with the record in question so we can investigate further.
19 DPV No Match. The address was found in the Zip+4 data, but not matched in the DPV reference

 

* matchIT Web -Code 0 will not be returned in matchIT Web if it is valid, instead the corrected information will be returned and it can be assumed the return code is 0, if it fails validation then you should carry through your original information from the input data fields 

*in mdesktop this is returned in the 'errorcode' column and will be blank instead of 0

 

 

B) ErrorCode

An ErrorCode field will be created containing correction code information as follows:

for NCOA in mSQL this is the ncoaCorrections

In mDesktop, this is in the Corrcode column

ErrorCode

Description

A

Normal street match.

B

PO Box match

C

Route type match

D

Unique Zip match

E

Small town match

F

Alias match.

G

Highrise alternate match.

H

Firm match.

I

Highrise match.

J

Highrise default match.

K

Route default match.

L

Street name corrected.

M

Street Suffix corrected.

N

Pre-directional corrected.

O

Post-directional corrected.

P

City corrected.

Q

State corrected.

R

Zip corrected.

S

Urbanization corrected.

T

Zip+4 corrected.

U

House number corrected.

V

Unit number corrected.

W

Secondary unit designator corrected.

X

Firm corrected.

Y

Street swapped with firm.

Z

Street swapped with alternate.

0

Dual address changed to PO Box.

1

Dual address street match.

2

Input city is not preferred but is acceptable.

3

Street standardized.

4

Unit not verified.

5

Leftovers found.

6

Zip move match.

7

LACSLINK match.

8

SuiteLink Match.

C) DPV

The DPV field is 6 characters wide; it enhances data by adding the Delivery Point Validation information generated by the US addressing module. The placement of the character code indicates which process was performed. The meanings of the five character positions are summarized in the following table.

DPV character

Position

Description

DPV Confirmation Indicator

1

The DPV Confirmation Indicator is the primary method used by the USPS to determine whether an address was considered deliverable or undeliverable.

Blank - Address was not assigned a Zip+4 and therefore no DPV processing was performed.

Y - Address was DPV confirmed for both primary and (if present) secondary numbers.

D - Address was DPV confirmed for primary number only, and Secondary number information was missing.

S - Address was DPV confirmed for primary number only and secondary number information was present but unconfirmed.

N - Both Primary and (if present) Secondary number information failed to DPV Confirm. (These are non-deliverable records)
*This is replaced by code 19 in the addrscore depending on whether you disable code 19, In previous versions, the returns were ambiguous, as the error code would be zero but the DPV result would indicate a match failure. Error Code 19 is a result of removing the ambiguity.

DPV CMRA Indicator

2

CMRA (Commercial Mail Receiving Agency) Indicates a private business that acts as a mail-receiving agent for specific clients.

Blank - Address was not assigned a Zip+4 and therefore no DPV processing was performed.

Y - Address was found in CMRA table.

N - Address was not found in CMRA table

DPV False Positive Indicator

3

The False Positive table flags the False Positive addresses.  This is a flag to determine whether a mailing list is being generated or created during validation.  Creating a mailing list through DPV certification is not allowed by the USPS.

Blank - Address was not assigned a Zip+4 and therefore no DPV processing was performed.

Y - Address was found in False Positive table.

N - Address was not found in False Positive table.

Vacant Indicator

4

A delivery point was active in the past, but is currently vacant (in most cases, unoccupied over 90 days) and not receiving delivery.

Blank - Address was not assigned a Zip+4 and therefore no DPV processing was performed.

Y - Address was found in the VACANT table.

N - Address was not found in the VACANT table

DSF2 No Stats Indicator

5

Indicates the address is not receiving delivery, and the address is not counted as a possible delivery. These addresses are not receiving delivery because A) delivery has not been established; B) customer receives mail as a part of a drop; or C) the address is no longer a possible delivery because the carrier destroys or returns all of the mail.

Blank - Address was not assigned a Zip+4 and therefore no DPV processing was performed.

Y - Address was found in NOSTATS table.

N - Address was not found in NOSTATS table

PBSA Indicator - P.O. Box Street-Style Address (New)

 6

Y = Address is actually a PO Box physical address

N = Address was not found in PBSA table.

Blank = Address not presented to hash table.

 

D) DPVNotes

The DPVNotes field can contain any combination of the following codes.

USPS Standardized Footnotes Reporting CASS Zip+4 Certification

  • AA – Input address matched to the ZIP+4 file.
  • A1 – Input address not matched to the ZIP+4 file.

 

Footnotes Reporting DPV Validation Observations

  • BB – Matched to DPV (all components).
  • CC – Primary number matched to DPV, but secondary number not matched (present but invalid).
  • F1– Input Address Matched to a Military Address.
  • G1– Input Address Matched to a General Delivery Address.
  • N1 – Primary number matched to DPV, but high-rise address missing secondary number.
  • M1 – Primary number missing.
  • M3 – Non-postal Primary number invalid.
  • P1 – Input Address RR or HC Box number Missing.
  • P3 – Input Address PO, RR, or HC Box number Invalid.
  • U1– Input Address Matched to a Unique ZIP Code.

 

Footnotes Reporting CMRA Observation

A commercial mail-receiving agency (CMRA) is a private business that acts as the mail receiving agent for specific clients by providing a delivery address and other services. If the address matches to a CMRA location one of the following footnotes will appear.

  • RR – Matched to CMRA.
  • R1 – Matched to CMRA but Secondary Number not Present.

 

 

E) PafFlag and PafDesc and UpdateFlag (mSQL only)

The PafFlag and PafDesc fields indicate whether a record has been verified or not during the addressing process:

PafFlag

PafDesc

Description

1

Verified

The record received an AddrScore of 0.

2

Good

The record achieved an AddrScore of 1.

3

Partial

The record achieved an AddrScore of 5, 8 or 9.

4

NoMatch

The record did not receive an AddrScore of 0,1,5,8 or 9.

 

The UpdateFlag field indicates whether the record was updated:

UpdateFlag

Description

Address

Record address and zipcode were updated.

None

Record not updated.