DataFlux Data Management Studio 2.5: User Guide

Address Verification (US/Canada) - Data Types

The Address Verification (US/Canada) node uses US/Canada verified address data types, which serve to replace a selected field with corresponding verified address information found in the US Postal Service and Canada Post databases. For example, a ZIP code field might be replaced with US ZIP or Canada Post Code verified address data types, which are guaranteed by the US Postal Service and Canada Post to be accurate.

You can either translate a given field (for example, City) with the US/Canada verified field (US City or Canada City), or create new fields in the table to house the US and Canada verified address data.

Address Verification (US and Canada)

The following is a list of data types used for both United States and Canadian addresses.

Addressee - Specifies the person (contact) who will receive the mail.

Firm - Specifies a business, association, or organization where the mail is going.

Address Line 1 - Specifies the first line of an address, usually including a street name.

Address Line 2 - Specifies the second line of an address, if the first line carries to a second line.

City - Specifies the city name.

State - Specifies the state name.

ZIP/Postal Code - Specifies the ZIP code or postal code used with the address.

Country - Specifies the country related to the address.

Address Verification (US)

The following is a list of the available US verified address data types:

US ZIP - Specifies the five-digit United States ZIP code.

US ZIP4 - Specifies the nine-digit US ZIP code (also known as ZIP+4).

US Street Number - Specifies the street number.

US Street Pre-direction - Specifies a term used by the US Postal Service (USPS) to refer to the part of the address that provides directional information for delivery (for example, N, S, NW, SE, and so on) when it is the first word in the street name and there is no other directional word to the left of it.

US Street Name - Specifies the street name, not the street number.

US Street Suffix - Specifies the type of street, such as Road, Way, Parkway, Court, and so on.

US Street Post-direction - Specifies a term used by the USPS for directional information located to the right of the street name and street suffix, such as N, S, NE, SW.

US Street Secondary Abbrev - Specifies abbreviations for floor, building, suite, apartment, and so on.

US Street Secondary Number - Specifies the number associated with the secondary abbreviation, such as Apt 95, Bldg 2, Suite 201, and so on.

US Urbanization (PR) - Specifies an area, sector, or development within a geographic area. In addition to being a descriptive word, it precedes the name of the area. This urbanization descriptor, commonly used in urban areas of Puerto Rico, is an important part of the addressing format since it describes the location of a given street.

US Carrier Route - Specifies the US carrier route ID used for mail sorting.

US PMB Designator - Specifies Y or N to indicate whether the number is a private US mailbox.

US PMB Number - Specifies the mailbox number associated with the designator. Private companies offering mailbox rental service to individuals or businesses might require a "box" number for final sorting.

US Deliv Pt - Specifies the delivery point bar code, a two-digit number calculated from the address.

US Deliv Pt Check Digit - Specifies a field that is calculated from the ZIP, ZIP+4, and delivery point bar code.

US LACS Indicator - Specifies records that have been converted to the LACS system, a product/system in a different USPS product line that allows mailers to identify and convert a rural route address to a city-style address. Rural route and some city addresses are being modified to city-style addresses so emergency services can find these addresses more efficiently. The indicators are shown in the following table:

Result Code Description
L LACS address, the old (usually rural route) address that has been converted for the LACS system.
Blank Not applicable

US Default Highrise Ind - Indicates whether the address is located in a high-rise building.

US Early Warning System - Specifies a flag that is used by the USPS to flag an address that is expected to change. The return code is either No Match or Early Warning.

US Record Type - Specifies an alphabetic value that identifies the type of data in the record. Record type codes include the following:

Record Type Description
F Firm (ZIP+4 only)
G General delivery (5-digit ZIP, ZIP+4, and carrier route products)
H High-rise (ZIP+4 only)
M Multi-carrier (carrier route product only)
P PO box (5-digit ZIP, ZIP+4, and carrier route products)
R Rural route/highway contract (5-digit ZIP, ZIP+4, and carrier route products)
S Street (5-digit ZIP, ZIP+4, and carrier route products)

US Congressional District - Specifies a standard value identifying a geographic area within the US served by a member of the US House of Representatives or Senate. If Army/Air Force (APO) or fleet post office (FPO), this field will be blank. If there is only one member of Congress within a state, the code will be "AL" (at large).

US County Code - Specifies the Federal Information Processing Standard (FIPS) code assigned to a given county or parish within a US state. In Alaska, it identifies a region within the state. If APO/FPO and the record type is "S," "H," or "F," the county number will be blank.

