New 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.

These new codes apply to mSQL 2.3.3.1 or newer

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

 

0 A single matching address was found 
OR  
An address was found, but a more specific address could be found with more information

10 Invalid input address
11 Invalid 5-digit ZIP Code
12 Invalid state abbreviation code
13 Invalid city name
21 No match found
22 Multiple responses were found and more specific information is required to select a single or default response
31 A single matching address was found  (These are returned as 0 if 'return 0 for Valid addresses' is set to true which it is by default)
32 An address was found, but a more specific address could be found with more information  (These are returned as 0 if 'return 0 for Valid addresses' is set to true which it is by default)

 

* 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

ZIP corrected

B

City/State corrected

C

Invalid City/State/ZIP

D

No ZIP assigned

E

ZIP assigned for multiple response

F

No ZIP available

G

Part of firm moved to address

H

Subbuilding number missing

I

Insufficient/incorrect data

J

Dual input

K

Multiple results caused by cardinal rule

L

Delivery address component added/deleted/changed

M

Street name spelling changed

N

Delivery address was standardized

O

Low +4 tie-breaker (multi-response)

P

Better delivery address exists

Q

Unique zipcode

R

No match due to EWS (Early Warning System)

S

Invalid secondary number

T

Multiple results caused by magnet rule

U

Unofficial po name

V

Unverifiable city/state

W

Small town default

X

Unique ZIP code generated

Y

Military match

Z

ZIP move 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

 

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.

 

Was this article helpful?
0 out of 0 found this helpful

have a question or not finding what you're looking for?

Submit a ticket to get some help