SSIS:Personator:Processing Options - Revision history

Admin at 02:01, 20 January 2023

2023-01-20T02:01:04Z

← Older revision		Revision as of 02:01, 20 January 2023
Line 131:		Line 131:
	;Decennial CensusKey Option		;Decennial CensusKey Option
	:Using the drop down menu, set the preferred Census information returned, whether the latest version or the decennial version.		:Using the drop down menu, set the preferred Census information returned, whether the latest version or the decennial version.
	*<code>2020</code> - Return the 2020 static decennial census database released.		:*<code>2020</code> - Return the 2020 static decennial census database released.
	*<code>2010</code> - Return the 2010 static decennial census database released.		:*<code>2010</code> - Return the 2010 static decennial census database released.
	*<code>Off</code> - Default. Return the latest Census information available.		:*<code>Off</code> - Default. Return the latest Census information available.

Admin at 02:00, 20 January 2023

2023-01-20T02:00:12Z

← Older revision		Revision as of 02:00, 20 January 2023
Line 130:		Line 130:
	==Geo Options==		==Geo Options==
	;Decennial CensusKey Option		;Decennial CensusKey Option
	:~~When~~ the ~~option~~ <code>~~DecennialCensusKey~~</code> ~~is set to~~ <code>ON</code>~~, Personator will replace~~ the ~~output of CensusKey with Decennial~~ 2010 Census ~~data~~.		:Using the drop down menu, set the preferred Census information returned, whether the latest version or the decennial version.
			*<code>2020</code> - Return the 2020 static decennial census database released.
			*<code>2010</code> - Return the 2010 static decennial census database released.
			*<code>Off</code> - Default. Return the latest Census information available.

Admin at 00:20, 29 October 2021

2021-10-29T00:20:47Z

← Older revision		Revision as of 00:20, 29 October 2021
Line 126:		Line 126:
	;Standardize Company Name		;Standardize Company Name
	:Checked by default. If checked, the Company Name field will be returned with standard abbreviation, capitalization, and punctuation rules applied.		:Checked by default. If checked, the Company Name field will be returned with standard abbreviation, capitalization, and punctuation rules applied.


			==Geo Options==
			;Decennial CensusKey Option
			:When the option <code>DecennialCensusKey</code> is set to <code>ON</code>, Personator will replace the output of CensusKey with Decennial 2010 Census data.

Admin at 18:37, 4 June 2021

2021-06-04T18:37:58Z

← Older revision		Revision as of 18:37, 4 June 2021
Line 10:		Line 10:
	==Verify and Append Options==		==Verify and Append Options==
	===Centric Hint===		===Centric Hint===
	Used to set which piece of information to use as the primary point of reference when appending data.		Used to set which piece of information to use as the primary point of reference when verifying/appending data.

	;*Auto		;*Auto

Admin at 22:19, 10 August 2018

2018-08-10T22:19:51Z

← Older revision		Revision as of 22:19, 10 August 2018
Line 31:		Line 31:

	::Uses Email as the primary point of reference.		::Uses Email as the primary point of reference.

			;*Name

			::Uses Name as the primary point of reference – This is not included in Centric Hint '''Auto''' option.

Admin at 00:13, 21 February 2018

2018-02-21T00:13:46Z

← Older revision		Revision as of 00:13, 21 February 2018
Line 9:		Line 9:

	==Verify and Append Options==		==Verify and Append Options==
			===Centric Hint===
	Used to set which piece of information to use as the primary point of reference when appending data.		Used to set which piece of information to use as the primary point of reference when appending data.

Line 14:		Line 15:

	::(Default) First uses Address, if available, followed by Phone if no Address is available, and lastly Email if neither Address nor Email are available.		::(Default) First uses Address, if available, followed by Phone if no Address is available, and lastly Email if neither Address nor Email are available.

			;*Social Security

			::Uses Social Security number as the primary point of reference.

	;*Address		;*Address
Line 26:		Line 31:

	::Uses Email as the primary point of reference.		::Uses Email as the primary point of reference.


			;Social Security Number Cascade Option
			:Personator will attempt to match on 4 scenarios:
			:#Full Name & Full SSN
			:#Last Name & Full SSN
			:#Full Name & SSN Last 4
			:#Last Name & SSN Last 4

			:Returned Result codes will indicate the level of matching.

Admin at 23:56, 9 November 2015

