Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

DPV_, DPVNotes_, and DPVExt_ field information

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: ZIP4 matched
  • A1: ZIP4 did not match
  • BB: HSA_DPV confirmed entire address
  • CC: HSA_DPV confirmed address by dropping secondary info
  • F1: Input address matched to a military address.
  • N1: HSA_DPV confirmed a highrise or box type address w/o secondary info
  • M1: Primary number missing from address
  • M3: Could not confirm address
  • P1: Box type address missing box number
  • P3: Box number invalid
  • PO: DPV PO Box Throwback Indicator. The USPS uses the PO Box Throwback table to identify delivery points that are street addresses but mail delivery is to a PO Box address instead.
  • RR: HSC_DPV confirmed address
  • R1: HSC_DPV confirmed a highrise or box type address w/o secondary info
  • R7: R777 Phantom Route Matching. Physical addresses that are assigned to a phantom are not eligible for street delivery.
  • U1: Unique ZIP Code record
  • DN DNA – Door Not Accessible
  • NS NSL – No Secure Location
  • 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 (IDA) - 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 (CDS) - 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.
  • 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.
  • 05 No-Stat Reason Code Table (REGULAR NO STAT) - Indicates addresses not receiving delivery and the addresses are not counted as possible
  • deliveries.
  • 06 No-Stat Reason Code Table (SECONDARY REQUIRED) - Indicates the address requires secondary information.

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

I've been getting unsolicited comments from clients about your support. They are saying things like, 'Without doubt, the finest software support that I have ever received'. Keep up the good work!
Dealer, Silver Spring, MD