Previous Article | Addresing section | Next Article |
Depending on your product you will get back these codes with some slight variations, below listings are primarily focused on matchIT SQL 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
matchIT SQL - 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. |
* 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 matchIT desktop 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 matchIT SQL this is the ncoaCorrections
In desktop, 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 standardised. |
4 |
Unit not verified. |
5 |
Leftovers found. |
6 |
Zip move match. |
7 |
|
8 |
SuiteLink Match. |
C) DPV
The DPV field is 5 characters wide; it enhances data by adding the Delivery Point Validation information generated by the addressIT module. The placement of the character code indicates which process was performed. The meanings of the five character positions are summarised 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 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 |
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 Standardised 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.
E) PafFlag and PafDesc and UpdateFlag
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. |
Previous Article | Addresing section | Next Article |