DataFlux Data Management Studio 2.6: User Guide
The following data types are available in the Canadian Postal Code Lookup node.
Canada Street Name - This type indicates the parsed address street name.
Canada Street Type - This data type indicates the parsed address street type, such as drive, street, road, and more.
Canada Street Direction - This type indicates the parsed address street directional information, such as South, Southwest, Northwest, and so on.
Starting Street Number - The first street number in the range of addresses.
Starting Street Number Suffix - This is the street type, for example, ST, AVE, or BLVD.
Starting Street Number Box - If the range returned is for PO Boxes, this will specify the first box in the range.
Ending Street Number - The last street number in the range of addresses.
Ending Street Number Suffix - This is the street type, for example, ST, AVE, or BLVD.
Ending Street Number Box - If the range returned is for PO Boxes, this will specify the last box in the range.
City - The city name.
Province - The Canadian province name.
Postal Code - The postal code used with the address.
Country - This is the country related to the address.
Odd Even Flag - Specifies if the address range is for ODD or EVEN addresses. It can be empty if the range includes both or if the range does not include street addresses.
Address Type - This type indicates the address type. The following table lists the possible values:
Result Code | Description |
---|---|
1 | STREET ADDRESS |
2 | STREET SERVED BY ROUTE |
3 | LOCK BOX |
4 | ROUTE SERVICE |
5 | GENERAL DELIVERY |
Canada Deliv Mode Type - This type indicates the delivery type. The following table lists the possible values:
Result Code | Description |
---|---|
RR | RURAL ROUTE |
SS | SUBURBAN SERVICE |
MR | MOBILE ROUTE |
PO | PO BOX |
GD | GENERAL DELIVERY |
Canada Deliv Mode Number - 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 - The major or minor community in which the postal station is located.
Canada Deliv Inst Qualifier - In a single station community this is always Main or Bureau-chef, but in a multi-station community it will indicate the depot name.
Canada Deliv Inst Type - PO Boxes, General Delivery, and Rural Routes are often followed by Delivery Installation information. The following table lists the possible values:
Result Code | Description |
---|---|
PO | Post Office RPO BA |
BDP | Bureau De Poste |
STN | Station |
SUCC | Succursale |
CSP | Comptoir Service Postal |
LCD | Letter Carrier Depot |
Poste Des Facteurs | |
RPO | Retail Postal Outlet |
BA | Bureau Auxilliaire |
Starting Suite Number - The Starting Suite Number represents the first number in a range of possible suite numbers.
Ending Suite Number - The Ending Suite Number represents the last number in a range of possible suite numbers.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_PFEnrich_CAPostCode_Data.html |