US County Name - Specifies the county name associated with the county code.

US State FIPS - Specifies the US State (FIPS) code assigned to a specific state.

US Extra Information - Contains additional information before and after P.O. Box information that must be stripped away when an input address contains PO Box information. This information must be removed under CASS rules.

US Finance Number - Refers to an area encompassing a set of ZIP codes.

US Preferred City Name - Specifies the preferred city name, according to the USPS.

US Abbreviated City Name - Specifies the abbreviated city name, according to the USPS.

US Verified Street-Level Address Flag - Specifies Y or N, which indicates whether the street-level information matches.

US Result Code - Indicates whether the address was successfully verified. In case the address was not successfully verified, a US Return Code indicates the cause of address verification failure, as shown in the following table:

Text Result Code Numeric Result Code Description
OK 0 Address was verified successfully.
PARSE 11 Error parsing address. Components of the address might be missing.
CITY 12 Could not locate city/state or zip in the USPS database. At least (city and state) or ZIP must be present in the input.
MULTI 13 Ambiguous address. There were two or more possible matches for this address with different data.
NOMATCH 14 No matching address found in the USPS data.
OVER 15 One or more input strings is too long (maximum 100 characters).

US Numeric Result Code Contains the numeric result to the US Result Code field. See the Numeric Result Code column above for additional information.

US RDI Result Code - Specifies the Residential Delivery Indicator (RDI), which confirms whether a particular address is residential or business. This information is useful because different postal rates can apply for residential versus business deliveries. If the RDI query process was successful, RDI address confirmation result will be stored in US RDI, as shown in the following table:

Result Code Description
0 Success
5 Product is locked
9 Functionality is disabled

US RDI - Displays the US Residential Delivery Indicator, which displays the residential delivery results, as shown in the following table:

Result Code Description
Y Residential Delivery
Blank Not Residential Delivery

Note Note: RDI is available from the USPS for an annual licensing fee, which includes monthly updates. For more information about RDI, please visit the USPS Web site at http://www.usps.com/ncsc/addressmgmt/RDI.htm.

US eLOT Result Code - Confirms whether an address has a presort sequence number. The result codes include:

Result Code Description
0 Success
5 Product is locked
9 Functionality is disabled

Note Note: eLOT processing is performed only when the ZIP+4 is present in the output. This means when CASS compliance is selected, the DPV is confirmed. If the DPV Confirmation Indicator does not return a valid confirmation (D, S, or Y), then the return code 9 will be returned for eLOT result code fields.

US eLOT AD Flag - Indicates whether the number is in ascending or descending order, as shown in the following table:

Result Code Description
A Ascending
D Descending

US eLOT Sequence Number - Specifies a four digit number used to presort mail in the delivery order for a specific carrier route.

US DPV Result Code - Confirms the address actually exists, as opposed to a valid range of house numbers on the street. The US DPV Result Code indicates the status of the DPV query process and will contain either a success (0) or an error code (see below). If DPV query process was successful, the DPV address confirmation result will be stored in US DPV Confirmation Indicator. Possible error codes for US DPV Result Code are shown in the following table:

Result Code Description
0 Success
5 Product is locked
99 DPV processing was stopped due to an "artificial" address. That address is saved in "dpv_fp_addr" member of the "dfav_us_result" structure.

US DPV Confirmation Ind - Indicates the delivery point. The following table displays the available result codes and descriptions:

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

US CMRA Confirmation Ind - Indicates whether an address is from a private mail box company, as shown in the following table:

Result Code Description
Y Address was found in CMRA table.
N Address was not found in CMRA table.
Blank Address not presented to hash table.

US DPV Footnote 1 - Contains a notation regarding DPV processing, as shown in the following table:

