Task Factory Address Management

Address Parse

Address Parse Transform

Transform IconTransform Description
Task Factory Address Parse Transform IconThe Address Parse Transform is used to parse unformatted address data and transforms it into USPS standardized address data.

Address Data Input

Task Factory Address Parse Transform Address Data Input

Input Options

OptionDescription
Single column contains all address dataUse this option when all of the address data from your source is contained in a single column.
Address data is spread across multiple columnsUse this option when the address data from your source is not contained in a single column. You choose which column from your source contains the address element needed by the transform.

Use the address data input tab to map the source input columns to the appropriate address elements in the address parse transform. Your source does not have to contain a one to one relationship to the address elements in the address parse. You can map a single column from your source to multiple address elements in the transform. For example:

AddressLine1 column:Address
AddressLine2 column:Address
City column:CityStateZip
State column:CityStateZip
PostalCode column:CityStateZip

Address Quality

Task Factory Address Parse Transform Address Quality

The address parse assigns a level of quality to two sections of the address:

  1. Address Line 1 and Address Line 2
  2. City, State, and Zip

There are three levels of quality that can be assigned to the two sections of an address:

HighMediumLow
  • Address Line 1 and Address Line 2 - The address is technically complete
  • City, State, Zip - These fields are technically correct
  • Address Line 1 and Address Line 2 - The address is complete but missing a part of the address like apartment number or street suffix
  • For Address Line 1 and Address Line 2 - The address is not verifiable
  • For City, State, Zip - Either the City, State, or Zip Code is missing

When the address parse runs it parses out the data and assigns the level of quality based on whether it can find a valid address and a valid city, state, and zip according to the rules above. You can either include all of the address as part of the output from the transform or you can select Include only high quality parsed addresses. Selecting this means that the output named Parsed Address Output contains addresses that are considered high quality. If you choose this option you must also make a selection from the What should happen to non-parseable (low quality) addresses? drop down menu.

OptionDescription
Ignore FailuresThis option skips the addresses marked as low quality.
Redirect Errors to Error OutputThis option redirects the rows to the error output.
Fail ComponentThis option fails the component when the first invalid address is found.
Redirect Errors to Non-Parseable OutputThis option redirects the rows to the Non-Parsed Address Output.

Parsed Output

Task Factory Address Parse Transform Parsed Quality

The Parsed Output tab defines how you want the parsed address data outputted from the transform. By default there are new columns for each address elements and quality elements as part of the Parsed Address Output.

Output Columns

ColumnDescription
Address Data ColumnThe address data column defines the data that is output from the transform.
Action ColumnThe action column defines whether the output contains a new column or the data in an existing column.

  • Add New Column - This tells the transform to add a new column to the output. The columns to the right of the action column are used to define the properties of the output column. The data for the respective address data column is contained in the output column defined in the Output Column Name column.
  • Replace Column - This tells the transform to replace the data in a source column instead of using an output column. You need to select the name of the source column to replace in the Output Column Name column. If this option is selected, all of the columns to the right of Output Column Name are now read-only.
Output Column NameDefines either the name of the output column if Add New Column is selected in the Action column or the name of the source column to replace if Replace Column is selected.
 Output Data TypeChoose the output data type.
Output LengthDefine the length of the column.
Code PageChange the code page.
Output Case FormattingDefines how the output is determined:

  • Proper Case - This transforms all of the data in the parse address to proper case (First letter of every word is upper case).
  • Upper Case - This transforms all of the data in the parse address to upper case.
  • No Case Formatting - This does not transform the case of the data.
Address Verification

Important:  Address Verification Transform is available for SQL versions 2012 and higher.

Address Verification Transform must be run in 32-bit mode. An internet connection is required to update the Address Verification database.

Address Verification Transform

Transform IconTransform Description
Task Factory Address Verification Transform IconThe Address Verification Transform uses the USPS database to verify United States addresses.

Source Data