2015-11-09T23:56:36Z

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

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-20T19:10:15Z

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;"|'''Personator Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Personator|Overview]]
|-
|[[SSIS:Personator Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Personator:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:Personator:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Personator Tabs
|-
|[[SSIS:Personator:Input|Input]]
|-
|[[SSIS:Personator:Actions|Actions]]
|-
|[[SSIS:Personator:Processing Options|Processing Options]]
|-
|[[SSIS:Personator:Output|Output]]
|-
|[[SSIS:Personator:Pass-Through|Pass-Through Columns]]
|-
|[[SSIS:Personator:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Personator:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

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

==Verify and Append Options==
Used to set which piece of information to use as the primary point of reference when appending data.

;*Auto

::(Default) First uses Address, if available, followed by Phone if no Address is available, and lastly Email if neither Address nor Email are available.

;*Address

::Uses Address as the primary point of reference.

;*Phone

::Uses Phone as the primary point of reference.

;*Email

::Uses Email as the primary point of reference.

==Name Options==
===Name Hint===
;*Varying

::(Default) If necessary, statistical logic will be employed to determine name order, with no bias toward either name order.

;*Definitely Full

::Name will always be treated as normal name order, regardless of formatting or punctuation.

;*Very Likely Full

::Name will be treated as normal name order unless inverse order is clearly indicated by formatting or punctuation.

;*Probably Full

::If necessary, statistical logic will be employed to determine name order, with a bias toward normal name order.

;*Probably Inverse

::If necessary, statistical logic will be employed to determine name order, with a bias toward inverse name order.

;*Very Likely Inverse

::Name will be treated as inverse name order unless normal order is clearly indicated by formatting or punctuation.

;*Definitely Inverse

::Name will always be treated as inverse name order, regardless of formatting or punctuation.

;*Mixed First Name

::Name field is expected to only contain prefixes, first, and middle names.

;*Mixed Last Name

::Name field is expected to only contain last names and suffixes.

===Middle Name Logic===
Determines the handling of middle names.

;*Parse Logic

::(Default) Middle names that are typically last names are considered to be part of a hyphenated last name.

;*Hypenated Last

::The middle word is assumed to be part of the last name. For Example: "Matthew Edward Jones" is treated as "Matthew Edward-Jones."

;*Middle Name

::The middle word is assumed to be a middle name. For example: "Matthew Svensson Jones." "Svensson" would be considered a middle name instead of part of the last name.

===Salutation Format===
Sets the salutation format for the response.

;*Formal

::(Default) Mr. Smith

;*Informal

::John

;*First Last

::John Smith

;Gender Population
:Default is Mixed. Sets the gender balance of the source data, either predominantly Male, Female, or Mixed (evenly split).

;Gender Aggression
:Default is Neutral. Sets how aggressive genderization is for neutral first names, either Neutral, Conservative, or Aggressive.

;Correct First Name
:Checked by default. If checked, allows common spelling corrections for the First Name field.

;Standardize Company Name
:Checked by default. If checked, the Company Name field will be returned with standard abbreviation, capitalization, and punctuation rules applied.

==Address Options==
;Diacritics
:Default is auto. If on, French language characters will be returned.

;Advanced Address Correction
:AAC uses the Full Name/Company Name input to perform more advanced address correction.

;USPS Preferred City
:Default is off. For every city in the United States, there is an official name that is preferred by the U.S. Postal Service. There may be one or more unofficial or “vanity” names in use. Normally, Personator Component allows you to verify addresses using known vanity names. If Preferred City is on, the preferred city name will be substituted for all vanity names when it verifies an address.

==Phone Options==
;Phone Format
:Choose one of six different available phone formats:
:*(800) 800-6245: (Default) Parenthesis with dash.
:*(800) 800 6245: Parenthesis with space.
:*800 800 6245: Spaces.
:*800-800-6245: Dashes.
:*800.800.6245: Periods.
:*8008006245: No space.

==Email Options==
;Database Look up
:Checked by default. If checked, verification of domain names will be attempted using a database of valid domains.

;Standardize Casing
:Checked by default. If checked, all letters in the Email field will be changed to lower case before any checking occurs.

;Correct Syntax
:Checked by default. If checked, the syntax of the Email field will be corrected.

;Update Domain
:Checked by default. If checked, determines whether the domain name is out of date and updates it.

[[Category:SSIS]]
[[Category:SSIS Personator]]