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

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

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: 

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.


Related Topics

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

Doc ID: dfU_PFEnrich_AddrVerUSCan_DataTRef.html