DPV_, DPVNotes_, and DPVExt_ field information

DPV® & DSF2®Flags Purpose:

DPV and DSF2 flags indicate characteristics associated with an address that should be considered when deciding to mail.
DPV =Y means the primary and secondary validated, but depending on what you are mailing (packages versus letters, for example) you might need to consider the flags listed below.

In addition to using the DPV Vacant flag, the No Stat reason codes (below) bring more clarity to deliverability. Package shippers should check the flags for potential delivery conditions, especially for a Business address.

If the DPV_ field contains a "Y" as the FIRST character, the address is DPV Confirmed and exists.

"N" indicates that the address could not be confirmed.

"S" or "D" indicate a confirmed address with exceptions, as you can see in the description listed below.

DPV_ field contains five characters (to see all five characters, pull down Edit to Fields, then change the width of DPV_ to 5. Click OK then click Yes, and validate your records.

Position 1 = DPV Confirmation Indicator
Field contains the results of the call to the DPV Confirmation Hash Table: dph.hsa

Field Description:
Y =Address was DPV confirmed for both primary and (if present) secondary numbers.
D =Address was DPV confirmed for the primary number only, and Secondary number information was missing.
S = Address was DPV confirmed for the primary number only, and Secondary number information was present but unconfirmed.
N =Both Primary and (if present) Secondary number information failed to DPV Confirm.
Blank = Address not presented to hash table.

Position 2 = DPV CMRA Indicator
Field contains the results of the call to the DPV CMRA Hash Table: dph.hsc

Field Description:
Y =Address was found in CMRA table.
N =Address was not found in CMRA table.
Blank = Address not presented to hash table.

Position 3 = DPV False Positive Indicator
Field contains the results of the call to the DPV False Positive Hash Table: dph.hsf

Field Description:
Y = Address was found in False Positive table.
N = Address was not found in False Positive table.
Blank = Address not presented to hash table.

Position 4 = Vacant Indicator
Field contains the results of the call to the DPV VACANT Hash Table: dph.hsv

Field Description:
Y =Address was found in VACANT table.
N =Address was not found in VACANT table.
Blank = Address not presented to hash table.

Position 5 = DSF2 No Stats Indicator
Field contains the results of the call to the DPV NOSTATS Hash Table: dph.hsx

Field Description:
Y =Address was found in NOSTATS table.
N =Address was not found in NOSTATS table.
Blank = Address not presented to hash table.

Field contains the results of the call to the DPV NOSTATS Hash Table: dph.hsx

Note: It is an address that the USPS does not deliver to. It could be a building that is under construction, it could be an address where the mail should go to a PO Box, or it could be an address in a gated community where all delivery is made to the guardhouse.

Position 6 = PBSA Indicator - P.O. Box Street-Style Address
Identifies which Street addresses in a database are actually Post Office Box physical locations

Field Description:
Y =Address is actually a PO Box physical address
N =Address was not found in PBSA table.
Blank = Address not presented to hash table.

Sample address that receives "Y" in Position 6:
9151 ATLANTA AVE UNIT 7823
HUNTINGTON BEACH CA 92615
or
131 S CENTER ST # 3094
COLLIERVILLE TN 38027

The DPV_ field will default to 6-characters for all new databases and remain at 5-characters for existing databases that contain the DPV_ column already.

The possible values in the DPV_ field could be:

'Y' confirmed entire address
'N' could not confirm address
'S' Confirmed address by dropping secondary info
'D' Confirmed a highrise or box type address w/o secondary info 'Blank'
Address was not submitted for confirmation

DPVNOTES_ field could contain any combination of the following codes:

AA - Input address matched to the ZIP + 4 product, indicating a successful match to the ZIP + 4 database.
A1 - Input address not matched to the ZIP + 4 product, indicating that the address could not be found in the ZIP + 4 database.
BB - Input address matched to DPV (Delivery Point Validation) to both primary and secondary numbers necessary to determine a valid delivery point.
BX - PO Box-Only ZIP Codes, identifying ZIP codes where mail delivery is exclusively through P.O. Boxes.
CC - Input address primary number matched, secondary number not matched, secondary number not required.
C1 - Input address primary number matched, secondary number not matched, secondary number required.
DN - Door Not Accessible, indicating addresses where mail carriers are unable to deliver packages due to door accessibility issues.
F1 - Input address matched to a military address, indicating that the address corresponds to a military installation or base.
G1 - Input address matched to a general delivery address, indicating that the address is designated for general delivery services.
IA - Informed address identified, indicating that the address has been identified with additional information to enhance its accuracy.
N1 - Input address primary number matched to DPV, but the address is missing the required secondary number.
M1 - Input address primary number missing, indicating that the primary number of the address is not provided.
M3 - Input address primary number invalid, indicating that the primary number of the address is invalid or does not match a valid delivery point.
ND - Non Delivery Days, indicating addresses with specific non-delivery days, such as businesses closed on certain days or addresses with limited delivery schedules.
NS - No Secure Location, indicating that the door is accessible, but the carrier cannot leave the package due to security concerns.
PB - Identified PO Box Street Address, indicating that the address is identified as a PO Box street address.
PO - PO Box Throwback, helping identify addresses where delivery is made to the customer's PO Box instead of the street address.
P1 - Input address PO, RR, or HC box number missing, indicating that the PO Box, Rural Route (RR), or Highway Contract (HC) box number is missing.
P3 - Input address PO, RR, or HC box number invalid, indicating that the PO Box, RR, or HC box number is invalid or does not match a valid delivery point.
RR - Input address matched to CMRA (Commercial Mail Receiving Agency) but PMB (Private Mailbox) designator present (PMB 123 or # 123).
R1 - Input address matched to CMRA but PMB designator not present (PMB 123 or # 123), indicating that the address is associated with a CMRA but does not have a PMB designator.
R7 - Addresses that are assigned to a phantom route of R777 or R779, indicating non-delivery addresses.
TA - Input address primary number matched by dropping trailing alpha, indicating that the primary number of the address matched after dropping the trailing alphabetic character.
U1 - Input address matched to a unique ZIP Code, indicating that the address is associated with a ZIP code that has a single unique match.
X1 NDD – Non Delivery Days - Closed Monday
X2 NDD – Non Delivery Days - Closed Tuesday
X3 NDD – Non Delivery Days - Closed Wednesday
X4 NDD – Non Delivery Days - Closed Thursday
X5 NDD – Non Delivery Days - Closed Friday
X6 NDD – Non Delivery Days - Closed Saturday
X7 NDD – Non Delivery Days - Closed Sunday
01 No-Stat Reason Code Table (Internal Drop Address) - These are addresses that do not receive mail delivery directly from the USPS but are delivered to a drop address that services them
02 No-Stat Reason Code Table (Computer Delivery Sequence) - These are addresses that have not yet become deliverable. For example, a new subdivision where lots and primary numbers have been determined, but no structure exists yet for occupancy. The delivery is new construction and delivery has not been established or on a Rural/CDS/Highway Contract Route (HCR) where the delivery point is unoccupied for more than 90 days.
03 No-Stat Reason Code Table (COLLISION) - These addresses do not actually DPV®confirm. In this case, the ‘Y’ should be set to an ‘N’ on the DPV® ‘A’ table and all other table values should be blank.
04 No-Stat Reason Code Table (CMZ) - These are ZIP + 4® records USPS has incorporated into the College, Military, and "Other Types" data. It is safe to mail to an address with an 04 in the no-stats table.
05 No-Stat Reason Code Table (REGULAR NO STAT) - Indicates addresses not receiving delivery and the addresses are not counted as possible deliveries. Potential reasons: the address is no longer a possible delivery, the address is on an R777 route, or the PO Box has never been rented or has been declared un-rentable, or the No Stat reason is not one of the other reasons.
06 No-Stat Reason Code Table (SECONDARY REQUIRED) - Indicates the address requires secondary information. The address has incorrect secondary or missing secondary and secondary information is required.

DPVEXT_ Values and Descriptions

Y - Address was DPV confirmed for primary and secondary numbers necessary to determine a valid delivery point.
D - Address was DPV confirmed for the primary number only. Secondary information was missing.
S - Address was DPV confirmed for the primary number only, the secondary number information was present but not confirmed or a single trailing alpha on a primary number was dropped to make a DPV match and secondary information required.
N - Primary number failed to DPV confirm.
R - Address confirmed but assigned to phantom route R777 and R779 and USPS delivery is not provided.
(Blank) - Address not presented to the hash table

« Back to Tech Notes