Address Verification (US/Canada)

DataFlux Data Management Studio 2.7: User Guide

Address Verification (US/Canada) - Reference

The following reference materials are available for Address Verification (US/Canada):

Field Types and Lengths
Canadian Address Verification
Troubleshooting

Field Types and Lengths

The following table displays the field types and lengths for Address Verification (US/Canada):

ID	Integer	Length
Addressee	VARCHAR	(100)
Firm	VARCHAR	(100)
Address_Line_1	VARCHAR	(100)
Address_Line_2	VARCHAR	(100)
City	VARCHAR	(100)
State	VARCHAR	(40)
ZIP/Postal_Code	VARCHAR	(40)
Country	VARCHAR	(6)
US_ZIP	VARCHAR	(40)
US_ZIP4	VARCHAR	(40)
US_Street_Number	VARCHAR	(40)
US_Street_Pre-direction	VARCHAR	(40)
US_Street_Name	VARCHAR	(40)
US_Street_Suffix	VARCHAR	(40)
US_Street_Post-direction	VARCHAR	(40)
US_Street_Secondary_Abbrev	VARCHAR	(40)
US_Street_Secondary_Number	VARCHAR	(40)
US_Urbanization_(PR)	VARCHAR	(100)
US_Carrier_Route	VARCHAR	(40)
US_PMB_Designator	VARCHAR	(40)
US_PMB_Number	VARCHAR	(40)
US_Deliv_Pt	VARCHAR	(40)
US_Deliv_Pt_Check_Digit	VARCHAR	(1)
US_LACS_Indicator	VARCHAR	(1)
US_Default_Highrise_Ind	VARCHAR	(1)
US_Early_Warning_System_Ind	VARCHAR	(1)
US_Record_Type	VARCHAR	(1)
US_Congressional_District	INTEGER
US_County_Code	INTEGER
US_County_Name	VARCHAR	(40)
US_State_FIPS	INTEGER
US_Extra_Information	VARCHAR	(100)
US_Finance_Number	VARCHAR	(6)
US_Preferred_City_Name	VARCHAR	(100)
US_Abbreviated_City_Name	VARCHAR	(100)
US_Verified_Street-Level_Address_Flag	VARCHAR	(1)
US_Result_Code	VARCHAR	(7)
US_Numeric_Result_Code	INTEGER
US_RDI_Result_Code	INTEGER
US_RDI	VARCHAR	(1)
US_DPV_Result_Code	INTEGER
US_DPV_Confirmation_Ind	VARCHAR	(1)
US_CMRA_Confirmation_Ind	VARCHAR	(1)
US_DPV_Footnote_1	VARCHAR	(2)
US_DPV_Footnote_2	VARCHAR	(2)
US_DPV_Footnote_3	VARCHAR	(2)
US_DPV_Other_Footnotes	VARCHAR	(10)
US_DPV_False_Positive_Ind	VARCHAR	(1)
US_LACSLink_Result_Code	INTEGER
USLACSLink_Indicator	VARCHAR	(1)
US_LACSLink_Return_Code	VARCHAR	(2)
US_Data_Date	DATETIME
US_DPV_Data_Date	DATETIME
US_LACSLink_Data_Date	DATETIME
Canada_Result_Code	INTEGER
Canada_Civic_Number	VARCHAR	(40)
Canada_Civic_Number_Suffix	VARCHAR	(40)
Canada_Street_Name	VARCHAR	(40)
Canada_Street_Type	VARCHAR	(40)
Canada_Street_Direction	VARCHAR	(40)
Canada_Unit_Type	VARCHAR	(40)
Canada_Unit_Number	VARCHAR	(40)
Canada_Deliv_Mode_Type	VARCHAR	(40)
Canada_Deliv_Mode_Number	VARCHAR	(40)
Canada_Deliv_Inst_Area	VARCHAR	(40)
Canada_Deliv_Inst_Type	VARCHAR	(40)
Canada_Deliv_Inst_Qualifier	VARCHAR	(40)

Canadian Address Verification

Reference information for the Canadian implementation of address verification covers the following topics:

Canada Street Type
Canada Street Directions
Canada Unit Designators
Non-Standard Canada Unit Designators

Canada Street Type

The following table displays the Street Type and Symbol for Canadian addresses.

