SSIS:Global Verify:Address - Revision history

Admin at 01:45, 29 November 2022

2022-11-29T01:45:10Z

← Older revision		Revision as of 01:45, 29 November 2022
Line 166:		Line 166:
	::This is the ISO3166-2 code for country subdivisions, usually tied to 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.		::This is the ISO3166-2 code for country subdivisions, usually tied to 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: AE, AU, BB, BE,BH, BR, BS, CA, CN, CO, CR, DK, ES, FI, FR, DM, GH, GT, GY, HK, HN, IL, IN, IS, IT, KW, LU, MY, NI, NO~~, NG~~, NZ, MX, PH, PK, PT, SA, SG, SV, TH, US, UY.		::Currently, this field is only populated for some countries. These countries are: AE, AR, AT, AU, BB, BE, BH, BR, BS, CA, CH, CL, CN, CO, CR, DE, DK, DM, DO, ES, FI, FJ, FR, GB, GH, GT, GY, HN, ID, IE, IL, IN, IS, IT, JP, KR, KW, LT, LU, LV, MX, MY, NC, NG, NI, NL, NO, NZ, PE, PH, PK, PL, PR, PT, RS, SA, SG, SI, SV, TH, TR, UA, US, UY, VN.

	::'''Disclaimer''' - On-Premise does not support this field and will return empty.		::'''Disclaimer''' - On-Premise does not support this field and will return empty.

Admin at 00:35, 11 October 2022

2022-10-11T00:35:42Z

← Older revision		Revision as of 00:35, 11 October 2022
Line 4:		Line 4:

	{{CustomTOC}}		{{CustomTOC}}

			==Advisory - Global Verify Address On Premise - 32bit mdGlobalAddr.dll deprecation==
			The Global Address Object 32bit <code>mdGlobalAddr.dll</code> file will be '''deprecated''' on '''April 24th 2023'''. SSIS Global Verify Address On Premise users will be directly affected and will not be able to continue using SSIS Global Verify Address On Premise option. For more information, please visit [[SSIS:Advisory:Global Address Object 32bit dll Deprecation\|SSIS Global Verify Address On Premise Users – Global Address Object 32bit dll Deprecation]].


	[[File:SSIS_GV_Address1.png\|link=]]		[[File:SSIS_GV_Address1.png\|link=]]

Admin at 00:26, 8 January 2021

2021-01-08T00:26:41Z

← Older revision		Revision as of 00:26, 8 January 2021
Line 245:		Line 245:

	:;MelissaAddressKey		:;MelissaAddressKey
	::This is a globally unique and persistent key for the location, even if parts of the address change. When an address is fully validated this field returns a 10-digit proprietary key for the address. With AddressKey (US and Canada only), if an address zip code changes, the AddressKey would also change. Melissa Address Key (MAK) is independent and will not change. This makes MAK a good way to permanently identify and locate addresses. Once you have a MAK it can be used as an input in most Melissa services and thus is a good tool for deduping. Currently available for US, CA, GB, IT, SI, and PT with many more countries planned for the future.		::This is a globally unique and persistent key for the location, even if parts of the address change. When an address is fully validated this field returns a 10-digit proprietary key for the address. With AddressKey (US and Canada only), if an address zip code changes, the AddressKey would also change. Melissa Address Key (MAK) is independent and will not change. This makes MAK a good way to permanently identify and locate addresses. Once you have a MAK it can be used as an input in most Melissa services and thus is a good tool for deduping. Currently available for US, CA, GB, IT, SI, PT, FR, AU, SG, NL, VN, BM, and TR with many more countries planned for the future.

	:;MelissaAddressKeyBase		:;MelissaAddressKeyBase

Admin at 21:43, 23 November 2020

2020-11-23T21:43:11Z

Show changes

Admin at 21:44, 23 January 2018

2018-01-23T21:44:29Z

