DPV_ and DPVNotes_ field information

[Eric]

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 recieves "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
>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
>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

[Terry]

With the June/July 2019 version, there are now new possible Dpvnotes_ values.

The new codes are:

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.