Data Quality accelerator bundles

Back Next

Cloud Data Quality Crisis Response Bundle

You can deliver a coordinated, data-driven response in your organization.

The following table describes the crisis response bundle assets:

Name	Type	Description
blood_type_infa	Dictionary	Contains blood groups and their alternative names.
c_av6_address_type_desc	Cleanse	Returns descriptions for the Address Type Codes.
c_av6_result_quality_desc	Cleanse	Returns descriptions for Result Quality.
c_av6_verification_status_code_desc	Cleanse	Returns descriptions for verification status codes.
c_blood_type_standardization	Cleanse	Standardizes blood type values.
c_country_id_dq_Prep_for_Country_Parse	Cleanse	Removes the short forms of street values. For example, removes Rd, St, Blvd.
c_Country_ISO2Char	Cleanse	Replaces country names with their respective two-letter ISO country codes.
c_Country_ISO3Char	Cleanse	Replaces country names with their respective three-letter ISO country codes.
c_cpt_code_from_section	Cleanse	Replaces valid Current Procedural Terminology (CPT) descriptions with their respective codes.
c_dq_Label_US_City_Postcode	Cleanse	Replaces city and ZIP Code values of the United States with dictionary values.
c_dq_Label_US_State_Postcode	Cleanse	Labels United States postcodes.
c_dq_State_Validate	Cleanse	Validates if the input is a valid state name in the United States.
c_dq_Validate_County	Cleanse	Validates if the input is a valid county name in the United States.
c_icd10_Codes_mplt_Association	Cleanse	Replaces ICD-10 code descriptions with their respective codes. ICD-10 identifies the tenth revision of the International Statistical Classification of Diseases and Related Health Problems.
c_icd10_Desc_mplt_Association	Cleanse	Replaces ICD-10 codes with their respective descriptions.
c_iso_full_country_name_infa	Cleanse	Replaces country identifiers in the input string with their respective full ISO country names.
c_Label_Default_Date_Patterns	Cleanse	Replaces dictionary matches for default date patterns with the term 'Valid'.
c_lbl_US_State_Locality	Cleanse	Replaces a valid United States state name and county name combination with the label 'valid_usa'.
c_Out_Country_Name	Cleanse	Standardizes country names.
c_predirectional_std	Cleanse	Standardizes common descriptive terms in address data, for example sub-building and directional indicators.
c_Remove_Apostrophe	Cleanse	Removes an apostrophe from the input.
c_Remove_Extra_Spaces	Cleanse	Replaces multiple consecutive spaces with a single space, and trims leading and trailing spaces.
c_Remove_Hyphen	Cleanse	Removes any hyphen from a string.
c_remove_leading_zero	Cleanse	Removes any leading zero from a string.
c_Remove_Parentheses	Cleanse	Removes all occurrences of left and right parenthesis from a string.
c_Remove_Period	Cleanse	Removes a period from a string.
c_Remove_Period_Parentheses	Cleanse	Removes all occurrences of a period and left and right parentheses from a string.
c_remove_punctuation	Cleanse	Removes all punctuation from the input.
c_Remove_Quotation	Cleanse	Removes all double quotation marks from a string.
c_remove_single_quotes	Cleanse	Removes single quotation marks from a string.
c_Remove_Slashes	Cleanse	Removes all occurrences of forward and backward slashes from a string.
c_remove_space	Cleanse	Removes all occurrences of a space from a string.
c_replace_hypen_w_single_quotes_spc	Cleanse	Replaces hyphens with single quotation marks.
c_replace_mult_spaces_w_single_space	Cleanse	Replaces instances of two or more consecutive character spaces in an input field with a single space, and trims the leading and trailing spaces.
c_Rmv_Dic_Matches_InstitutionMatch	Cleanse	Removes institution names that match the values in a dictionary.
c_standardize_rplce_bck_slash_with_fwd	Cleanse	Replaces a forward slash with a backward slash.
c_std_blood_mplt_Association	Cleanse	Standardizes blood type values.
c_Std_icd10_Block_Desc	Cleanse	Returns the ICD-10 block for a given medical condition based on its ICD-10 code.
c_std_icd10_Title_Description	Cleanse	Returns the ICD-10 title for a given medical condition based on its ICD-10 code.
c_std_terms_mplt_association	Cleanse	Replaces phrases or words associated with COVID-19 with the phrase 'COVID-19 virus identified'.
c_titlecase	Cleanse	Converts the input text to title case.
c_uppercase	Cleanse	Converts the input text to upper case.
c_US_Get_Name_Standard	Cleanse	Standardizes first names.
c_USA_PostCodes	Cleanse	Validates if the input has a valid ZIP Code against a reference table of United States ZIP Codes.
c_validate_area_code_label	Cleanse	Validates area codes.
c_validation_domain	Cleanse	Validates the domain of an email address.
can_localities	Dictionary	Contains a list of Canadian localities.
can_province_and_postcode	Dictionary	Contains a list of Canadian provinces and postcodes.
can_provinces_infa	Dictionary	Contains a list of Canadian provinces.
comorbidity_space_replace_infa	Dictionary	Replaces a character space in comorbidity data with an underscore character.
cpt_codes_infa	Dictionary	Contains a list of CPT (Current Procedural Terminology) codes and their corresponding tests, surgeries, evaluations, or medical procedures.
cpt_section_by_code	Dictionary	Contains a list of CPT (Current Procedural Terminology) codes and the medical categories to which they belong, such as anesthesiology, surgery, radiology, pathology, and laboratory medicine.
diacritics_translate_infa	Dictionary	Contains a list of diacritic symbols.
domain_names_infa	Dictionary	Contains a list of domain names.
dq_av_mailabilityscores_infa	Dictionary	Contains Mailability Score address verification values.
dq_av_match_code_descriptions_infa	Dictionary	Contains Match Code address verification values and the list of process modes that return the values.
dq_av6_result_quality_descriptions	Dictionary	Contains a list of the result quality codes that Address Verification version 6 engine returns with descriptions.
dq_av6_status_code_descriptions_infa	Dictionary	Contains alpha status values that indicate the outcome of the verification operation for an address. Each status value has a corresponding text description.
facility_noise	Dictionary	Contains a list of healthcare facilities.
household_infa	Dictionary	Contains a list of household units.
icd10_adult_codes_infa	Dictionary	Contains a list of ICD-10-CM (Clinical Modification) codes that describe conditions for patients aged 15 and over.
icd10_as_principal_diagnosis_codes	Dictionary	Contains a list of ICD-10 codes and their descriptions.
icd10_cm_pcs_codes_check_infa	Dictionary	Contains a list of ICD-10- Procedure Coding System codes.
icd10cm_codes_2020_classification_infa	Dictionary	Contains ICD-10 codes with their classifications.
icd10cm_codes_2020_infa	Dictionary	Contains a list of ICD-10-CM codes.
iso_full_country_name_infa	Dictionary	Contains ISO country names and their respective two-letter and three-letter ISO codes.
mplt_Association_btw_Infection_and_Blood_type	Mapplet	Standardizes blood type and diagnosis information and returns the corresponding ICD-10 codes and descriptions.
mplt_AV6_Assign_DQ_Status_Code_Description	Mapplet	Describes the Match Score value that a verifier asset returns for the Address Verification version 6 engine.
mplt_Blood_Type_Standardization	Mapplet	Standardizes input blood type values.
mplt_comparison_Dates	Mapplet	Compares two dates, calculates the difference between them, and generates four outputs. Each output represents the total difference between the date values in hours, days, months, or years. The output values are exclusive of each other are should not be used together to represent the difference between the data values. Input data type must be a string.
mplt_completeness	Mapplet	Checks if the input field is empty or null.
mplt_Completeness_Multi_Port	Mapplet	Checks if the input field is empty or null. Returns the incomplete data. Contains ten input and output ports.
mplt_Country_Name_Standardization1	Mapplet	Standardizes an input country name. Returns the full ISO country name and the corresponding ISO three-character and two-character codes.
mplt_CPT_code_Parse	Mapplet	Parses the current procedural terminology (CPT) code for all categories from a string.
mplt_CPT_code_validate	Mapplet	Validates a current procedural terminology (CPT) code, and returns the respective section codes.
mplt_Create_Institution_Match_Field	Mapplet	Standardizes institution names for use in a rule that performs match analysis.
mplt_Date_Complete	Mapplet	Checks if an input date string matches any user-defined default values. Does not validate the input string as a date.
mplt_Date_Of_Birth_Validation	Mapplet	Checks the number of years between the input date and the current date. Returns whether the years represent an adult or a minor. Returns Valid for 0 - 120 inclusive and returns Invalid for all other entries.
mplt_Date_Parse	Mapplet	Parses a date from a string of text. Dates can be in dd/mm/yyyy, mm/dd/yyyy, or yyyy/dd/mm formats. Dashes, spaces, forward slashes, and dots can be used as separators in the date fields.
mplt_Date_Standardization	Mapplet	Formats an input date string using user-defined variables. Includes the exp_ParseDate and exp_FormatDate transformations. Input dates that are invalid or do not fit the designated input format are written as all zeros.
mplt_Date_Validation	Mapplet	Validates a given date.
mplt_Date_Validation_Variable_Format	Mapplet	Validates an input date string. Allows the user to specify the input date format.
mplt_Days_Between_Dates	Mapplet	Calculates the difference between the two dates in days. The result is the difference between the end date and the start date. Set the input datatype as String.
mplt_Days_From_Current_Date	Mapplet	Calculates the number of days between an input date and the current date (system date). Set the expected input type as String.
mplt_Email_Parse	Mapplet	Parses an email from within a string of text.
mplt_Email_validation	Mapplet	Validates the email format. Does not check if the email address is active. Returns Valid or Invalid.
mplt_Global_Address_Validation_Hybrid	Mapplet	Validates the deliverability of address records from multiple countries. The mapplet corrects errors where possible. Use the rule with input address fields in a hybrid format.
mplt_icd10_Adult_Code_Check	Mapplet	Checks if an ICD-10 code is for an adult patient, that is, for a patient in the age range of 15 through 124 inclusive. Returns 'True' if it is an adult code and 'False' if not.
mplt_icd10_Code_Definition	Mapplet	Returns the title and block definitions for an ICD-10 code.
mplt_icd10_Code_Validation	Mapplet	Validates an ICD-10 code through a list that the user builds.
mplt_icd10_Questionable_Principal_Diagnosis_Code_Check	Mapplet	Checks if an ICD-10 code is determined to be insufficient for admission to an acute care hospital when used as a principal diagnosis. Returns 'True' if it is a Questionable Principal Diagnosis Code, 'False' if not.
mplt_Identify_Suspect_Names	Mapplet	Flags suspect or fake names.
mplt_IsNumeric	Mapplet	Verifies that the input data is numeric. The rule returns "True" or "False."
mplt_LowerCase	Mapplet	Converts the case of the input text to lowercase.
mplt_Match_Diag_Single	Mapplet	Compares morbidity values in two input strings, and returns a match score that represents the degree of similarity between them.
mplt_Negative_Number_Validation	Mapplet	Validates if the input is a negative number.
mplt_Non_Alphabetic_with_Space	Mapplet	Replaces all characters that are numbers or punctuations with a single space. Trims all consecutive spaces to a single space.
mplt_Parse_First_Word	Mapplet	Parses the first word in an input string to a field that the rule specifies.
mplt_Parse_Number_At_Start_Of_Line	Mapplet	Parses any number that occurs at the start of an input string to a field that the rule specifies. The rule reads strings from left to right.
mplt_Parse_Text_Between_Parentheses	Mapplet	Parses strings that are enclosed in parentheses to a field that the rule specifies. The rule contains an output field for the parsed strings and an output field for the input text without the parsed strings.
mplt_Parse_Text_in_Single_Quotes	Mapplet	Parses strings that are enclosed in quotation marks to a field that the rule specifies. When the input data contains multiple quoted elements, the rule parses the final element. The rule reads the input strings from left to right. The rule contains an output field for the parsed strings and an output field for the input text without the parsed strings.
mplt_Past_Date_Label	Mapplet	Determines whether an input date is earlier than the system date or later than the system date.
mplt_Positive_Number_Validation	Mapplet	Verifies that the input data is a positive number.
mplt_Prename_Assingment	Mapplet	Assigns a prename based on the gender. Uses a variable to change a female prename assignment value. For example, Ms or Mrs.
mplt_Prepend_Zero_to_Single_digit	Mapplet	Prepends the numeral "0" to a single numeric character. Returns the original input if the input contains other characters.
mplt_Remove_All_Leading_Zeros	Mapplet	Removes all leading zeros from a string.
mplt_Remove_Apostrophe	Mapplet	Removes apostrophes. The rule merges the text strings on either side of the apostrophe.
mplt_Remove_Control_Characters	Mapplet	Removes control characters from text strings. The rule returns a string that contains the control characters and a string that contains the input text without the control characters.
mplt_Remove_Extra_Spaces	Mapplet	Replaces multiple consecutive spaces with a single space, and trims leading and trailing spaces.
mplt_Remove_Hyphen	Mapplet	Removes hyphens from anywhere in the input string.
mplt_Remove_Leading_Zero	Mapplet	Removes a leading zero from a string. Only removes the zero, and ignores all other occurrences.
mplt_Remove_Limited_Punctuation	Mapplet	Removes extraneous characters. Extraneous characters include slashes, back slashes, periods, exclamation marks, and underscores. The rule also replaces multiple consecutive spaces with a single space.
mplt_Remove_Non_Numbers	Mapplet	Removes characters that are neither a digit nor a number from the input string.
mplt_Remove_Parentheses	Mapplet	Removes all occurrences of left and right parentheses from a string.
mplt_Remove_Period	Mapplet	Removes all occurrences of a period from a string.
mplt_Remove_Period_Parantheses	Mapplet	Removes all occurrences of a period and left and right parentheses found in a string.
mplt_Remove_Punctuation	Mapplet	Removes all punctuations from the input.
mplt_Remove_Punctuation_and_Space	Mapplet	Removes all punctuations and spaces.
mplt_Remove_Quotation	Mapplet	Removes all double quotation marks from a string. Does not replace with spaces.
mplt_Remove_Slashes	Mapplet	Removes all occurrences of forward and backward slashes in a string.
mplt_Remove_Space	Mapplet	Removes all occurrences of a space from an input field.
mplt_Replace_Limited_Punct_with_Space	Mapplet	Replaces the following punctuation characters with a single space: dash, back slash, period, exclamation mark, and underscore The rule also replaces two, three, and four consecutive spaces with a single space.
mplt_Salutation_Assignment	Mapplet	Generates formal and casual greetings from prenames and name tokens. For example, when input data contains "Mr. John Smith," the rule generates the formal greeting "Dear Mr. Smith," and the casual greeting "Dear John,". You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.
mplt_String_Completeness	Mapplet	Checks a string for completeness. The rule also searches the input strings for values in the reference tablestring_default_values_infa. The reference table contains values such as NA, DEFAULT, and XX. If an input string contains a value in the reference table, the rule identifies the string as incomplete.
mplt_TitleCase	Mapplet	Converts the case of the input text to title case.
mplt_UpperCase	Mapplet	Returns all alphabetic characters in upper case.
mplt_UpperCase1000	Mapplet	Returns alphabetic characters in upper case. The input and output fields in the rule use a precision of 1,000.
mplt_USA_County_Validation	Mapplet	Checks if input string is a valid county name in the United States.
mplt_USA_Gender_Assingment	Mapplet	Assigns gender according to first name. The mapplet returns "M" for male names, "F" for female names, and "U" if the gender is unknown. For example, the mapplet assigns the name "John Smith" a gender of "M" for male.
mplt_USA_Given_Name_Standard	Mapplet	Returns standard names for common nicknames. For example, returns Robert for Bob.
mplt_USA_Patient_Gender_Assignment	Mapplet	Assigns gender to a record according to the first-name information that the record contains. The mapplet returns "M" for male names, "F" for female names, and "U" if the gender is unknown. For example, the rule assigns the name "John Smith" a gender of "M" for male.
mplt_USA_Phone_Number_Parse	Mapplet	Parses a phone number from a text string in to its own field. The string must follow the standard format for the United States.
mplt_USA_Phone_Number_Standardization	Mapplet	Standardizes United States telephone numbers. The mapplet returns the telephone number in the following formats: Standard - (nnn) nnn-nnnn Dashes - nnn-nnn-nnnn No spaces - nnnnnnnnnn Phone_w_Extension - (nnn) nnn-nnnn ext nnnnn
mplt_USA_Phone_Number_Validation	Mapplet	Validates the area code and length of United States telephone numbers. The mapplet returns the following values: 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 a United States phone number from a text string, validates the area code, and returns the valid phone numbers in three different formats. Also returns a status value (valid or invalid) and a status description.
mplt_USA_Phone_w_Extension_Parse	Mapplet	Parses a telephone number, including an extension, that follows the standard number format for the United States.
mplt_USA_Provider_Gender_Assignment	Mapplet	Assigns gender to a record according to the first-name information that the record contains. The mapplet returns "M" for male names, "F" for female names, and "U" if the gender is unknown. For example, the rule assigns the name "John Smith" a gender of "M" for male.
mplt_USA_SSN_Parse	Mapplet	Parses a United States Social Security number (SSN) from a string of text. The mapplet can parse numbers with or without dashes.
mplt_USA_SSN_Standardization	Mapplet	Standardizes United States Social Security numbers. The mapplet can output the number with no punctuation, with character spaces, and with dashes. Change the variable SSN_Format in the dq_SSN_Format transformation as desired. The default output is without punctuation.
mplt_USA_State_Validation	Mapplet	Validates the input string as a United States state name.
mplt_USA_ZIPCode_Validation	Mapplet	Validates that the input string is a five-digit United States ZIP Code.
mplt_Years_Since_Date_Of_Birth	Mapplet	Calculates the number of years since the input date.
name_apostrophe_infa	Dictionary	Contains apostrophe for names.
name_comma_infa	Dictionary	Contains commas for names.
name_dash_infa	Dictionary	Contains dashes for names.
p_AV_MailabilityScores_infa	Parse	Parses a mailability score value that appears in the DQ_AV_MailabilityScores_infa dictionary.
p_Cpt_Code_Parse	Parse	Parses a valid CPT code.
p_Date_Parse	Parse	Parses a date.
p_email_from_text	Parse	Uses a regular expression to parse an email address from text.
p_First_Word	Parse	Parses the first word in a string.
p_icd10_Adult_Code	Parse	Parses an ICD-10 adult code and description.
p_icd10_code_check_validate	Parse	Parses an ICD-10 code.
p_icd10_questionable_diagnosis_parse	Parse	Parses an ICD-10 questionable diagnosis code or description.
p_icd10cm_Code	Parse	Parses an ICD-10-CM code from.
p_icd10cm_Descr	Parse	Parses an ICD-10-CM description from.
p_lbl_cpt_code_validate	Parse	Parses a CPT code.
p_Number_At_Start_of_String	Parse	Parses a number from the start of a string.
p_Parse_Country	Parse	Parses a three-character ISO country code.
p_suspect_names	Parse	Uses a dictionary to parse suspect names.
p_Text_btw_Parentheses	Parse	Parses the text between parentheses.
p_Text_btw_Single_Quotes	Parse	Parses the text between single quotes.
p_usa_gender_assignemnt_FN	Parse	Assigns gender based on the first name.
p_usa_gender_assingment_MN	Parse	Assigns gender based on the middle name.
p_USA_gender_Assingment_Prename	Parse	Assigns gender based on the prename.
p_USA_Phone	Parse	Parses a United States telephone number.
p_usa_phone_w_extension	Parse	Parses a United States telephone number with an extension from a larger string.
p_USA_SSN	Parse	Parses a United States Social Security Number in the format nnn-nn-nnnn.
rs_Assign_DQ_Match_Code_Description	Rule Specification	Assigns a description to a Match Code output from address verification.
rs_Cleanse_icd10cm_Label	Rule Specification	Provides a label for valid values in the ICD-10CM dictionary.
rs_Cpt_Validate	Rule Specification	Labels the input as a valid or invalid CPT code.
rs_dq_label_suspect_names	Rule Specification	Validates that the input is not a suspect name. Returns Suspect if a suspect name is found. Otherwise, returns Null.
rs_dq_output_match_code_desc	Rule Specification	Assigns a description to a Match Code output from address verification.
rs_icd10_code_valid	Rule Specification	Checks for null values.
rs_icd10_Questionable_Diagnosis_Label	Rule Specification	Validates that the input contains an ICD-10 questionable diagnosis label.
rs_icd10cm_token1	Rule Specification	Provides the dictionary values for valid inputs based on the ICD-10CM dictionary.
rs_iso_full_country_name	Rule Specification	Returns the ISO country name for an ISO country abbreviation in the input data.
rs_Null_Check	Rule Specification	Checks for nulls and returns 'True' or 'False'.
rs_remove_multiple_spaces	Rule Specification	Replaces instances of two or more consecutive character spaces in an input field with a single space.
rs_uppercase	Rule Specification	Converts strings to uppercase.
suspect_names_infa	Dictionary	Contains a list of suspect names.
title_case_excptn_infa	Dictionary	Contains a list of strings that a rule can treat as exceptions in a case conversion operation.
usa_adrs_prfx_std_s_infa	Dictionary	Standardizes address name prefix in the United States.
usa_business_word_infa	Dictionary	Contains a list of business terms in use in the United States.
usa_company_names_std_infa	Dictionary	Contains a list of United States organization names.
usa_company_sufx_abrv_infa	Dictionary	Contains a list of corporate suffix abbreviations.
usa_connectors_infa	Dictionary	Contains a list of connectors used in the United States.
usa_counties_infa	Dictionary	Contains a list of United States county names. Includes any alternative names in use for the counties.
usa_firstnames_infa	Dictionary	Contains a list of first names in the United States.
usa_gender_infa	Dictionary	Contains a list of United States first names and their commonly-assigned genders.
usa_locality_and_postcode	Dictionary	Contains a list of United States cities and towns and their associated ZIP Codes.
usa_name_designator_infa	Dictionary	Contains a list of name designators in use in the United States.
usa_name_frequencies_infa	Dictionary	Contains a list of United States names along with their frequencies.
usa_name_prefix_infa	Dictionary	Contains a list of name prefixes in use in the United States.
usa_name_suffix_infa	Dictionary	Contains a list of name suffixes in use in the United States.
usa_nicknames_infa	Dictionary	Contains a list of nicknames in use in the United States.
usa_occupation_infa	Dictionary	Contains a list of common occupations in the United States.
usa_postcodes	Dictionary	Contains a list of United States ZIP Codes.
usa_prename_gender_infa	Dictionary	Contains a list of United States first names and their commonly-assigned genders.
usa_ssn_grp_from_area_infa	Dictionary	Contains a list of group numbers and associated area numbers that are valid in United States Social Security numbers.
usa_ssn_indx_from_grp_infa	Dictionary	Gives Social Security Number index from the group code for the United States.
usa_state_and_locality	Dictionary	Contains a list of United States states and their constituent localities.
usa_state_and_postcode	Dictionary	Contains a list of United States states and associated postcodes.
usa_states	Dictionary	Contains a list of states in the United States.
usa_surname_ind_infa	Dictionary	Contains a list of the United States surnames.
usa_surnames_infa	Dictionary	Contains a list of surnames in the United States.
usa_tel_area_codes_infa	Dictionary	Contains a list of the United States telephone area codes.
usa_valid_name_frmts_infa	Dictionary	Contains a list of valid person name formats in the United States.
user_defined_dates_infa	Dictionary	Contains a list of standard date formats.
v_Global_AddressValidation_Hybrid	Verifier	Verifies postal addresses in hybrid format. Hybrid fields combine street information in a single field and use discrete fields for locality, province, and postcode information.