Street Type	Symbol
Abbey	ABBEY
Acres	ACRES
Allée	ALLÉE
Alley	ALLEY
Autoroute	AUT
Avenue (English)	AVE
Avenue (French)	AV
Bay	BAY
Beach	BEACH
Bend	BEND
Boulevard (English)	BLVD
Boulevard (French)	BOUL
By-pass	BYPASS
Byway	BYWAY
Campus	CAMPUS
Cape	CAPE
Carré	CAR
Carrefour	Carref
Centre (English)	CTR
Centre (French)	C
Cercle	CERCLE
Chase	CHASE
Chemin	CH
Circle	CIR
Circuit	CIRCT
Close	CLOSE
Common	COMMON
Concession	CONC
Corners	CRNRS
Côte	CÔTE
Cour	COUR
Cours	COURS
Court	CRT
Cove	COVE
Crescent	CRES
Croissant	CROIS
Crossing	CROSS
Cul-de-sac	CDS
Dale	DALE
Dell	DELL
Diversion	DIVERS
Downs	DOWNS
Drive	DR
Échangeur	ÉCH
End	END
Esplanade	ESPL
Estates	ESTATE
Expressway	EXPY
Extension	EXTEN
Farm	FARM
Field	FIELD
Forest	FOREST
Freeway	FWY
Front	FRONT
Gardens	GDNS
Gate	GATE
Glade	GLADE
Glen	GLEN
Green	GREEN
Grounds	GRNDS
Grove	GROVE
Harbour	HARBR
Heath	HEATH
Heights	HTS
Highlands	HGHLDS
Highway	HWY
Hill	HILL
Hollow	HOLLOW
Île	ÎLE
Impasse	IMP
Inlet	INLET
Island	ISLAND
Key	KEY
Knoll	KNOLL
Landing	LANDNG
Lane	LANE
Limits	LMTS
Line	LINE
Link	LINK
Lookout	LKOUT
Loop	LOOP
Mall	MALL
Manor	MANOR
Maze	MAZE
Meadow	MEADOW
Mews	MEWS
Montée	MONTÉE
Moor	MOOR
Mount	MOUNT
Mountain	MTN
Orchard	ORCH
Parade	PARADE
Parc	PARC
Park	PK
Parkway	PKY
Passage	PASS
Path	PATH
Pathway	PTWAY
Pines	PINES
Place (English)	PL
Place (French)	PLACE
Plateau	PLAT
Plaza	PLAZA
Point	PT
Pointe	POINTE
Port	PORT
Private	PVT
Promenade	PROM
Quai	QUAI
Quay	QUAY
Ramp	RAMP
Rang	RANG
Range	RG
Ridge	RIDGE
Rise	RISE
Road	RD
Rond-point	RDPT
Route	RTE
Row	ROW
Rue	RE
Ruelle	RLE
Run	RUN
Sentier	SENT
Square	SQ
Street	ST
Subdivision	SUBDIV
Terrace	TERR
Terrasse	TSSE
Thicket	THICK
Towers	TOWERS
Townline	TLINE
Trail	TRAIL
Turnabout	TRNABT
Vale	VALE
Via	VIA
View	VIEW
Village	VILLGE
Villas	VILLAS
Vista	VISTA
Voie	VOIE
Walk	WALK
Way	WAY
Wharf	WHARF
Wood	WOOD
Wynd	WYND

Canada Street Directions

The following tables display the Street Direction and Symbol for English and French Canada addresses.

English

Direction	Symbol
East	E
North	N
Northeast	NE
Northwest	NW
South	S
Southeast	SE
Southwest	SW
West	W

French

Direction	Symbol
Est	E
Nord	N
Nord-est	NE
Nord-ouest	NO
Sud	S
Sud-est	SE
Sud-ouest	SO
Ouest	O

Canada Unit Designators

The following tables display the Unit Designators and Symbols for English and French Canada addresses.

English

Unit	Symbol
Apartment	APT
Suite	SUITE
Unit	UNIT

French

Unit	Symbol
Appartement	APP
Bureau	BUREAU
Unité	UNITÉ

Non-Standard Canada Unit Designators

The following tables display English and French Non-Standard Unit Designators and Symbols for Canadian addresses.

Note Note: These unit designators are no longer a part of the documentation for Canada Post but continue to be accepted.

English

Unit	Symbol
Back	BACK
Basement	BSMT
Floor	FLR
Front	FRNT
Lobby	LBBY
Penthouse	PH
Rear	REAR
Room	RM
Side	SIDE
Station	STN
Upper	UPPR

French

Unit	Symbol
étage	ÉTAGE
Logement	LOG
pièce	PIÈCE
Porte	PORTE
Rez-de-chaussé	RC
Salle	SALLE
Sous-sol	SS

Troubleshooting

This Help file contains information about troubleshooting in the Address Verification (US/Canada) node.

Performance seems slow when I am running a job including the Address Verification node.

Here are a few things you can do to try to increase Address Verification performance:

Make sure you have the primary key correctly defined and indexed in the data source
Cache a large amount of USPS data by changing the USPS Cache setting. Click Tools > Options. Select the Step Specific tab. Under the Address Verification section, change the Percentage of cached USPS data indexes setting.
Output to a delimited text file instead of updating the source.
If you are using DataFlux Data Management Studio to run the job, you can modify the commit level to every 5000 rows.
Load the entire USPS data (required more RAM on your machine).

Error Messages

The following errors appear when you select an unlicensed component for address verification:

Address Verification (US/Canada) -- Error Messages
Error Message	Description
11	DPV product is locked.
12	RDI product is locked.
13	LACSLink product is locked.

In the Address Verification node, the following error message appears when DPV and LACS is disabled and you select Generate PS Form 3553:

To generate Form 3553, you must have DPV and LACS processing enabled. DPV and LACS processing can be enabled for this node using the options on this dialog, or globally via the DataFlux Data Management Studio Options menu item. Continue anyway?

Beginning in Summer 2007, the USPS requires DPV and LACS processing for all CASS certification processes. To enable DPV and LACS from the main menu, click Tools > Options and select Step Specific. Select Enable DPV and Enable LACS.