Difference between revisions of "SSIS:Global Verify:Phone"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa...")
 
Line 1: Line 1:
[[SSIS:Reference|← 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;"
}}
! 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}}
{{CustomTOC}}

Revision as of 20:51, 13 August 2015

← SSIS:Data Quality Components

Global Verify Navigation
Overview
Tutorial
Advanced Configuration
Melissa Data Cloud
On-Premise
Global Verify Tabs
Name
Address
Phone
Email
Pass-Through Columns
Output Filter
Result Codes
Returned Result Codes
Result Codes



SSIS GV Phone.png

Verify a phone number as valid and append geographic information for the wire center.

Input Columns

Phone Number
The phone number for the input column.
Country
The country name or code associated with the input phone number.
If the above Country field is empty, use country
Use this if no Country field is specified or a record's country field is blank.
Select the Country from which dialing is done
Specify the Country the dialing is done from.


Output Columns

Phone Number
The standardized output phone number.
Phone Subscriber Number
The subscriber number associated with the inputted phone number. The subscriber number contains significant leading digits that further define the local exchange area and/or service.
County Name
The name of the country for the inputted phone number.
Phone Country Dialing Code
A digit, or combination of digits dialed after the international prefix.
International Prefix
The international exit code needed to call a number outside of the dialing country. If the input country and country of origin differ, this will return the digit(s) required to be dialed before the country code.
National Prefix
A digit, or combination of digits that must be dialed before an area (city) code when calling a number within the same country but outside the numbering area.
National Destination Code
A digit, or combination of digits that identifies a numbering area within a country (or group of countries) and/or network/services.
Locality
City. The locality associated with the inputted phone number.
Administrative Area
State. The administrative area associated with the inputted phone number.
Language
The predominant language of the phone’s detected geographical location.
UTC
The universal time code for the time zone associated with the inputted phone number. The format will be: +/- hh:mm.
DST
Daylight Savings Time. Returns a ‘Y’ (for yes) or ‘N’ (for no) to distinguish whether the region of the inputted phone number observes daylight savings time.
Latitude
The geographic coordinate of the locale, city, municipality, or other geographically identifiable service area of the exchange measured in degrees north or south of the equator.
Longitude
The geographic coordinate of the locale, city, municipality, or other geographically identifiable service area of the exchange measured in degrees east or west of the Greenwich Meridian.