Result Code Description
AA Input address matched to the ZIP+4 file.
A1 Input address did not match to the ZIP+4 file.
BB Input address matched to DPV (all components).
CC The input address primary number matched to DPV but the secondary number did not match (both numbers present but invalid).
F1 Input address is a military address.
G1 Input address is a general delivery address.
M1 Input address primary number missing.
M3 Input address primary number invalid.
N1 Input address primary number matched to DPV but high-rise address missing secondary number.
P1 Input address missing PO, RR, or HC box number.
P3 Input address PO, RR, or HC box number invalid.
RR Input address matched to CMRA and PMB designator present (PMB 123 or #123).
R1 Input address matched to CMRA but PMB designator not present (PMB 123 or #123).
U1 Input address has a unique ZIP code.

US DPV Footnote 2 - The possible values for US DPV Footnote 2, which are the same as US DPV Footnote 1.

US DPV Footnote 3 - The possible values for US DPV Footnote 3 are the same as US DPV Footnote 1.

US DPV Other Footnotes - Exists for backward compatibility only; it will always contain an empty string.

US DPV False Positive Ind - Indicates that the Delivery Point Value (DPV) processing was terminated due to the detection of what might be an artificially created address. No address beyond this point has been DPV validated. In accordance with the License Agreement between USPS and DataFlux, DPV shall be used to validate legitimately obtained addresses only, and shall not be used for the purpose of artificially creating address lists. Values for this field are shown in the following table:

Note Note: The DataFlux license with the USPS restricts any DataFlux customer from using DPV to artificially create address lists. Continuing use of DPV requires compliance with all terms of the DataFlux agreement with the USPS. If you believe that this address was identified in error, please contact DataFlux. You should immediately report the address to DataFlux and DataFlux will notify the USPS of the address.

Result Code 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.

US LACSLink Result Code - Displays an internal result code from LACSLink functional component. The following table displays possible result codes. Any other value is an internal error code.

Result Code Description
0 Success
99 False positive

US LACSLink Indicator - Indicates whether an input address exists in LACSLink database. Possible values are shown in the following table:

Result Code Description
F Input address is a false positive. This is similar to DPV false positive - USPS believes that the input address was artificially generated. When this type of address is presented to LACSLink the LACSLink functionality is disabled for the remaining verify process.
N Address conversion does not exist.
S Address conversion exists only if secondary information is dropped from the input address.
Y Address conversion exists.

US LACSLink Return Code - Return codes for LACSLink lookups as defined by USPS. Possible values are shown in the following table:

Result Code Description
A New address was found successfully and provided upon output.
00 Address conversion does not exist.
14 Could not convert address at run time. This means that the initial lookup table indicated a conversion exists, but further lookups (in other tables) failed to find one.
92 New address was found only after secondary information from input address was dropped.

US Data Date - Indicates when the USPS data was last compiled.

US DPV Data Date - Indicates when the DPV data was last compiled.

US LACSLink Data Date - Indicates when the LACSLink data was last compiled.

US eLOT Data Date - Indicates when the eLOT data was last compiled.

Address Verification (Canada)

The following is a list of the available Canadian Verified Address Data Types:

Canada Result Code - Indicates whether the address was successfully verified. In case the address was not successfully verified, the Canada Return Codes shown in the following table indicate the cause of address verification failure:

Result Code Description
0 No error occurred
1 Internal error
2 Cannot load database
3 Invalid - unspecified reason
4 Invalid civic number
5 Invalid street
6 Invalid unit
7 Invalid delivery mode
8 Invalid delivery installation
9 Invalid city
10 Invalid province
11 Invalid postal code
12 Address is not Canadian

Canada Civic Number - Indicates the address civic number.

Canada Civic Number Suffix - TIndicates the end of the address civic number.

Canada Street Name - Indicates the parsed address street name.

Canada Street Type - Indicates the parsed address street type, such as drive, street, road, and more.

Canada Street Direction - Indicates the parsed address street directional information, such as South, Southwest, Northwest, and so on.

Canada Unit Type - Indicates suite, apartment, building, and more.

Note Note: Non-Standard Canada Unit Types are no longer a part of the documentation for Canada Post but continue to be acceptable.

Canada Unit Number - Specifies the number representing the unit type, for example Apt. B, Suite 201, and so on.

Canada Deliv Mode Type - This type indicates the delivery type, as shown in the following table:

Result Code Description
CP Case Postale
GD General Delivery
IM Itin�raire motoris�
MR Mobile Route
PO Post Office Box
PR Poste Restante
RR Route Rurale
SS Service Suburbain

Canada Deliv Mode Number - Specifies the number associated with the address delivery mode type, if applicable. For example, the number of the Rural Route or Post Office Box.

Canada Deliv Inst Area - Indicates the general location of the postal installation.

Canada Deliv Inst Type - Indicates the type of postal installation.

Canada Deliv Inst Qualifier - Identifies a postal installation if more than one installation shares the same general location.

Canada Non Address - Specifies information that is included in the input address but is not part of any address components required by Canada Post.

Canada Large Volume Receiver Flag - Indicates Y if the address is a large volume receiver and N if it is not.

Canada Rural Address Flag - Indicates Y if the address is a rural address and N if it is not.


Related Topics

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_PFEnrich_AddrVerUSCan_DataT.html