Task Factory Address Verification Transform Source Data

OptionDescription
Firm Name Source Column(Optional) Maps the column that contains the person or firm's name.
Address1 Source Column(Required) Maps the column that contains the first address line.
Address2 Data Column(Optional) Maps the column that contains the second address line (e.g. suite or apartment numbers, building name, etc.)
City Source Column(Required) Maps the column that contains the city.
State Source Column(Required) Maps the column that contains the state.
Zip Code Source Column(Required) Maps the column that contains the zip code.
Unverified Address BehaviorOptions for handling unverified addresses:

  • Ignore unverified (unverified addresses will be skipped) - Skips the unverified address and continues execution.
  • Redirect unverified to unverified output - Redirects all unverified addresses to a designated unverified output.
  • Fail upon first unverified address found - Fails the component as soon as an unverified address is encountered.

Output Columns

Task Factory Address Verification Transform Output Columns

OptionDescription
Address Data ColumnIdentifies the column.
Column BehaviorUsers can choose between the following:

  • Replace Column
  • Add New Column
  • Do Not Output Column
Output Column NameUsers can change the name of the output column.

The following list details the Address Verification Transform's output:

Column Name

Data Type

Length

AddressLine1

DT_WSTR

255

AddressLine2

DT_WSTR

255

City

DT_WSTR

255

State

DT_WSTR

3

ZipCode

DT_WSTR

10

ResponseCode

DT_I1

0

AbbreviatedCity

DT_WSTR

255

AddressComponentChanged

DT_BOOL

0

AddressKey

DT_WSTR

255

AddressNotFound

DT_BOOL

0

AddressStandardized

DT_BOOL

0

AllOrPartFirmLineUsedForAddressLine

DT_BOOL

0

BetterAddressExists

DT_BOOL

0

CarrierRoute

DT_WSTR

255

CarrierRouteRateSortIndicator

DT_WSTR

255

CityStateCorrected

DT_BOOL

0

CountyCode

DT_WSTR

255

DeliveryPoint

DT_WSTR

255

FirmName

DT_WSTR

255

FirstPostDirection

DT_WSTR

255

FirstPreDirection

DT_WSTR

255

FirstSuffix

DT_WSTR

255

IncorrectSecondaryNumber

DT_BOOL

0

InsufficientIncorrectData

DT_BOOL

0

InvalidCityStateZip

DT_BOOL

0

LookupStatus

DT_WSTR

255

MainPostOfficeOutputCity

DT_WSTR

255

MainPostOfficeOutputState

DT_WSTR

255

MatchedPrimaryNumber

DT_WSTR

255

MatchedSecondaryNumber

DT_WSTR

255

MilitaryMatch

DT_BOOL

0

MissingSecondaryNumber

DT_BOOL

0

MultipleResponseCanBeBrokenUsingTheLowestZip4

DT_BOOL

0

MultipleResponseDueToMagnetStreetSyndrome

DT_BOOL

0

NoMatchDueToEws

DT_BOOL

0

NonPoBoxDualAddress

DT_BOOL

0

NoZip4Assigned

DT_BOOL

0

PoBoxDualAddress

DT_BOOL

0

PrimaryName

DT_WSTR

255

PrimaryNumber

DT_WSTR

255

RuralRouteNumber

DT_WSTR

255

SecondaryNumber

DT_WSTR

255

SecondaryNumberUnit

DT_WSTR

255

SecondPostDirection

DT_WSTR

255

SecondPreDirection

DT_WSTR

255

SecondSuffix

DT_WSTR

255

SmallTownDefault

DT_BOOL

0

StandardizedOutputCityStateZip

DT_WSTR

255

StandardizedPrUrbanizationName

DT_WSTR

255

StreetNameChanged

DT_BOOL

0

UniqueZipCodeDefault

DT_BOOL

0

UniqueZipCodeMatch

DT_BOOL

0

UnofficialPostOfficeName

