DataFlux Data Management Studio 2.6: User Guide
The following reference materials are available for Address Verification (US/Canada):
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) |
Reference information for the Canadian implementation of address verification covers the following topics:
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 |
The following tables display the Street Direction and Symbol for English and French Canada addresses.
Direction | Symbol |
---|---|
East | E |
North | N |
Northeast | NE |
Northwest | NW |
South | S |
Southeast | SE |
Southwest | SW |
West | W |
Direction | Symbol |
---|---|
Est | E |
Nord | N |
Nord-est | NE |
Nord-ouest | NO |
Sud | S |
Sud-est | SE |
Sud-ouest | SO |
Ouest | O |
The following tables display the Unit Designators and Symbols for English and French Canada addresses.
Unit | Symbol |
---|---|
Apartment | APT |
Suite | SUITE |
Unit | UNIT |
Unit | Symbol |
---|---|
Appartement | APP |
Bureau | BUREAU |
Unité | UNITÉ |
The following tables display English and French Non-Standard Unit Designators and Symbols for Canadian addresses.
Note: These unit designators are no longer a part of the documentation for Canada Post but continue to be accepted.
Unit | Symbol |
---|---|
Back | BACK |
Basement | BSMT |
Floor | FLR |
Front | FRNT |
Lobby | LBBY |
Penthouse | PH |
Rear | REAR |
Room | RM |
Side | SIDE |
Station | STN |
Upper | UPPR |
Unit | Symbol |
---|---|
étage | ÉTAGE |
Logement | LOG |
pièce | PIÈCE |
Porte | PORTE |
Rez-de-chaussé | RC |
Salle | SALLE |
Sous-sol | SS |
This Help file contains information about troubleshooting in the Address Verification (US/Canada) node.
Here are a few things you can do to try to increase Address Verification performance:
The following errors appear when you select an unlicensed component for address verification:
Error Message | Description |
---|---|
11 | DPV product is locked. |
12 | RDI product is locked. |
13 | LACSLink product is locked. |
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.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_PFEnrich_AddrVerUSCan_DataTRef.html |