SSIS:Personator World:Address

← SSIS:Data Quality Components

The Address tab allows you to map your address input fields. At least one Address Line and the country is required.

You can also map your output fields.

Input Columns

Company

The company/organization name.

Address Line 1

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Address Line 2

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Address Line 3

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Address Line 4

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Address Line 5

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Address Line 6

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Address Line 7

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Address Line 8

The input field for the address. This should contain the delivery address information (house number, thoroughfare, building, suite, etc.) but should not contain locality information (locality, administrative area, postal code, etc.) which have their own inputs.

Locality

The most common population center data element.

US Term: City

Canada Term: Municipality

Administrative Area

The most common geographic data element.

US Term: State

Canada Term: Province

Postal Code

The complete postal code for a particular delivery point.

If all three elements are provided and the PostalCode is incorrect, it can be corrected from the data on the Locality and AdministrativeArea.

Country

The country name, abbreviation, or code.

If Country field is not specified or is empty, use country

The country name, abbreviation, or code to use if the Country field is empty.

Address Options

Output Script

This is the script type used for all applicable fields.

Country of Origin

This is used to determine whether or not to include the country name as the last line in FormattedAddress.

Line Separator

This is the line separator used for the Formatted Address result.

Delivery Lines

This options allows you to specify if the Address Lines 1-8 should contain just the delivery address or the entire address.

Output Columns

Organization

Matches the Company input element. It is not modified or populated by the service.

Address Line 1

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 2

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 3

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 4

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 5

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 6

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 7

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 8

This will return the standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Country Name

The standardized contents of the Country Name element.

Latitude

The parsed Latitude element from the input.

Longitude

The parsed Longitude element from the input.

Dependent Locality

The standardized contents of the Dependent Locality element.

Locality

The standardized contents of the Locality element.

Administrative Area

The standardized contents of the Administrative Area element.

Postal Code

The standardized contents of the Postal Code element.

Formatted Address

The address in the correct format for mailing from the country specified in the Country Of Origin element. This includes the Organization as the first line, one or more lines in the origin country’s format, and the destination country (if required). Separate lines will be delimited by what is specified in the option.

Address Type

A one-character code for the type of address coded. This element works only for US and Canadian addresses.

Address Key

A unique key for the address. Only for US and Canadian addresses.

The AddressKey can be used by other Melissa services, such as Geocoder or RBDI.

ISO 3166-1 Country Code

Country Code

The parsed CountryCode element from the input.

For example:

Country	Code
United States	US
Canada	CA
Philippines	PH

Country ISO3

The parsed CountryISO3 element from the input.

For example:

Country	Code
United States	USA
Canada	CAN
Philippines	PHL

Country Number

The parsed CountryNumber element from the input.

For example:

Country	Code
United States	840
Canada	124
Philippines	608

Country Subdivision Code

The ISO3166-2 code for country subdivisions, usually the administrative area for a country. The format is the 2 letter country code followed by a dash followed by 2 or 3 characters or two numbers. Examples are: US-CA, CN-16, or AU-VIC.

Currently, this field is only populated for some countries. These countries are: AU, BR, CA, CN, CR, DM, GT, HN, NI, MX, SV, US.

Additional Output Columns

Parsed Dependent Thoroughfare Columns

Thoroughfare

This is used when there are more than one thoroughfares with the same name in one locality. An adjoining thoroughfare is used to uniquely identify the target thoroughfare.

US Term: Dependent street or block data element.

Pre-Direction

Cardinal directional at the beginning of the dependent thoroughfare. The prefix directional is parsed from the Dependent Thoroughfare element. For example, if the dependent thoroughfare is "W Hickory Ln," the dependent thoroughfare pre direction would be "W."

Leading Type

Thoroughfare type at the beginning of the dependent thoroughfare. The leading type is parsed from the Dependent Thoroughfare element. For example, if the dependent thoroughfare is "St. Hickory E," the dependent thoroughfare leading type would be "St."

Name

Dependent thoroughfare name parsed from the Dependent Thoroughfare element. For example, if the dependent thoroughfare is "E Hickory Ln," the dependent thoroughfare name would be "Hickory."

Trailing Type

Thoroughfare type at the end of the dependent thoroughfare. The trailing type is parsed from the Dependent Thoroughfare element. For example, if the dependent thoroughfare is "W Hickory Ln," the dependent thoroughfare trailing type would be "Ln."

Post-Direction

Cardinal directional at the end of the dependent thoroughfare. The postfix directional is parsed from the Dependent Thoroughfare element. For example, if the dependent thoroughfare is "Hickory Ln N," the dependent thoroughfare post direction would be "N."

Parsed Regional Columns

Double-Dependent Locality

A double dependent locality is a logical area unit that is smaller than a dependent locality but bigger than a thoroughfare. This field is very rarely used. Great Britain is an example of a country that uses double dependent locality.

Sub-Administrative Area

This is a logical area that that is smaller than the administrative area but larger than a locality. While many countries can have a sub-administrative area value, it is very rarely used as part of an official address.

US Term: County

Sub-National Area

A sub-national area is a logical area unit that is larger than an administrative area but smaller than the country itself. It is extremely rarely used.

Parsed Postal Facility Columns

Post Box

Post box information for a particular delivery point.

Parsed Thoroughfare Columns

Premises Type

The parsed Premises Type element from the output.

Thoroughfare

The parsed Thoroughfare element from the output. This value is a part of the address lines and contains all the sub-elements of the thoroughfare like trailing type, thoroughfare name, pre direction, post direction, etc.

US Term: Street

Pre-Direction

The parsed Thoroughfare Pre-Direction element from the output. This value is a part of the Thoroughfare field.

US Term: Pre Direction

Leading Type

The parsed Thoroughfare Leading Type element from the output. A leading type is a thoroughfare type that is placed before the thoroughfare. This value is a part of the Thoroughfare field. For example, the thoroughfare type of "Rue" in Canada and France is placed before the thoroughfare, making it a leading type.

Premises Number

The parsed Premises Number element from the output.

US Term: House Number

Name

The parsed Thoroughfare Name element from the output. This value is a part of the Thoroughfare field.

US Term: Street name

Trailing Type

The parsed Thoroughfare Trailing Type element from the output. A trailing type is a thoroughfare type that is placed after the thoroughfare. This value is a part of the Thoroughfare field. For example, the thoroughfare type of "Avenue" in the US is placed after the thoroughfare, making it a trailing type.

US Term: Street Suffix

Post-Direction

The parsed Thoroughfare Post-Direction element from the output. This value is a part of the Thoroughfare field.

US Term: Post Direction

Parsed Sub-Premises Columns

Building

Descriptive name identifying an individual location.

Sub Premises

Alphanumeric code identifying an individual location.

US Term: Suite

Sub-Premises Type

The parsed Sub-Premises Type element from the output.

US Term: Suite Name

Sub-Premises Number

The parsed SubPremisesNumber element from the output.

US Term: Suite Number