DT_BOOL

0

UnverifiableCityState

DT_BOOL

0

ZipCode4

DT_WSTR

255

ZipCodeAssignedWithMultipleResponse

DT_WSTR

255

ZipCodeCorrected

DT_BOOL

0

ZipMoveMatch

DT_BOOL

0

USPS Database Update

Important:  As of January 1, 2019, SentryOne no longer provides subscriptions or updates to the AVDB database.  Customers need to subscribe and receive updates directly through the USPS’s Electronic Product Fulfillment website. You must purchase the 32-bit version because the 64-bit version is not yet supported.

Previous customers that received updates through Pragmatic Works - the last update occurred in November of 2018. Per the USPS, databases must be updated within 105 days of the previous update to maintain access. It's recommended customers update their database as soon as possible through the USPS’s Electronic Product Fulfillment website to ensure they maintain access.

Additional Information: For more information about the pricing and fees for the USPS database subscription, see the following link.

USPS Database Installation and Updates

Setting up the USPS Database for Task Factory

Complete the following steps to update your USPS database and assemblies when using the Task Factory Address Verification component:

Step One : Download Assemblies and Database

  1. Log in to the USPS’s Electronic Product Fulfillment website, and then download the following files:
    • AMS Commercial DVD SHA-256
    • AMS Developer Kit SHA-256
    • DPV Developer Kit SHA-256

Task Factory Download USPS Assemblies and Database

Step Two : DPV Extraction

  1. Extract dpv_devkit.tar to the desired directory.
  2. Run the gdev.exe application. Note:  The gdev.exe application is located in the directory where dpv_devkit.tar was extracted.
  3. Select the W32 platform and then select all the files in the Select Files section.
    Task Factory DPV Extraction
  4. Enter your USPS customer id for the W32 customer ID. Note:  you may need to email the USPS support team for this step.
  5. Enter the destination directory. Important:  Ensure you include the at the end of the path. For example,  c:\usps\output\ .
    Task Factory W32 Customer ID
  6. Select Extract to proceed with the extraction. Note:  You should receive this message :
    Task Factory DPV Extraction Message

Step Three : AMS Extraction

  1. Extract the ams_devkit.tar file to the desired directory.
  2. Run the gdev.exe application. Note:  The gdev.exe application is located in the directory where ams_devkit.tar was extracted.
  3. Select the W32 platform and then select all the files in the Select Files section.
    Task Factory AMS Extraction
  4. Enter your USPS customer id for the W32 customer ID. Note:  you may need to email the USPS support team for this step.
  5. Enter the destination directory. Important:  Ensure you include the at the end of the path. For example,  c:\usps\output\ .
    Task Factory W32 Customer ID
  6. Select Extract to proceed with the extraction. Note:  You should receive this message
    Task Factory AMS Extraction Message
  7. Now copy the unencrypted files from both the AMS and DPV directories defined in the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Pragmatic Works\Task Factory\AmsDirectory. Note:  You only need the .dll and .lib files.
    Task Factory AMS Directory
Note:  Now the directory should look like this :

Task Factory Updated Directory example

Step Four : USPS Database Extraction

  1. Extract the contents of dvd_comm.tar to a temp directory.
  2. Rename the following:  
    • ams_comm directory to ams
    • ams_dpv directory to dpv
    • ams_elot directory to elot

Note:  Your directory should now look like this :
Task Factory Updated AMS Directory example

3. Copy all of the directories from the temp directory to the directory defined in the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Pragmatic Works\Task Factory\AmsDbDirectory.
Task Factory AmsDbDirectory

Important:  The database expires after 105 days and users MUST update before this deadline to prevent the database from expiring. This is required per the USPS Database guidelines. Once the database has expired after the 105 day deadline, users have to contact the USPS vendor.

Understanding the USPS Address Verification Output

