SSIS:Personator World:Phone

← SSIS:Data Quality Components

The Phone tab allows you to verify a phone number as valid and append geographic information for the wire center. You can also designate a line type (land line, cell, or VOIP) and phone type (business, residential, or home office).

Input Columns

Phone Number

The phone number to be verified.

Country

The country name, abbreviation, or code.

If the above Country field is empty, use country

Select the country to use if the country field is blank.

Select the Country from which dialing is done

Select the origin country from which the dialing will occur.

Phone Number Verification Options

Premium Mode

Validates against a database of known phone numbers. If a number was last real-time validated more than 30 days ago, then a real-time check will be performed.

Express Mode

Quickly validate against a database of known phone numbers.

Default Calling Code

Set the default calling code to use when the country could not be detected from the phone number or country input.

Time To Wait

Set how long the service takes (in seconds) to query a phone number for Premium or Caller ID before it times out.

Caller ID

When checked this returns the name or association linked to the phone number at the time of registration, if available.

Output Columns

Phone Number

The standardized phone number after a successful call to the service.

Phone Subscriber Number

The subscriber number associated with the phone number passed in.

Country Name

The name of the country for the inputted phone number.

Phone Country Dialing Code

A digit, or combination of digits, known as the country dialing code.

This will return the digit(s) 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, known as the national prefix.

The national prefix 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, known as the national destination code.

The national destination code that identifies a numbering area within a country (or group of countries) and/or network/services.

Locality

The locality (city) associated with the phone number passed to the Lookup function.

Because of phone portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Administrative Area

The administrative area associated with the inputted phone number.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Language

The predominant language of the phone’s detected geographical location.

The field will return the written out form of the language name. For example: "French".

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

UTC

The universal time code for the time zone associated with the inputted phone number.

UTC returns the time zone specified with the format: +/- hh:mm.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

DST

Daylight Savings Time. This returns a ‘Y’ (for yes) or ‘N’ (for no) to distinguish whether the region of the inputted phone number observes daylight savings time.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Latitude

The latitude of the geographically identifiable service area of the exchange.

Latitude is 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.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Longitude

The longitude of the geographically identifiable service area of the exchange.

Longitude is 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.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Carrier

The name of the phone’s carrier.

Country Abbreviation

The abbreviation of the country for the inputted phone number.

International Phone Number

The number you would dial, given your output fields, in order to successfully send a call.

Postal Code

The zip code that corresponds to a locality inside the United States.

Caller ID

From the CallerID service, which appends a name to the targeted phone number.