← Older revision		Revision as of 21:44, 23 January 2018
Line 133:		Line 133:
	;Numeric		;Numeric
	:Numeric code of the output country. Ex: For United States; Canada; and the Philippines: 840; 124; 608.		:Numeric code of the output country. Ex: For United States; Canada; and the Philippines: 840; 124; 608.

			;Country Subdivision Code
			:This is the ISO3166-2 code for country subdivisions, usually tied to 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: AE, AU, BB, BE,BH, BR, BS, CA, CN, CO, CR, DK, ES, FI, FR, DM, GH, GT, GY, HK, HN, IL, IN, IS, IT, KW, LU, MY, NI, NO, NG, NZ, MX, PH, PK, PT, SA, SG, SV, TH, US, UY.

			:'''Disclaimer''' - On-Premise does not support this field and will return empty.

Admin at 20:51, 13 August 2015

2015-08-13T20:51:07Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; SSIS Reference]]
+{{SSISGlobalVerifyNav
+|GlobalVerifyCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}
 {{CustomTOC}}

Admin at 23:37, 17 October 2014

2014-10-17T23:37:34Z

← Older revision		Revision as of 23:37, 17 October 2014
Line 55:		Line 55:

	==Input Columns==		==Input Columns==
	~~==Global Address Input Fields==~~
	;Organization		;Organization
	:The name of any organization associated with the address record.		:The name of any organization associated with the address record.
Line 130:		Line 129:


			[[File:SSIS_GV_Address2.png\|link=]]
	==Output Columns==		==Output Columns==
	;Organization		;Organization
Line 180:		Line 180:


			[[File:SSIS_GV_Address3.png\|link=]]
	==Additional Output Columns==		==Additional Output Columns==
	===Parsed Dependent Thoroughfare Columns===		===Parsed Dependent Thoroughfare Columns===

Admin: Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

2014-10-17T23:36:07Z

Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

New page

[[SSIS:Reference|← SSIS Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Global Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Global Verify|Overview]]
|-
|[[SSIS:Global Verify Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:Global Verify:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Global Verify Tabs
|-
|[[SSIS:Global Verify:Name|Name]]
|-
|[[SSIS:Global Verify:Address|Address]]
|-
|[[SSIS:Global Verify:Phone|Phone]]
|-
|[[SSIS:Global Verify:Email|Email]]
|-
|[[SSIS:Global Verify:Pass-Through Columns|Pass-Through Columns]]
|-
|[[SSIS:Global Verify:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

[[File:SSIS_GV_Address1.png|link=]]

Map the address input and output fields. Navigate between pages 1 to 3 by using the '''Next''' and '''Back''' buttons on the bottom of the window.

==Input Columns==
==Global Address Input Fields==
;Organization
:The name of any organization associated with the address record.

;Address Line 1-8 (Address Line 1 Required)
:Input fields for the address. 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.
:At least one Address Line is required.

;Double-Dependent Locality
:The smallest population center data element. Depends on the Locality and Dependent Locality elements.

;Dependent Locality
:A smaller population center data element. Depends on the Locality element.
:US Term: Urbanization.
:In terms of US Addresses, this element applies only to Puerto Rican addresses. It is used to break ties when a ZIP Code is linked to multiple instances of the same address.

;Locality (Required)
:The most common population center data element.
:US Term: City.
:Canadian Term: Municipality.
:[[#Note 1|See Note 1]].

;Sub-Administrative Area
:The smallest geographic data element.
:US Term: County.

;Administrative Area (Required)
:The most common geographic data element.
:US Term: State.
:Canadian Term: Province.
:[[#Note 1|See Note 1]].

;Sub-National Area
:The administrative region within a country on an arbitrary level below that of the sovereign state.

;Postal Code (Required)
:The complete postal code for a particular delivery point.
:US Term: ZIP.
:Canadian Term: Postcode.
:[[#Note 1|See Note 1]].

;Country (Required)
:The country name, abbreviation, or code.

;If Country field is not specified or is empty, use country
:If the Country field is not specified or empty, select a country in the drop-down menu to use.

===Note 1===
For US and Canada Only:
You must set either Locality and Administrative Area or Postal Code. If all three elements are provided and the Postal Code is incorrect, it can be corrected from the data on the Locality and Administrative Area.

==Address Options==
;Country of Origin
:This is used to determine whether or not to include the country name as the last line in Formatted Address
:*Acceptable Value: Any valid ISO-3166-1 Alpha-2, ISO-3166-1 Alpha-3, or ISO-3166-1 Numeric code.
:*If blank, invalid, or the same as the destination country, then the destination country is not appended to the end of the formatted address.
:*If valid and different from the destination country, then the destination country is appended to the formatted address.
:*US or US Territory:
::#If Country of Origin and destination country being verified are both US or US Territories then the country will not be appended to Formatted Address.
::#US Territories will have “Unite States of America” appended if the Country of Origin is not a US Territory, but the Country Name and ISO codes will be that of the territory.
::#Canada is treated like any other non-US Territory.

;Output Script
:The character set to use to format the output data.
:*Match Input: Return the output in the same script used in the input.
:*Latin: Convert all output to the latin character set.

;Line Separator
:The delimiter to use to separate multiple lines in the data returned by Formatted Address.

;Delivery Lines
:Select the addressing style that best describes the type of data that you would like to output.

==Output Columns==
;Organization
:Matches the organization input field. It is not modified or populated by Global Verify Component.

;Address Line 1-8
: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
:The country name, abbreviation, or code.

;Latitude (US and Canada Only)
:This is parsed from the input.

;Longitude (US and Canada Only)
:This is parsed from the input.

;Dependent Locality
:A district, area, or neighborhood (Turkey) within a Locality required to uniquely identify an address.

;Locality
:A city (US), town, or municipality (Canada) that is the most common population center element within an Administrative Area.

;Administrative Area
:A state (US), province (Canada), or canton (Switzerland) contained within a Country.

;Postal Code
:The postal code or ZIP code (US) for the input address.

;Formatted Address
:The address in the correct format for mailing from the country specified. This includes the Organization as the first line, one or more lines in the origin country’s format, and the destination country (if required).

;Address Type (US and Canada Only)
:Returns a one-character code for the type of address coded.
:For a complete list of these codes, see [[Result Codes#US Address Type|Address Type Codes]].

;Address Key (US and Canada Only)
:This is a unique key for the address.
:The Address Key can be used by other Melissa Data services, such as Geocoder or Delivery Indicator.

===ISO 3166-1 Country Code===
;Alpha-2
:Letter code of the output country. Ex: For United States; Canada; and the Philippines: US; CA; PH.

;Alpha-3
:Letter code of the output country. Ex: For United States; Canada; and the Philippines: USA; CAN; PHL.

;Numeric
:Numeric code of the output country. Ex: For United States; Canada; and the Philippines: 840; 124; 608.

==Additional Output Columns==
===Parsed Dependent Thoroughfare Columns===
;Thoroughfare
:Name of the street or block data element.

;Pre-Direction
:Prefix directional contained within the Thoroughfare field.

;Leading Type
:Leading thoroughfare type indicator within the Thoroughfare field.

;Name
:Name indicator within the Thoroughfare field.

;Trailing Type
:Trailing thoroughfare type indicator within the Thoroughfare field.

;Post-Direction
:Postfix directional contained within the Thoroughfare field.

===Parsed Regional Columns===
;Double-Dependent Locality
:An area or village (UK) within a Dependent Locality required to uniquely identify an address.

;Sub-Administrative Area
:Not commonly used. An arbitrary region smaller than a Country but larger than an Administrative Area.

;Sub-National Area
:A county (US) or region larger than the Locality but smaller than the Administrative Area.

===Parsed Postal Facility Columns===
;Post Box
:Post box information for a particular delivery point.

===Parsed Thoroughfare Columns===
;Premises Type
:Leading premise type indicator within premises field.

;Thoroughfare
:Name of the street or block data element.

;Pre-Direction
:Prefix directional contained within the Thoroughfare field.

;Leading Type
:Leading thoroughfare type indicator within the Thoroughfare field.

;Premises Number
:Alphanumeric indicator within premises field.

;Name
:Name indicator within the Thoroughfare field.

;Trailing Type
:Trailing thoroughfare type indicator within the Thoroughfare field.

;Post-Direction
:Postfix directional contained within the Thoroughfare field.

===Parsed Sub-Premises Columns===
;Building
:Descriptive name identifying an individual location.

;Sub Premises
:Alphanumeric code identifying an individual location.

;Sub-Premises Type
:Sub premises type indicator within the premises field.

;Sub-Premises Number
:Sub premises number indicator within the premises field.

[[Category:SSIS]]
[[Category:SSIS Global Verify]]