There are three outputs that are provided by the Address Verification Transform:

  1. Verified Address Output – This output includes all addresses that are returned from the USPS database as either a ResponseCode of 31 (single address found) or 32 (address found, but more accurate address could be located). See response status table for full descriptions.
  2. Invalid Address Output  – This output includes all addresses that are returned from the USPS database with a response code of anything other than 31 or 32 .
  3. Multiple Address Output – This output includes the other addresses found when an address is returned with a status of 22 (multiple addresses found). The address record with a status of 22 sends out of the Invalid Address Output if the Unverified Address Behavior is set to Redirect unverified to unverified output in the:
    Task Factory Unverified Address Behavior Example
  4. Error Output – This output contains any addresses where the data from the input column mapped to the Address 1 Source Column contains an empty or null value.

Output Columns

Verified Address Output Column Definitions

Column NameDefinition

AddressLine1

The standardized address line1 from the usps database.

AddressLine2

The standardized address line2 from the usps database.

City

The standardized city from the usps database.

State

The standardized state from the usps database.

ZipCode

The standardized zip code from the usps database.

ResponseCode

The response code returned from the USPS database. See Response Code Table for the codes and definitions.

AbbreviatedCity

The abbreviated city.

AddressComponentChanged

An address component (i.e., directional or suffix only) was added, changed, or deleted in order to achieve a match.

AddressKey

Internal address database key (for indexing).

AddressNotFound

Set to true if the address wasn’t found.

AddressStandardized

Set to true if the address was standardized. For example, if STREET was in the delivery address, the system returns ST as its standard spelling.

AllOrPartFirmLineUsedForAddressLine

Set to true if information in the firm line was determined to be a part of the address. It was moved out of the firm line and incorporated into the address line.

BetterAddressExists

Set to true if the delivery address is matchable, but is known by another (preferred) name. For example, in New York, NY, AVENUE OF THE AMERICAS is also known as 6TH AVE. An inquiry using a delivery address of 55 AVE OF THE AMERICAS would set this value to true.

CarrierRoute

The USPS 4 digit carrier rate code.

CarrierRouteRateSortIndicator

Set to A, B, C, or D :

  • A = CR Sort Rates Apply Merge Allowed
  • B = CR Sort Rates Apply Merge Not Allowed
  • C = CR Sort Rates Do Not Apply Merge Allowed
  • D = CR Sort Rates Do Not Apply Merge Not Allowed

CityStateCorrected

The spelling of the city name and/or state abbreviation in the submitted address was found to be different than the standard spelling. The standard spelling of the city name and state abbreviation are shown in the output address.

CountyCode

The USPS county code for the address.

DeliveryPoint

The USPS delivery point for the address.

FirmName

The standardized firm name.

FirstPostDirection

First or Left Post-direction.

FirstPreDirection

First or Left Pre-direction.

FirstSuffix

First or Left Suffix.

IncorrectSecondaryNumber

Set to true if the secondary number was incorrect.

InsufficientIncorrectData

Set to true if Insufficient / Incorrect data is found.

InvalidCityStateZip

Set to true if an invalid city, state and zip was found.

LookupStatus

The return code value returned from the USPS database.

MainPostOfficeOutputCity

The city of the main post office for the standardized address.

MainPostOfficeOutputState

The state of the main post office for the standardized address.

MatchedPrimaryNumber

The primary address number.

MatchedSecondaryNumber

The primary secondary number.

MilitaryMatch

Set to true if a match was made with a military zip code.

MissingSecondaryNumber

Set to true if ZIP+4 information indicates this address is a building. The address as submitted does not contain an apartment/suite number. It is recommended that the requestor check the submitted address and add the missing apartment or suite number to ensure the correct Delivery Point Barcode (DPBC).

MultipleResponseCanBeBrokenUsingTheLowestZip4

More than one ZIP+4 Code was found to satisfy the address as submitted. The lowest ZIP +4 addon may be used to break the tie between the records.

MultipleResponseDueToMagnetStreetSyndrome

