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, matchIT Web 2.5.2.5 or newer, or mDesktop 6.1.40 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 5 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) |
|
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 found in False Positive table. Y - Address was 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 |
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.
- PB - Input address matched to a post office box street address
- 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.
- R7 - Input address matched to a physical address that does not receive delivery from the USPS (R777)
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, it is recommended to ignore this column for US addressing as it is no longer relevant to US addressing, and instead use the DPV column or the pafdescriptionextra column as those are specific to US addressing:
|
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. |