Data Quality accelerator bundles

Back Next

Cloud Data Quality Americas bundle

You can use the rules in an out-of-the-box manner. Add one or more rules to a mapping to perform deduplication, address verification, and standardization operations on your business data.

The following table describes the Americas bundle assets:

Name	Type	Description
c_BRA_Correct_Misspellings_Name_Status	Cleanse	Standardizes misspelled names in Brazil data and adds a status value as a prefix to each standardized name.
c_BRA_Correct_Misspellings_Names	Cleanse	Corrects misspelled names in Brazil data.
c_BRA_Detect_Company_Names	Cleanse	Detects organization names in Brazil data.
c_bra_get_name_standard	Cleanse	Standardizes names in Brazil data.
c_BRA_Lbl_Lookup_Area_Code	Cleanse	Returns corresponding area names for an area code in Brazil data.
c_BRA_Lookup_Gender	Cleanse	Identifies gender of a given name in Brazil data.
c_BRA_Standardize_Company_Suffix	Cleanse	Standardizes organization names in Brazil data.
c_CAN_Get_Name_Standard	Cleanse	Replaces nicknames with standard versions of the names in Canada data.
c_dq_State_Validate	Cleanse	Validates that a given input is a valid United States state.
c_dq_Validate_County	Cleanse	Validates that a given input is a valid United States county.
c_Label_Characters	Cleanse	Assigns label "X" to a character.
c_predirectional_std	Cleanse	Standardizes postal address terms to their equivalent short forms or abbreviations.
c_Remove_Bad_Characters	Cleanse	Removes a range of non-alphanumeric characters, such as punctuation symbols.
c_SR_FullName	Cleanse	Standardizes full names.
c_SSN_Group_From_Area	Cleanse	Returns group number component in Social Security Number that corresponds to a given ZIP Code.
c_SSN_Max_Index_For_Group	Cleanse	Returns index for a group.
c_US_Company_Name_Std	Cleanse	Standardizes organization names in United States data.
c_US_FullName	Cleanse	Returns label for a full name in United States data.
c_US_Get_Company_Acronym	Cleanse	Standardizes organization acronyms in United States data.
c_US_Get_Name_Standard	Cleanse	Standardizes given names in United States Data.
c_US_Lbl_OLN1	Cleanse	Returns label for last name in United States data.
c_US_Lbl_OLN2	Cleanse	Returns label for last name in United States data.
c_US_MultiPort_ContactData	Cleanse	Converts input characters in United States data to upper case.
c_US_postdirectional_std	Cleanse	Standardizes street identifiers in United States address data.
c_US_SIC_Code_Description	Cleanse	Standardizes Standard Industrial Classification (SIC) codes in United States data.
c_USA_PostCodes	Cleanse	Validates that the input data contains a valid ZIP Code in United States data.
dq_Index_for_Group	Cleanse	Returns index for group.
c_Remove_Extra_Spaces	Cleanse	Replaces multiple consecutive character spaces with a single space, and trims any leading and trailing spaces.
c_Remove_Punctuation	Cleanse	Removes all occurrences of punctuation from the input field.
c_Remove_Space	Cleanse	Removes all occurrences of a character space from the input field.
c_replace_pipe_w_space	Cleanse	Replaces a pipe character with a single character space.
c_Std_Name	Cleanse	Standardizes name values by removing extraneous character spaces and punctuation symbols.
c_Titlecase	Cleanse	Converts input characters to title case.
c_Uppercase	Cleanse	Converts input characters to upper case.
c_US_validate_area_code_label	Cleanse	Validates and assigns label to telephone area codes in United States data.
c_Validation_Domain	Cleanse	Validates domain of an email.
c_multi_uppercase	Cleanse	Converts character case to uppercase for up to six input fields.
dedupe_BRA_CompanyName	Deduplicate	Uses organization name data to find duplicate records in Brazil data.
dedupe_BRA_Fam_Address	Deduplicate	Uses household name and address data to find duplicate records in Brazil data.
dedupe_BRA_indivdual_name_addr_match	Deduplicate	Uses person name and address data to find duplicate records in Brazil data.
dedupe_BRA_Individual_Name_and_Date	Deduplicate	Uses person name and date data to find duplicate records in Brazil data.
dedupe_BRA_Individual_Name_and_Email	Deduplicate	Uses person name and email address data to find duplicate records in Brazil data.
dedupe_BRA_Individual_Name_and_Phone	Deduplicate	Uses person name and telephone number data to find duplicate records in Brazil data.
dedupe_BRA_Match_Company_and_Address	Deduplicate	Uses organization name and address data to find duplicate records in Brazil data.
dedupe_BRA_Match_Indiv_Name_and_CPF	Deduplicate	Matches individual names and CPF for Brazil data.
dedupe_BRA_Match_Name_Personal_Data	Deduplicate	Matches personal name and data for Brazil data.
dedupe_CompanyName_Match	Deduplicate	Matches the organization name.
dedupe_US_IMO_Fam_Name_Address_Match	Deduplicate	Matches the family name and address by using Address_Part1 as key.
dedupe_US_IMO_Indiv_Name_Address_Match	Deduplicate	Matches the individual name and address by using Address Part1 as key.
dedupe_US_IMO_Match_Company_and_Address	Deduplicate	Matches the organization name and address of the United States.
dedupe_US_IMO_Personal_Name_Data_Match	Deduplicate	Matches the personal name and data.
dedupe_USA_Address_Match	Deduplicate	Matches the addresses for United States with Address Part1 as key.
bra_business_words_infa	Dictionary	Contains information about Brazilian business words.
bra_city_from_st_area_infa	Dictionary	Contains area-wise information of Brazilian cities and states.
bra_company_suffix_std_infa	Dictionary	Contains a list of Brazilian organization name suffixes.
bra_gender_infa	Dictionary	Contains a list of Brazilian names and their genders.
bra_name_designators_infa	Dictionary	Contains a list of Brazilian name designators.
bra_name_prefix_infa	Dictionary	Contains a list of Brazilian prename prefixes.
bra_name_suffix_infa	Dictionary	Contains a list of Brazilian name suffixes.
bra_names_mispelled_infa	Dictionary	Contains a list of misspelled Brazilian names.
bra_names_mispelled_stat_infa	Dictionary	Contains a list of status values for misspelled Brazilian names.
bra_nicknames_infa	Dictionary	Contains a list of Brazilian nicknames.
can_gender_infa	Dictionary	Contains a list of genders on the basis of Canadian names.
can_nicknames_infa	Dictionary	Contains a list of nicknames in Canada.
can_postcodes	Dictionary	Contains a list of Canadian postcodes.
can_prename_gender_infa	Dictionary	Contains a list of genders on the basis of Canadian prenames.
can_provinces_infa	Dictionary	Contains list of Canadian provinces.
can_tel_area_codes_infa	Dictionary	Contains a list of Canadian telephone area codes.
usa_adrs_prfx_std_s_infa	Dictionary	Contains a list of address name standard prefixes for the United States.
usa_adrs_sufx_std_s_infa	Dictionary	Contains a list of address name standard suffixes for the United States.
usa_company_acronyms_infa	Dictionary	Contains a list of organization names and their acronyms for United States.
usa_company_names_std_infa	Dictionary	Contains a list of company name standards for the United States.
usa_company_sufx_abrv_infa	Dictionary	Contains a list of abbreviations used for company suffixes.
usa_counties_infa	Dictionary	Contains a list of counties and their possible alternate names for the United States.
usa_gender_infa	Dictionary	Contains a list of gender based on names for the United States.
usa_name_frequencies_by_space	Dictionary	Contains a list of name frequencies by space for the United States.
usa_name_frequencies_infa	Dictionary	Contains a list of names with their frequencies for the United States.
usa_nicknames_infa	Dictionary	Contains a list of nicknames for the United States.
usa_prename_gender_infa	Dictionary	Associates gender on the basis of prename for the United States.
usa_postcodes	Dictionary	Captures the postcodes for the United States.
usa_sic_codes_infa	Dictionary	Contains the Standard Industrial Classification (SIC) codes for the United States.
usa_ssn_grp_from_area_infa	Dictionary	Contains Social Security Number group from an area for the United States.
usa_ssn_indx_from_grp_infa	Dictionary	Gives Social Security Number index from group code for the United States.
usa_states	Dictionary	Contains a list of states in the United States.
usa_surnames_infa	Dictionary	Contains a list of surnames in the United States.
usa_tel_area_codes_infa	Dictionary	Contains a list of telephone area codes for the United States.
domain_names_infa	Dictionary	Contains a list of domain names.
dq_av_geocodingstatus_infa	Dictionary	Contains a list of address validation status with geocoding.
dq_av_mailabilityscores_infa	Dictionary	Contains a list of 'AddressDoctor' status values, that describe the likelihood of mail delivery and a set of corresponding mailability scores in a range from 0 through 5.
dq_av_match_code_descriptions_infa	Dictionary	Contains a list of 'Match Code' output values, and identifies the process modes that return the values.
mplt_BRA_Address_Validation_Discrete	Mapplet	Validates the deliverability of Brazil addresses. Use the mapplet when you can connect the input address fields to fields on the Discrete model in the verifier asset.
mplt_BRA_Address_Validation_Discrete_w_Geo	Mapplet	Validates the deliverability of Brazil addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Discrete model in the verifier asset.
mplt_BRA_Address_Validation_Hybrid	Mapplet	Validates the deliverability of Brazil addresses. Use the mapplet when you can connect the input address fields to fields on the Hybrid model in the verifier asset.
mplt_BRA_Address_Validation_Hybrid_Geo	Mapplet	Validates the deliverability of Brazil addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Hybrid model in the verifier asset.
mplt_BRA_Address_Validation_Multiline	Mapplet	Validates the deliverability of Brazil addresses. Use the mapplet when you can connect the input address fields to fields on the Multiline model in the verifier asset.
mplt_BRA_Address_Validation_Multiline_Geo	Mapplet	Validates the deliverability of Brazil addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Multiline model in the verifier asset.
mplt_BRA_Company_Name_and_Address_Match	Mapplet	Finds duplicate rows of Brazilian company names and address data. The first three characters of the Soundex of the company name, and first three digits of the postcode group the address data.
mplt_BRA_Company_Name_MatchScore	Mapplet	Finds duplicate rows of Brazilian company name data. The first three letters of the Soundex of the company name group the data. Threshold frequency is 80%.
mplt_BRA_Company_Suffix_Standardization	Mapplet	Standardizes Brazilian company suffixes.
mplt_BRA_Contact_Data	Mapplet	Parses name, provides a gender, a prename (Mr. or Ms. if missing), and formal or casual greetings. Standardizes the Brazilian company name. Corrects, validates, and standardizes address, phone number, email, and personal ID.
mplt_BRA_Familyname_and_Address_Match	Mapplet	Finds duplicate rows of personal surname and Brazilian address data. The first two digits of postcode and surname group the data.
mplt_BRA_Gender_Assignment	Mapplet	Assigns gender based on the first name. Assigns last name if it has Junior or other similar words.
mplt_BRA_Given_Name_Standard	Mapplet	Returns standard name for common Brazilian nicknames. For example, it returns Robert for the input Bob.
mplt_BRA_IMO_Personal_Name_and_Data_Match	Mapplet	Finds duplicate individual names and personal data. The personal data field may have phone number, email, CPF, and other attributes with similar type. The personal data type is the group key. The personal data field sorts and groups all rows.
mplt_BRA_Individual_Name_and_Address_Match	Mapplet	Finds duplicate rows of personal names and address data for Brazil. The NYSIIS value of surname and first three digits of the postcode group the data.
mplt_BRA_Indvidual_Name_and_Date_Match	Mapplet	Finds duplicate rows of personal names and date data for Brazil. The threshold frequency is 80%.
mplt_BRA_Individual_Name_and_Email_Match	Mapplet	Finds duplicate rows of personal names and email data for Brazil. The NYSIIS value of surname and first three digits of postcode group the data.
mplt_BRA_Individual_Name_and_CPF_Match	Mapplet	Finds duplicate rows of personal name and CPF data for Brazil. The CPF groups the data.
mplt_BRA_Individual_Name_and_Phone_Match	Mapplet	Finds duplicate rows of personal name and phone number data for Brazil. The phone number groups the data. The threshold frequency is 80%.
mplt_BRA_Personal_CPF_Validation	Mapplet	Validates CPF number with its check digits for Brazil.
mplt_BRA_Personal_CPNJ_Validation	Mapplet	Validates CPNJ number with its check digits for Brazil.
mplt_BRA_Personal_Name_Parse_Validate	Mapplet	Parses Brazilian names input in a single field into separate components. Provides information if the spelling is correct or if the data is a potential company name.
mplt_BRA_Personal_PIS_PASEP_Validation	Mapplet	Validates the number that manages government social benefits.
mplt_BRA_Personal_Voter_Registration_Validation	Mapplet	Validates digits of the Brazilian voter registration number.
mplt_BRA_Phone_Number_Parse	Mapplet	Parses phone number that follows the standard format for Brazil from a string of texts into its own field.
mplt_BRA_Phone_Number_Standardization	Mapplet	Standardizes format of the phone string to dashes without spaces for Brazil.
mplt_BRA_Phone_Validation	Mapplet	Validates area-code and length of a phone number for Brazil.
mplt_BRA_Prename_Assignment	Mapplet	Assigns prename based on gender. Uses variable to change female prename assignment value. For example, Sra or Sta.
mplt_BRA_Salutation_Assignment	Mapplet	Generates formal and casual greeting. For example, Sr John Smith gets a formal greeting of Prezado Sr Smith and the casual greeting of Prezado John. The prefix (Prezado) and suffix (,) can be changed in dq_Generate_Salutation transform.
mplt_CAN_Address_Certification_Hybrid	Mapplet	Validates Canadian address data with input fields that map to the Hybrid model. The outputs include USA CASS Certification ports.
mplt_CAN_Address_Validation_Discrete	Mapplet	Validates the deliverability of Canada addresses. Use the mapplet when you can connect the input address fields to fields on the Discrete model in the verifier asset.
mplt_CAN_Gender_Assignment	Mapplet	Assigns a gender. For example, John Smith has M for male.
mplt_CAN_Given_Name_Standard	Mapplet	Returns standard name for common nicknames. For example, it returns Robert with Bob's input.
mplt_CAN_Personal_Name_Parsing_FML	Mapplet	Parses input names in First-Middle-Last format in discrete components.
mplt_CAN_Multi_Person_Name_Parse	Mapplet	Parses input name into proper name components for Canada.
mplt_CAN_Phone_Number_Parse	Mapplet	Parses phone number in the Canadian standard format from a string of texts into its own field.
mplt_CAN_Phone_Number_Standardization	Mapplet	Standardizes format of the phone string to have Phone_w_Extenstion and dashes without spaces.
mplt_CAN_Phone_Number_Validation	Mapplet	Validates area code and length of the Canadian phone numbers. Quality scores are: 0 - NULL or blank input 10 - Invalid length 40 - Valid length, Invalid Area Code 95 - Valid length and Area Code
mplt_CAN_Postcode_Validation	Mapplet	Validates if input string is a valid Canadian postcode.
mplt_CAN_Province_Validation	Mapplet	Validates if input string is a valid Canadian province name.
mplt_CAN_SIN_Parse	Mapplet	Parses Canadian Social Insurance Number (SIN) from a string of texts.
mplt_CAN_SIN_Standardization	Mapplet	Formats Canadian Social Insurance Number (SIN) with variable value in the expression. The Valid formats are No_Punctuation, Space or Dash. The default setting is No_Punctuation.
mplt_CAN_SIN_Validation	Mapplet	Validates Canadian Social Insurance Number (SIN).
mplt_Company_Name_Match	Mapplet	Finds duplicate rows of company name data. The first three letters of the Soundex of the company name group company name data.
mplt_Prename_Assignment	Mapplet	Assigns a prename based on the gender. Uses a variable to change the female prename assignment value. For example, Ms or Mrs.
mplt_Salutation_Assignment	Mapplet	Generates a formal and casual greeting. For example, Mr John Smith gets a formal greeting of Dear Mr Smith, and a casual greeting of Dear John . You can change the prefix and the suffix in dq_Generate_Salutation transform.
mplt_USA_Address_Match	Mapplet	Finds duplicate rows of the United States Address Data. The first three digits of the post code group the Address Data.
mplt_USA_Address_Validation_Discrete	Mapplet	Validates the deliverability of United States addresses. Use the mapplet when you can connect the input address fields to fields on the Discrete model in the verifier asset.
mplt_USA_Address_Validation_Discrete_w_Geocoding	Mapplet	Validates the deliverability of United States addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Discrete model in the verifier asset.
mplt_USA_Address_Validation_Hybrid	Mapplet	Validates the deliverability of United States addresses. Use the mapplet when you can connect the input address fields to fields on the Hybrid model in the verifier asset.
mplt_USA_Address_Validation_Hybrid_w_Geocoding	Mapplet	Validates the deliverability of United States addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Hybrid model in the verifier asset.
mplt_USA_Address_Validation_Multiline	Mapplet	Validates the deliverability of United States addresses. Use the mapplet when you can connect the input address fields to fields on the Multiline model in the verifier asset.
mplt_USA_Address_Validation_Multiline_w_Geocoding	Mapplet	Validates the deliverability of United States addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Multiline model in the verifier asset.
mplt_USA_Company_Name_Standardization	Mapplet	Standardizes company name and provides its acronym if possible.
mplt_USA_Contact_Data	Mapplet	Parses name and provides missing gender and prename (Mr. or Ms.). Provides formal or casual greetings. Standardizes company name. Corrects, validates, and standardizes the United States addresses. Standardizes and validates phone, email, and Social Security Number.
mplt_USA_County_Validation	Mapplet	Checks if the input string is a valid county name in any state.
mplt_USA_Gender_Assignment	Mapplet	Assigns gender. For example, a name of John Smith has M for male.
mplt_USA_Given_Name_Standard	Mapplet	Returns standard name for common nicknames. For example, the input Bob returns Robert.
mplt_USA_IMO_Company_Name_and_Address_Match	Mapplet	Finds duplicate rows of company name and address data for the United States.
mplt_USA_IMO_Familyname_and_Address_Match	Mapplet	Finds duplicate rows of personal surname and address data for the United States. The first three digits of the postcode and the surname group the rows.
mplt_USA_IMO_Individual_Name_and_Address_Match	Mapplet	Finds duplicate rows of personal name and address data for the United States with Identity Match option.
mplt_USA_IMO_Personal_Name_and_Data_Match	Mapplet	Finds duplicate individual names and personal data for the United States. The personal data field may have any type of data such as phone number, email, and Social Security Number, but should be of the same type. The personal data field is the group key that sorts and groups all rows.
mplt_USA_Multi_Person_Name_Parse	Mapplet	Parses the United States input name into proper name components.
mplt_USA_Personal_Name_Parse_Validation	Mapplet	Uses gender-specific score to determine the status of a known gender for any name. Accepts M and F as inputs for male and female genders respectively. Uses the highest male or female scores for unknown gender to determine the status. Calculates the probable gender based on first name input and provides a confidence score based on the frequency of male or female name occurrences. The genders have a score if the probability of the male or female gender is 70% or more. Unknown genders have a confidence score of zero.
mplt_USA_Personal_Name_Parse_and_Standardize_LFM_Prebuilt	Mapplet	Uses prebuilt parser that parses name in Last-First-Middle format into discrete components. Assigns prenames and standardizes the prename, postname, and title cases for all the components. Builds a full name from discrete components.
mplt_USA_Personal_Name_Parsing_FML	Mapplet	Parses United States input names in First-Middle-Last format in discrete components.
mplt_USA_Personal_Name_Parsing_LFM	Mapplet	Parses a United States name in Last-First-Middle format in discrete components.
mplt_USA_Phone_Number_Parse	Mapplet	Parses phone number in the United States format from a string of texts in its own field.
mplt_USA_Phone_Number_Standardization	Mapplet	Standardizes format of United States phone string to standard dashes without spaces.
mplt_USA_Phone_Number_Validation	Mapplet	Validates area code for the United States phone numbers. The quality scores are: 0 - NULL or blank input 10 - Invalid length 40 - Valid length, Invalid Area Code 95 - Valid length and Area Code
mplt_USA_Phone_Parse_Standardize_Validate	Mapplet	Parses phone number for the United States from a string of texts. Validates that area code is valid for the United States, and returns phone number in three different standard formats for valid codes. Returns the status value (Valid or Invalid) and the status description.
mplt_USA_Phone_w_Extension_Parse	Mapplet	Parses phone number that can have an extension as per the United States standard format from a string of texts into its own field.
mplt_USA_SIC_Code_Validation	Mapplet	Validates Standard Industrial Classification (SIC) codes for the United States. Returns the status of valid and invalid codes, the descriptions, and the short explanations.
mplt_USA_SSN_Parse	Mapplet	Parses Social Security Number patterns for the United States with or without dashes from a larger string of texts.
mplt_USA_SSN_Parse_Standardize_and_Validate	Mapplet	Parses Social Security Number patterns for the United States with or without dashes from a larger string of texts. Formats and validates Social Security Number. Format options include without punctuation, with punctuation, and spaces. Change the variable port Social Security Number_Format in dq_Social Security Number_Format transform as desired. Default output is without punctuation.
mplt_USA_SSN_Standardization	Mapplet	Formats input Social Security Number for the United States. Formats include without punctuation, with punctuation, and with spaces. Change the variable port Social Security Number_Format in the dq_Social Security Number_Format transform as desired. The default output is without punctuation.
mplt_USA_SSN_Validation	Mapplet	Checks if area (first 3 numbers) and group (middle 2 numbers) are valid combinations for all the 0s. Does not check if Social Security Number is an issued number. Accurately validates if Social Security Numbers exist before June 25, 2011 due to Social Security Number Randomization.
mplt_USA_SSN_Validation_post_June2011	Mapplet	Validates Social Security Number for length, numeric values and known minimum or maximum values of the area, group, and serial number sections. Does not check if Social Security Number is an issued number. Does not validate group and area number combination because Social Security Numbers exist before June 25, 2011 due to Social Security Number Randomization.
mplt_USA_State_Validation	Mapplet	Validates input string as a state name for the United States.
mplt_USA_ZIPCode_Validation	Mapplet	Validates input string as a 5-digit United States zipcode.
mplt_Email_Validation	Mapplet	Validates email format. Does not check if the email addresses are active. Returns valid or invalid emails.
mplt_Remove_Extra_Spaces	Mapplet	Replaces multiple consecutive spaces with a single character space and trims leading and trailing spaces.
mplt_Remove_Non_Numbers	Mapplet	Removes all characters that are not digits or numbers from the input strings.
mplt_Remove_Punctuation	Mapplet	Removes all punctuation occurrences from the input strings.
mplt_Remove_Punctuation_and_Space	Mapplet	Removes all punctuations and spaces from the input strings, and returns the digits and letters.
mplt_Replace_Limited_Punct_with_Space	Mapplet	Replaces certain punctuations with a single character space. The punctuations include: /, \, ., !, _ and two, three, and four consecutive spaces.
mplt_TitleCase	Mapplet	Converts case of the input text to title case. The first character of each word is in upper case, while the remaining characters are in lower cases.
mplt_UpperCase	Mapplet	Changes cases to upper for all input data.
p_Assign_Firstname_Gender_Can	Parse	Assigns gender to first name for Canada data.
p_Assign_Midname_Gender_Can	Parse	Assigns gender to middle name for Canada data.
p_Assign_Prename_Gender_can	Parse	Assigns gender to prename for Canada data.
p_BRA_parse_NameDesignator	Parse	Parses name designator for Brazil data.
p_BRA_Parse_PostName	Parse	Parses postname for Brazil data.
p_BRA_Parse_Prename	Parse	Parses prename for Brazil data.
p_can_postcode_validation	Parse	Validates postcodes for Canada data.
p_can_Province_Validation	Parse	Parses Canadian provinces and validates the inputs.
p_dq_Label_Noise	Parse	Removes characters in a phone number.
p_parse_bra_phone_number	Parse	Parses phone number for Brazil data from a string input.
p_parse_can_phone_number	Parse	Parses phone number for Canada data from a string input.
p_parse_CAN_SIN	Parse	Parses Social Insurance Number for Canada.
P_Parse_Name_Components_FML_Can	Parse	Parses name components for Canada.
p_Parse_Name_Components_FML_USA	Parse	Parses inputs into First Name, Middle Name, and Last Name for the United States.
p_Parse_Name_Components_LFM_USA	Parse	Parses inputs into Last Name, Middle Name, and First Name for the United States.
p_SSN	Parse	Parses Social Security Number from a string.
p_USA_Assign_metric_to_matched_values	Parse	Assigns metrics for the United States based on reference table.
p_usa_gender_assignemnt_FN	Parse	Assigns gender based on first name.
p_usa_gender_assingment_MN	Parse	Assigns gender based on middle name.
p_USA_gender_Assignment_Prename	Parse	Assigns gender based on prename.
p_USA_Phone	Parse	Parses phone number for the United States from a string input.
p_usa_phone_w_extension	Parse	Parses phone number with extension for the United States from a larger string.
p_USA_SSN	Parse	Parses Social Security Number for the United States in XXX-XX-XXXX format.
p_AV_MailabilityScores_infa	Parse	Returns a description of the Mailability Score value that the mapping returns for an address.
p_FN_metrics_to_ind_fields	Parse	Parses metrics.
p_Parse_Assign_GeocodingStatus_Desc	Parse	Parses geocoding status description.
p_Parse_CAN_FullName	Parse	Parses full name in multi-name format for Canada data.
p_Parse_CAN_validate_area_code	Parse	Validates area code for Canada data.
p_Parse_US_FullName	Parse	Parses full name in multi-name format for the United States data.
p_SN_metrics_to_ind_fields	Parse	Parses surname metrics from a single input into discrete fields.
rs_can_postcode_validation	Rule Specification	Validates postcodes for Canada data.
rs_can_province_validation	Rule Specification	Validates province names for Canada data.
rs_USA_SIC_Validation	Rule Specification	Validates Standard Industrial Classification (SIC) codes in the United States data.
rs_Title_Case	Rule Specification	Converts a given input to title case.
rs_validate_area_code	Rule Specification	Identifies null entries in a column of telephone area code data.
v_BRA_Address_Val_Hybrid_Address	Verifier	Verifies Brazilian addresses with input fields that map to the Hybrid model.
v_BRA_AddressValidation_Hyb_w_Geo	Verifier	Verifies Brazilian addresses with input fields that map to the Hybrid model, and adds geocodes to the output.
v_BRA_AddressValidation_Multiline	Verifier	Verifies Brazilian addresses with input fields that map to the Multiline model.
v_BRA_Parse_Multiline_Address_w_Geo	Verifier	Verifies Brazilian addresses with input fields that map to the Multiline model, and adds geocodes to the output.
v_BRA_Validation_Discrete_Address	Verifier	Verifies Brazilian addresses with input fields that map to the Discrete model.
v_BRA_Validation_Discrete_Address_Geo	Verifier	Verifies Brazilian addresses with input fields that map to the Discrete model, and adds geocodes to the output.
v_CAN_AddressVerification_Hybrid	Verifier	Validates Canadian addresses with input fields that map to the Hybrid model.
v_CAN_AddressValidation_Discrete	Verifier	Verifies Canadian addresses with input fields that map to the Discrete model.
v_USA_AddressValidation_Hyb_w_Geo	Verifier	Verifies United States address with input fields that map to the Hybrid model, and adds geocodes to the output.
v_USA_AddressValidation_Hybrid	Verifier	Verifies United States addresses with input fields that map to the Hybrid model.
v_USA_AddressValidation_Geo_Multiline	Verifier	Verifies United States addresses with input fields that map to the Multiline model, and adds geocodes to the output.
v_USA_AddressValidation_Multiline	Verifier	Verifies United States addresses with input fields that map to the Multiline model.
v_USA_Validation_Discrete_Address	Verifier	Verifies United States addresses with input fields that map to the Discrete model.
v_USA_Validation_Discrete_Address_w_Geo	Verifier	Verifies United States addresses with input fields that map to the Discrete model, and adds geocodes to the output.