The search resulted in a single response; however, the record matched was flagged as having magnet street syndrome. “Whenever an input address has a single suffix word or a single directional word as the street name, or whenever the ZIP+4 File records being matched to have a single suffix word or a single directional word as the street name field, then an exact match between the street, suffix and/or post-directional and the same components on the ZIP+4 File must occur before a match can be made. Adding, changing or deleting a component from the input address to obtain a match to a ZIP+4 record will be considered incorrect.” Instead of returning a no match in this situation a multiple response is returned to allow access the candidate record.

NoMatchDueToEws

Set to true if the delivery address is matchable, but the EWS file indicates that an exact match will be available soon.

NonPoBoxDualAddress

CASS rule does not allow a match when the cardinal point of a directional changes more than 90%.

NoZip4Assigned

The ZIP Code in the submitted address could not be found because neither a valid city, state, nor valid 5-digit ZIP Code was present. It is also recommended that the requestor check the submitted address for accuracy.

PoBoxDualAddress

Set to true if the input contained two addresses. For example: 123 MAIN ST PO BOX 99.

PrimaryName

The primary street name.

PrimaryNumber

The primary street number.

RuralRouteNumber

The rural route number.

SecondaryNumber

The secondary number of the street address.

SecondaryNumberUnit

The secondary number unit of the street address.

SecondPostDirection

Second or Right Post-direction.

SecondPreDirection

Second or Right Pre-direction.

SecondSuffix

Second or Right Suffix.

SmallTownDefault

Set to true because of an invalid delivery address. The input address record contains a delivery address other than a PO BOX, General Delivery, or Postmaster with a 5-digit ZIP Code that is identified as a “small town default.” The United States Postal Service does not provide street delivery for this ZIP Code. The United States Postal Service requires use of a PO BOX, General Delivery, or Postmaster for delivery within this ZIP Code.

StandardizedOutputCityStateZip

The standardized city, state and zipcode.

StandardizedPrUrbanizationName

The standardized Puerto rican urbanization.

StreetNameChanged

Set to true if the standardized address changed the street name.

UniqueZipCodeDefault

Set to true if a default match inside a unique ZIP Code.

UniqueZipCodeMatch

Set to true if an address with a unique ZIP Code was found.

UnofficialPostOfficeName

Set to true if the city or post office name in the submitted address is not recognized by the United States Postal Service as an official last line name (preferred city name), and is not acceptable as an alternate name. This does denote an error and the preferred city name will be provided as output.

UnverifiableCityState

Set to true if the city and state in the submitted address could not be verified as corresponding to the given 5-digit ZIP Code. This comment does not necessarily denote an error; however, it is recommended that the requestor check the city and state in the submitted address for accuracy.

ZipCode4

The last 4 digits of the standardized address zip code.

ZipCodeAssignedWithMultipleResponse

Set to true if multiple records were returned, but each shares the same 5-digit ZIP Code.

ZipCodeCorrected

Set to true if the zip code was corrected when the address was standardized.

ZipMoveMatch

Set to true if the ZIPMOVE product shows which ZIP + 4 records have moved from one ZIP Code to another. If an input address matches to a ZIP + 4 record which the ZIPMOVE product indicates as having moved, the search is performed again in the new ZIP Code.

Unverified Address Output

This output contains all the input column data along with a column named WhyInvalid which tells you why the address was deemed invalid by the USPS database

Error Output

This output contains all the input column data along with a column named ErrorDescription which tells you input data was deemed invalid by the address verification transform.

Multiple Address Output

Column NameDescription

ActionCode

A field indicating the action to be taken in updating the base master files. 

AddOnHigh

The high-end ZIP add-on in a range of codes; the add-on of the last +4 code in a consecutive series of +4 codes assigned to the delivery address. Most delivery addresses are assigned a single +4 code; however, large companies may be given a range of +4 codes that can be used to route mail to specific departments. A range of +4 codes can also be assigned to a corresponding range of Post Office boxes, and each box is mapped, one-to-one, with a +4 code in the range. A single Post Office box can also be assigned a range of +4 codes. (See +4 Code.)

