Contact Zone:SmartMover:Output: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
Created page with "← Contact Zone Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; c..."
 
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[Contact Zone:Reference|← Contact Zone Reference]]
{{ContactZoneSmartMoverNav
 
|SmartMoverCollapse=
{| 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;"|'''SmartMover Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Contact Zone:SmartMover|Overview]]
|-
|[[Contact Zone:SmartMover Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[Contact Zone:SmartMover:Component Settings|Component Settings]]
|-
|[[Contact Zone:SmartMover:Component Settings#Show Details (Web)|Show Details (Web)]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|SmartMover Tabs
|-
|[[Contact Zone:SmartMover:Input|Input Columns]]
|-
|[[Contact Zone:SmartMover:Output|Output Columns]]
|-
|[[Contact Zone:SmartMover:Processing Options|Processing Options]]
|-
|[[Contact Zone:SmartMover:Pass-Through|Pass-Through Columns]]
|-
|[[Contact Zone:SmartMover:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Enterprise Solutions#Contact Zone|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}
Line 101: Line 58:
;Additional Output Columns
;Additional Output Columns
:The Additional Output Columns allow you to map fields for returned data that goes beyond the standard change-of-address information.
:The Additional Output Columns allow you to map fields for returned data that goes beyond the standard change-of-address information.
==Additional Output Columns==
The Additional Output Columns button allows you to map fields for returned data that goes beyond the standard change-of-address information.
[[File:CZ_SM_OutputColumns_AdditionalOutput.png|link=]]
===Address Information===
;Suite
:Map the field that will receive the updated or standardized suite information, if any.
;Private Mailbox
:Map the field that will receive the private mailbox number. This field is populated if the primary address was identified as a Commercial Mail Receiving Agency (CMRA) and the secondary address information is present. This field would also be populated if the secondary address information contains the string "PMB," thus identifying the address as a private mailbox.
;Plus 4
:Map the field that will receive the four-digit extension from the ZIP + 4.
;Delivery Point & Check Digit
:The delivery point is a two-digit number that combined with the ZIP + 4, generates a unique number for each address in that ZIP + 4. This number is used to generate barcodes, so if you plan you use this address data for commercial mailing, it would be necessary to map an output field for this information. Typically, the Delivery Point Code will be the last two digits of the street number, but the most accurate way to obtain this information is by submitting the address for Address Verification and storing the Delivery Point code for future use.
:The delivery point check digit is an additional one-digit number that is combined with the Delivery Point when generating barcodes for mailing.
;Carrier Route
:The Carrier Route is a four-character code that indicates which mail carrier delivers to the input address. The first character of this Carrier Route is always alphabetic and the last three characters are numeric. For example, "R001" or "C027" would be typical carrier routes. The alphabetic letter indicates the type of delivery associated with this address.
::'''B''' = PO Box
::'''C''' = City Delivery
::'''G''' = General Delivery
::'''H''' = Highway Contract
::'''R''' = Rural Route
;Urbanization
:Map the field that will receive the Urbanization name, if any. See the entry for the Urbanization input field for more information on this field.
;City Abbreviation
:If the name returned by the City field is longer than 13 letters, the City Abbreviation field will return the official abbreviation the Post OfficeTM has associated with that city or municipality name. For example, the City Abbreviation field will return the abbreviation "Rcho Sta Marg" for "Rancho Santa Margarita." If the value returned by the City field is 13 letters or shorter, the City Abbreviation field will return the full city or municipality name.
;Country
:Returns the full name of the country in which the address is located. Currently, only Canada and the United States are supported, although SmartMover Web Service will only update the U.S. addresses.
;Country Abbreviation
:Returns the standard abbreviation of the country in which the address is located. Currently, only Canada and the United States are supported, although SmartMover Web Service will only update the U.S. addresses.
===Parsed Address Columns===
These fields return street address information, split into its components.
;Address Range
:This field returns the street number.
;Pre-directional
:This field returns any directional indicators that precede the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."
;Street Name
:This field returns only the street name, minus the suffixes or directionals. For "SW Main Street," this would return "Main."
;Suffix
:This field returns the standard abbreviations for the street types: "RD," "ST," "AVE," "BLVD," etc.
;Post-directional
:This field returns any directional indicators that follow the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."
;Suite Name
:This field returns the descriptive portion of the secondary address: "SUITE," "APT," "UNIT," etc.
;Suite Range
:This field returns the valid Ranges for Suites for each inputted address.
;Private Mailbox Name
:This field returns the descriptive portion of the private mailbox number. A private mailbox, or PMB, is a secondary address associated with a Commercial Mail Receiving Agency (CMRA). Because the CMRA may itself be located in a suite, such an address may have both a suite number and a PMB number.
:The name portion of the PMB will normally be either "#" or "PMB."
;Private Mailbox Range
:This field returns the valid Ranges for Private Mailboxes for each inputted address.
;Extra Information
:This field returns any text from the street address field that does not fit into one of the above categories.





Latest revision as of 20:28, 5 January 2017

← Contact Zone

SmartMover Navigation
Overview
Tutorial
Component Settings
Show Details (Web)
SmartMover Tabs
Input Columns
Output Columns
Processing Options
Pass-Through Columns
Output Filter
Result Codes



The output section consists of various sets of return fields. The first, Output Name is used to store the concatenated and or parsed Name parts of the input Name. The second set returns the new change of address data or for non-moves, standardized address information. The Additional Output Columns button enables another dialog box which can be used to store additional address info and parsed address parts.

New field names can be created by typing the name into the box.

Output Name

FullName
This field returns the standardized FullName used to look up the change of address.
Prefix
This field returns any part of the name that precedes the given name, such as "Mr.," "Ms." or "Dr.," for each full name detected.
First Name
This field returns the given name for each full name detected.
Middle Name
This field returns the middle names or initials for each full name processed.
Last Name
This field returns the family name for each full name processed.
Suffix
This field returns any part of the name that follows the family name, such as degrees ("MD" or "PhD") and generational indicators ("IV" or "Jr."), for each full name processed.
Use Input Fields For Output
Selecting this option will automatically map your input Name and Address fields as the output fields, hence overwriting the original structure with new data. Caution: selecting this option will wipe out any new Output fields you have just created.


Output Address

Company
Map the field that will receive the Company information.
Address
Map the field that will receive the updated address or standardized street address that was used for verification. This may be the contents of the Address2 input field, if address swapping has occurred.
Address2
Map the field that will receive the updated address or standardized street address that was not used for verification, if two address lines were present.
City
Map the field that will receive the city name. The information returned may be different than the contents of the City input field, if the preferred city name has been substituted for a vanity city name or if the address was coded to a different ZIP Code instead.
State/Province
Map the field that will receive the two-character state abbreviation.
Zip/Postal Code
Map the field that will receive the five-digit U.S. ZIP Code.
AddressKey
Map the field that will receive the AddressKey for the returned record. The Address Key was created by Melissa Data to uniquely identify an address and used as input to our other individual services like Geocoding.
Additional Output Columns
The Additional Output Columns allow you to map fields for returned data that goes beyond the standard change-of-address information.


Additional Output Columns

The Additional Output Columns button allows you to map fields for returned data that goes beyond the standard change-of-address information.

Address Information

Suite
Map the field that will receive the updated or standardized suite information, if any.
Private Mailbox
Map the field that will receive the private mailbox number. This field is populated if the primary address was identified as a Commercial Mail Receiving Agency (CMRA) and the secondary address information is present. This field would also be populated if the secondary address information contains the string "PMB," thus identifying the address as a private mailbox.
Plus 4
Map the field that will receive the four-digit extension from the ZIP + 4.
Delivery Point & Check Digit
The delivery point is a two-digit number that combined with the ZIP + 4, generates a unique number for each address in that ZIP + 4. This number is used to generate barcodes, so if you plan you use this address data for commercial mailing, it would be necessary to map an output field for this information. Typically, the Delivery Point Code will be the last two digits of the street number, but the most accurate way to obtain this information is by submitting the address for Address Verification and storing the Delivery Point code for future use.
The delivery point check digit is an additional one-digit number that is combined with the Delivery Point when generating barcodes for mailing.
Carrier Route
The Carrier Route is a four-character code that indicates which mail carrier delivers to the input address. The first character of this Carrier Route is always alphabetic and the last three characters are numeric. For example, "R001" or "C027" would be typical carrier routes. The alphabetic letter indicates the type of delivery associated with this address.
B = PO Box
C = City Delivery
G = General Delivery
H = Highway Contract
R = Rural Route
Urbanization
Map the field that will receive the Urbanization name, if any. See the entry for the Urbanization input field for more information on this field.
City Abbreviation
If the name returned by the City field is longer than 13 letters, the City Abbreviation field will return the official abbreviation the Post OfficeTM has associated with that city or municipality name. For example, the City Abbreviation field will return the abbreviation "Rcho Sta Marg" for "Rancho Santa Margarita." If the value returned by the City field is 13 letters or shorter, the City Abbreviation field will return the full city or municipality name.
Country
Returns the full name of the country in which the address is located. Currently, only Canada and the United States are supported, although SmartMover Web Service will only update the U.S. addresses.
Country Abbreviation
Returns the standard abbreviation of the country in which the address is located. Currently, only Canada and the United States are supported, although SmartMover Web Service will only update the U.S. addresses.

Parsed Address Columns

These fields return street address information, split into its components.

Address Range
This field returns the street number.
Pre-directional
This field returns any directional indicators that precede the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."
Street Name
This field returns only the street name, minus the suffixes or directionals. For "SW Main Street," this would return "Main."
Suffix
This field returns the standard abbreviations for the street types: "RD," "ST," "AVE," "BLVD," etc.
Post-directional
This field returns any directional indicators that follow the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."
Suite Name
This field returns the descriptive portion of the secondary address: "SUITE," "APT," "UNIT," etc.
Suite Range
This field returns the valid Ranges for Suites for each inputted address.
Private Mailbox Name
This field returns the descriptive portion of the private mailbox number. A private mailbox, or PMB, is a secondary address associated with a Commercial Mail Receiving Agency (CMRA). Because the CMRA may itself be located in a suite, such an address may have both a suite number and a PMB number.
The name portion of the PMB will normally be either "#" or "PMB."
Private Mailbox Range
This field returns the valid Ranges for Private Mailboxes for each inputted address.
Extra Information
This field returns any text from the street address field that does not fit into one of the above categories.


Move information

Effective Date
Map this field which receives the effective date (yyyymm) of a change of address.