Example:

12345-0001 through 12345-0009 => +4 High Number = 0009+4 codes associated with non-delivery areas are composed of valid ZIP™ sector numbers and “ND” for the ZIP segment number. Non-deliverable areas are areas to which the USPS does not deliver mail, such as vacant lots and land that borders railroad tracks. Mailers should not match an address identified as a non-delivery area. (See ZIP Sector Number or ZIP Segment Number.)

AddOnLow

The last four positions of a +4 code; the low-end +4 in a range of codes; the add-on of the first +4 code in a consecutive series of +4 codes assigned to the delivery address. For example, most delivery addresses are assigned a single +4 code. However, large companies may be given a range of +4 codes that can be used to route mail to specific departments. A range of +4 codes can also be assigned to a corresponding range of Post Office boxes, and each box is mapped, one-to-one, with a +4 code in the range. A single post office box can also be assigned a range of +4 codes.

Example:

12345-0001 through 12345-0009 => +4 Low Number = 0001+4 Codes associated with non-delivery areas are composed of valid ZIP sector numbers and “ND” for the ZIP segment number. Non-deliverable areas are areas to which the USPS does not deliver mail, such as vacant lots and land that borders railroad tracks. Mailers should not match an address identified as a non-delivery area. (See ZIP Sector Number or ZIP Segment Number.)

BaseAlternateCode

Code that specifies whether a record is a base (preferred) or alternate record. Base records (represented as B) can represent a range of addresses or an individual address, such as a firm record, while alternate records (represented as A) are individual delivery points. 

Base Data Element Definitions Address Information System Products Technical Guide 62 records are generally preferred over alternate records. However, one exception is ZIP+4® product; in this file, government deliveries will only be listed on alternate records with the appropriate government building indicator (federal, state, or city) set.

CarrierRoute

A 4-byte code assigned to a mail delivery or collection route within a 5-digit ZIP™ Code. The first character of this identification is alphabetical, and the last three are numeric:

  • B### = PO box
  • H### = Contract
  • R### = Rural route
  • C### = City delivery
  • G### = General delivery

CongressionalDistrict

A standard value identifying a geographic area within the United States served by a member of the U.S. House of Representatives. If Army/Air Force (APO), Fleet Post Office (FPO), or Diplomatic/Defense Post Office (DPO), this field will be blank. If there is only one member of Congress within a state, the code will be AL (at large).

CopyrightDetailCode

Alphabetic code that identifies the type of record in a USPS® product file.

  • A = Alias record
  • C = Copyright record
  • D = Detail record
  • N = Seasonal record
  • S = 5-Digit ZIP scheme combinations record
  • Z = Zone split record

CountyNumber

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

FinanceCode

A code assigned to Postal Service™ facilities (primarily Post Offices) to collect cost and statistical data and compile revenue and expense data.

FirmOrBuildingName

The firm or building name.

LACSConvertedStatus

The Locatable Address Conversion Service (LACS) indicator describes 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 that emergency services (e.g., ambulances, police) can find these addresses more efficiently.

  • L = LACS address: The old (usually rural-route) address that has been converted for the LACS system.
  • Blank = Not applicable

LastLine

A value that uniquely identifies a city state name in the City State product.

PostDirection

A geographic direction that follows the street name. 

Example: 

123 MAIN ST N Street Post-Directional Abbreviation = N Spaces = No post-direction E = East N = North NE = Northeast NW = Northwest S = South SE = Southeast SW = Southwest W = West

PreDirection

A geographic direction that precedes the street name. 

Example: 123 N MAIN ST Street Pre-Directional Abbreviation = N Spaces = No pre-direction E = East N = North NE = Northeast NW = Northwest Data Element Definitions Address Information System Products Technical Guide 76 S = South SE = Southeast SW = Southwest W = West

PrimaryEvenOddCode

The address primary even/odd code. 

  • O = Odd 
  • E = Even 
  • B = Both

PrimaryHighRange

A house, rural route, contract box, or Post Office box number. The numeric or alphanumeric component of an address preceding the street name. The high-end address in a range of addresses. Often referred to as house number.

Examples:

Address RangePrimary High Number

100 – 198 Main Ave

198

101 – 199 Main Ave 199

199

A200 – A298 Main Ave A298

A298

124-45 – 124-88 Main Ave

124-88

101 – 120 PO Box

120

22A – 22B RR 2

22B

PrimaryLowRange

A house, rural route, contract box, or Post Office box number. The numeric or alphanumeric component of an address preceding the street name. The low-end address in a range of addresses. Often referred to as house number

Examples:

Address RangePrimary High Number

100 – 198 Main Ave

100

101 – 199 Main Ave 199

101

A200 – A298 Main Ave A298

A200

124-45 – 124-88 Main Ave

124-45

101 – 120 PO Box

101

22A – 22B RR 2

22A

RecordType

The record type. 

  • G = General delivery 
  • M = Multi-carrier 
  • P = PO Box 
  • R = Rural Route 
  • S = Street

SecondaryEvenOddCode

The address secondary even/odd code. 

  • O = Odd 
  • E = Even 
  • B = Both

SecondaryHighRange

Code that describes an apartment, room, suite, space, floor, or other secondary addressing numeric or alphanumeric that follows a street address. The high-end secondary address component in a range of secondary addresses.

Examples:

Address RangeAddress Secondary High Number

00000001 through 00000009

00000009

A through F

F

66A through 66E

66E

SecondaryLowRange

Code that describes an apartment, room, suite, space, floor, or other secondary addressing numeric or alphanumeric that follows a street address. The low-end secondary address component in a range of secondary addresses.

Examples:

Address RangeAddress Secondary High Number

00000001 through 00000009

0000000A

A through F

A

66A through 66E

66A

SecondaryUnit

A descriptive code used to identify the type of address secondary range information in the Address Secondary Range field. This code may be useful in address matching, e.g., the secondary address numbers may indicate apartment, suite, or trailer numbers. (See Publication 28, Postal Addressing Standards, for values.)

StreetName

The official name of a street as assigned by a local governing authority. The Street Name field contains only the street name and does not include directionals (EAST, WEST, etc.) or suffixes (ST, DR, BLVD, etc.). This element may also contain literals, such as PO BOX, GENERAL DELIVERY, USS, PSC, or UNIT. Numeric street names that have numeric components that are four characters (or less) in length at are justified such that the low-order digit of the number is positioned in the fourth position of the street name field. This shift is made so that the numeric street names appear in numeric sequence.

Suffix

Code that is the standard USPS® abbreviation for the trailing designator in a street address. (See Publication 28, Postal Addressing Standards, for values.)

UpdateKeyNumber

Field that contains a number that uniquely identifies a record; used to identify the base record to which an add or delete transaction is being directed. The Update Key Number field is used only when applying transactions to the base file; it is not used in address matching and remains fixed for the life of the record. The field is alphanumeric and consists of the database segment code (V1, V2, W1, W2, X1, X2, Y1, Y2, Z1, or Z2) and eight characters containing an alphanumeric value ranging from 00000001 to AAAAAAAA.

Urbanization

An index to the City State file that provides the urbanization name for this delivery range.

ZipCode

A 5-digit code that identifies a specific geographic delivery area. ZIP Codes can represent an area within a state, or a single building or company that has a very high mail volume.

Response Status Table

Response CodeDefinition

10

The address was sent to the verification database was invalid (i.e. contained a dual address)

11

The address supplied had an invalid zip code

12

The address supplied had an invalid state abbreviation code

13

The address supplied had an invalid city name