Data Quality accelerator bundles

Back Next

Data Quality bundle for financial services

Use Data Quality Financial Bundle to verify and enhance data from organizations in the financial services and mortgage loans sector. The Data Quality bundle for financial services includes rules that perform the following data quality operations: contact data cleansing, financial data cleansing, general data cleansing, matching and deduplication. The bundle also includes assets that evaluate mortgage data in the United States.

General assets

The following table lists the assets contained in the Data Quality bundle for financial services:

Name	Asset Type	Description
c_IFSC_Bank_Code	CLEANSE	Replaces an Indian Financial System Code (IFSC) with a valid full bank name. An IFSC is an eleven-character alphanumeric code that the Reserve Bank of India uses to identify bank branches within the NEFT (National Electronic Funds Transfer) network.
c_Merge_Currency_Country_Codes	CLEANSE	Merges the currency code and ISO three-character country code with an underscore character as a delimiter. For example, AFN_AFG.
c_Remove_Extra_Spaces	CLEANSE	Replaces multiple consecutive spaces with a single space and trims 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_Uppercase	CLEANSE	Converts the input text to uppercase.
c_US_Get_Name_Standard	CLEANSE	Standardizes given names.
dedupe_CompanyName_International_Match	DEDUPLICATE	Identifies duplicate records based on similarities in organization name data.
dedupe_Household_Name_Address_Match	DEDUPLICATE	Identifies duplicate records based on similarities in family name and address data. The operation uses Address Part1 as the index key.
dedupe_Individual_Name_and_Address	DEDUPLICATE	Identifies duplicate records based on similarities in person name and address data.
dedupe_Individual_Name_and_Email	DEDUPLICATE	Identifies duplicate records based on similarities in person name and email address data.
dedupe_Individual_Name_Date	DEDUPLICATE	Identifies duplicate records based on similarities in person name and date data.
dedupe_Individual_Name_Match	DEDUPLICATE	Identifies duplicate records based on similarities in person name data.
dedupe_Individual_Name_Phone	DEDUPLICATE	Identifies duplicate records based on person name and telephone number data.
dedupe_Match_Company_and_Address	DEDUPLICATE	Identifies duplicate records based on organization name and address data. The operation uses Company Name as the index key.
currency_codes_country_codes_infa	DICTIONARY	Contains a list of currency and country codes.
currency_codes_infa	DICTIONARY	Contains the currency codes of currencies around the world.
currency_symbol_from_code_infa	DICTIONARY	Contains a list of currency symbols and their corresponding currency names.
ccar_commercial_loan_flag	DICTIONARY	Contains commercial loan flag that is used in Comprehensive Capital Analysis and Review (CCAR) rule specifications.
ccar_false_flag	DICTIONARY	Contains false flag that is used in CCAR rule specifications.
ccar_N_flag	DICTIONARY	Contains 'No' flag that is used in CCAR rule specifications.
ccar_Occupancy_Code	DICTIONARY	Contains occupancy code that is used in CCAR rule specifications.
ccar_true_flag	DICTIONARY	Contains true flag that is used in CCAR rule specifications.
ccar_U_flag	DICTIONARY	Contains unknown flag that is used in CCAR rule specifications.
ccar_usa_state_three_digit_zip	DICTIONARY	Contains three-digit Zip Code and state code.
ccar_usa_zipcode_with_state	DICTIONARY	Contains a list of Zip Codes related to states.
ccar_Y_flag	DICTIONARY	Contains 'Yes' flag that is used in CCAR rule specifications.
Full_IFSC_Code_List	DICTIONARY	Contains a list of consolidated Indian Financial System Codes that identify NEFT-enabled bank branches as of 2022. NEFT abbreviates National Electronic Funds Transfer.
gbr_bank_sort_codes_infa	DICTIONARY	Contains United Kingdom bank sort codes.
iso_2chr_country_code_infa	DICTIONARY	Contains a list of two-character ISO country codes and the corresponding country names.
moodys_rating_codes_infa	DICTIONARY	Contains codes, grades, and description data that the Moody's rating agency uses.
s_and_p_rating_codes_infa	DICTIONARY	Contains Standard and Poors rating codes, grades, and description data.
usa_nicknames_infa	DICTIONARY	Contains a list of United States nicknames.
usa_states_infa	DICTIONARY	Contains a list of states in the United States and two-character codes.
user_defined_accounts_infa	DICTIONARY	Contains user-defined account data.
user_defined_ratings_infa	DICTIONARY	Contains user-defined rating codes, grades, and description data.
dq_Account_Validation	LABELER	Adds a label to an input row to indicate whether the contents of an account status field in the row is valid.
lbl_currency_codes	LABELER	Labels the valid currency codes as X.
lbl_currency_country_codes	LABELER	Labels a valid combination of currency code and country code. Returns Valid or Invalid.
lbl_IFSC_Bank_Code	LABELER	Labels Indian Financial System Code (IFSC) bank codes. If the input value is not valid, the asset returns the input value.
lbl_ifsc_code	LABELER	Labels Indian Financial System Code (IFSC) bank codes. Returns Valid or Invalid.
lbl_iso_Validate_Country_Code	LABELER	Labels ISO country codes.
lbl_Italian_Fiscal_Code	LABELER	Labels Italian fiscal codes.
lbl_Moodys_Rating	LABELER	Labels Moody's rating values.
lbl_Standard_and_Poors_Rating	LABELER	Labels Standard and Poor's rating values.
lbl_transit_number	LABELER	Assigns the label CAN_TRANSIT_NUM to values that match the Canadian transit number format.
lbl_User_Defined_Rating	LABELER	Labels user-defined rating values.
lbl_Validate_Country_Code	LABELER	Validates an ISO two-character country code. Returns Valid or Invalid.
lbl_Validate_CurrencyCode	LABELER	Validates an input currency code. Returns Valid or Invalid.
lbl_VAT_Italy	LABELER	Validates an Italian VAT (Value Added Tax) number format.
mplt_Account_Status_Validation	DMAPPLET	Validates account status data. The mapplet requires account status reference data.
mplt_Annual_Revenue_Validation	DMAPPLET	Checks that an input value is greater than zero and contains a currency symbol. Returns a status, description, the revenue value with currency and commas removed as a string, and the currency symbol if found at the start or end of the string.
mplt_Beta_Coefficient_Validation	DMAPPLET	Validates that a Beta coefficient value is a number. The mapplet indicates that the value is a positive number, negative number, zero, or not a number.
mplt_BIC_SWIFT_Code_Validation	DMAPPLET	Validates a Bank Identifier Code (BIC) or Society for Worldwide Interbank Financial Telecommunication (SWIFT) code by pattern recognition and country code validation.
mplt_CAN_Transit_Number_Validation	DMAPPLET	Validates the format of a Canadian transit number, as used for example in an EFT (electronic funds transfer) transaction.
mplt_Company_Name_and_Address_Match	DMAPPLET	Identifies duplicate records based on similarities in organization name and address data.
mplt_Company_Name_International_Match	DMAPPLET	Identifies duplicate records based on similarities in international organization name and address data.
mplt_Credit_Card_Security_Code_Validation	DMAPPLET	Validates that the credit card security code is a whole number that contains three or four digits.
mplt_Currency_Code_Country_Validation	DMAPPLET	Validates that the currency code is valid for the ISO three-character country code.
mplt_Currency_Code_Validation	DMAPPLET	Validates the currency code. Returns Valid or Invalid.
mplt_CUSIP_Validation	DMAPPLET	Validates CUSIP (Committee on Uniform Securities Identification Procedures) numbers. The mapplet determines the check digit for the input CUSIP number and compares it to valid CUSIP check digits.
mplt_Delta_Validation	DMAPPLET	Validates that the Delta value is positive, negative, or zero. The Delta is a ratio that compares the changes in the derivative price and the underlying asset price.
mplt_Dividend_Yield_Validation	DMAPPLET	Validates that the dividend yield value is a number greater than or equal to zero. The mapplet returns whether the value is a positive number, negative number, zero, or not a number.
mplt_EAD_Drawn_Balance_Validation	DMAPPLET	Validates that the amount listed as the exposure at default (EAD) is not less than the drawn balance. The mapplet follows the guidelines for EAD calculation from the Financial Services Authority in the United Kingdom.
mplt_EAD_Validation	DMAPPLET	Validates that the exposure at default (EAD) value is a number. The mapplet returns whether the value is a positive number, negative number, zero, or not a number.
mplt_EPS_Validation	DMAPPLET	Validates that the earnings per share (EPS) value is a number greater than or equal to zero.
mplt_Ex_Dividend_Date_Validation	DMAPPLET	Validates that the ex-dividend date and the record date are valid dates and that the ex-dividend date is earlier than the record date. The mapplet returns the difference in days between the record date and the ex-dividend date. The mapplet identifies dates with a difference of more than 15 days as not valid.
mplt_Familyname_and_Address_Match	DMAPPLET	Identifies duplicate rows based on surname and United States address data. The mapplet uses a combination of characters from the surname values and the postal code values to generate group keys.
mplt_Gamma_Validation	DMAPPLET	Validates that the Gamma string is a number. The mapplet returns whether the string is a positive number, negative number, zero, or not a number. Gamma measures the instability of the Delta value. A higher Gamma is an indication of a greater potential for change in the Delta value.
mplt_GBR_Bank_Account_Parse	DMAPPLET	Parses eight-digit numeric strings as United Kingdom bank account numbers.
mplt_GBR_Bank_Account_Validation	DMAPPLET	Validates United Kingdom bank account numbers. The mapplet returns codes that indicate whether the input is numeric and whether it contains the correct number of digits.
mplt_GBR_Bank_Sort_Code_Parse	DMAPPLET	Parses six-digit numeric strings as United Kingdom bank sort codes. The mapplet parses strings of numbers in the following formats: Consecutive numbers (999999) Numbers delimited with a dash (99-99-99)
mplt_GBR_Bank_Sort_Code_Standardize	DMAPPLET	Standardizes a United Kingdom bank sort code to the format NN-NN-NN.
mplt_GBR_Bank_Sort_Code_Validation	DMAPPLET	Validates the format and length of United Kingdom bank sort codes that are standardized to the dash-delimited format (99-99-99). The mapplet returns a Status field that describes the validity of the sort code and a Validation Note field that explains the status. If the sort code prefix matches a known assignment for a United Kingdom bank, the Validation Note field includes the bank name.
mplt_IND_Bank_IFSC_Code_Validation	DMAPPLET	Validates an Indian Financial System Code (IFSC) code.
mplt_IND_Bank_Name_From_IFSC_Code	DMAPPLET	Derives the bank name that an Indian Financial System Code (IFSC) represents.
mplt_Individual_Name_and_Address_Match	DMAPPLET	Identifies duplicate rows based on person names and United States address data. The deduplicate operation groups the data on surname and address values.
mplt_Individual_Name_and_Email_Match	DMAPPLET	Identifies duplicate rows based on person names and email addresses. The deduplicate operation groups the data on email address values.
mplt_Individual_Name_Date_Match	DMAPPLET	Identifies duplicate rows based on person names and date data. The deduplicate operation groups the data on date values.
mplt_Individual_Name_Match	DMAPPLET	Identifies duplicate rows based on person names. The deduplicate operation groups the data on surname values.
mplt_Individual_Name_Phone_Match	DMAPPLET	Identifies duplicate rows based on person names and telephone numbers. The deduplicate operation groups the data by telephone area code.
mplt_Interest_Rate_Within_Range	DMAPPLET	Validates if the decimal interest rate value is within the specified range. The range is set by two variable ports in an Expression transformation. The mapplet returns True or False.
mplt_ISIN_Code_Validation	DMAPPLET	Validates that the input value is an International Securities Identification Number (ISIN). The mapplet checks the structure of the value and verifies the check digit.
mplt_ITA_Codice_Fiscale_Validation	DMAPPLET	Validates an Italian fiscal code, or Codice Fiscale.
mplt_ITA_VAT_Number_Validation	DMAPPLET	Validates an Italian VAT (Value Added Tax) number.
mplt_Loan_to_Value_Ratio	DMAPPLET	Calculates the loan to value ratio, which is the loan amount divided by the property value.
mplt_Loss_Given_Default_Validation	DMAPPLET	Validates that the input is numeric and a positive, negative, or zero value. The mapplet is designed to assist in loss-given-default calculations for financial institutions.
mplt_Positive_Close_Price_Value_Validation	DMAPPLET	Validates that the input is a number greater than zero. The mapplet is designed to help financial institutions verify the closing prices of securities.
mplt_Positive_Coupon_Percent_Validation	DMAPPLET	Validates that the input is a number greater than zero. The mapplet is designed to help financial institution identify bond securities with positive interest rates.
mplt_Positive_Last_Price_Value_Validation	DMAPPLET	Validates that the input is a number greater than zero. The mapplet is designed to help financial institutions determine positive security valuations.
mplt_Positive_Number_Validation	DMAPPLET	Checks that the input is a number greater than zero.
mplt_Positive_Open_Price_Validation	DMAPPLET	Validates that the input is a number greater than zero. The mapplet is designed to help financial institutions verify the opening prices of securities.
mplt_Positive_Volume_Validation	DMAPPLET	Validates that the input is a number greater than zero. The mapplet is designed to help financial institutions identify positive changes in the volume of securities transactions.
mplt_Price_Earnings_Ratio_Validation	DMAPPLET	Validates that the price-to-earnings ratio is a positive number in the range of 0 - 100.
mplt_Probability_of_Default_Validation	DMAPPLET	Validates that the probability of default value is numeric and indicates if it is a positive, negative, or zero value. If positive, the mapplet returns status messages for values in the following ranges: Less than or equal to 0.1. Greater than 0.1 and less than or equal to 0.5. Greater than 0.5 and less than or equal to 1. Greater than 1.
mplt_Rating_Code_Validation	DMAPPLET	Validates that a rating is in the Standard & Poor's ratings scale, the Moody's ratings scale, or in a user-defined list.
mplt_Remove_Extra_Spaces	DMAPPLET	Replaces multiple consecutive character spaces with a single space, and trims leading and trailing spaces.
mplt_Remove_Punctuation	DMAPPLET	Removes all punctuation symbols from the input.
mplt_Remove_Punctuation_and_Space	DMAPPLET	Removes all punctuation symbols and character spaces from an input field, and returns the remaining digits and letters.
mplt_Remove_Space	DMAPPLET	Removes all occurrences of a character space from an input field.
mplt_UpperCase	DMAPPLET	Changes alphabetic characters to uppercase.
mplt_USA_Given_Name_Standard	DMAPPLET	Generates given names from United States nicknames. For example, the mapplet standardizes the nickname "Bob" to the given name "Robert."
mplt_Volatility_Validation	DMAPPLET	Validates that the volatility value is a number greater than or equal to zero.
rule_Convert_to_Number	DMAPPLET	Converts a string value to a number.
rule_Decimal_Length	DMAPPLET	Determines the length of the decimal portion of a number. Returns how many digits exist to the right of the decimal.
rule_Is_Date	DMAPPLET	Determines if an input string is a valid date. Returns Valid or Invalid.
rule_Is_Numeric	DMAPPLET	Determines if a string value consists of only numbers. Returns True or False.
p_GBR_Account_Parse	PARSE	Parses a United Kingdom bank account number from a string.
p_match_sort_codes	PARSE	Returns the name of the bank that uses the sort code in the input data.
p_Parse_BIC_Code	PARSE	Parses BIC or SWIFT codes from input data.
p_Parse_GBR_Bank_Sort_Code	PARSE	Parses six-digit strings as United Kingdom bank sort codes. The asset parses strings of numbers in the following formats: Consecutive numbers (999999) Numbers delimited with a dash (99-99-99)
p_Parse_GBR_Match_Bank_Sort_Codes	PARSE	Parses a United Kingdom bank sorting code from the input data when an input value matches a value in a dictionary.

United States Mortgage assets

The following table lists the assets that evaluate mortgage data in the United States:

Name	Asset Type	Description
ARM_Initial_Rate_datatype_limitation	RULE SPECIFICATION	Validates that the initial rate of an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_Initial_Rate_Period_small_int	RULE SPECIFICATION	Validates that the initial rate period of an adjustable rate mortgage is a smallint value.
ARM_InitialRate_data_limit	RULE SPECIFICATION	Validates that the initial rate of an adjustable rate mortgage is not greater than or equal to 18 or less than 1.
ARM_InitRatePrd_not_poped_FxdRteLoans	RULE SPECIFICATION	Validates that the initial rate period of an adjustable rate mortgage is not populated for fixed-rate loans.
ARM_Lifetime_Rate_Cap_limitation	RULE SPECIFICATION	Validates that the lifetime rate cap on an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_Lifetime_Rate_Floor_datatype_limit	RULE SPECIFICATION	Validates that the lifetime rate floor of an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_loans_should_have_ARM_IRP	RULE SPECIFICATION	Validates that an adjustable rate mortgage loan has an initial rate period.
ARM_Margin_at_Orig_datatype_limit	RULE SPECIFICATION	Validates that the margin at origination of an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_Margin_at_Origination_not_change	RULE SPECIFICATION	Validates that the margin at origination of an adjustable rate mortgage is not changed unless it is not provided.
ARM_Neg_Amortization_Limit	RULE SPECIFICATION	Validates that the negative amortization limit of an adjustable rate mortgage is not populated for fixed-rate loans.
ARM_Neg_Amortization_Limit_datatype_lim	RULE SPECIFICATION	Validates that the negative amortization limit of an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_Neg_Amortization_Limit_empty	RULE SPECIFICATION	Validates that the negative amortization limit of an adjustable rate mortgage is an empty string if negative amortization is not allowed.
ARM_Negative_Amortization_Limit	RULE SPECIFICATION	Validates that the negative amortization limit of an adjustable rate mortgage is not greater than 125 percent.
ARM_Periodic_Pay_Cap_datatype_limit	RULE SPECIFICATION	Validates that the periodic pay cap on an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_Periodic_Pay_Floor_datatype_limit	RULE SPECIFICATION	Validates that the periodic pay floor on an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_Periodic_Rate_Cap_datatype_limit	RULE SPECIFICATION	Validates that the periodic rate cap on an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
ARM_Periodic_Rate_Floor_datatype_limit	RULE SPECIFICATION	Validates that the periodic rate floor on an adjustable rate mortgage fits a decimal (7,5) datatype field or is an empty string.
Balance_LT_125_pct_LoanAmountDisp	RULE SPECIFICATION	Validates that the balance is less than 125 percent of the original loan amount disbursed.
Balloon_Term_limits	RULE SPECIFICATION	Validates that the balloon term is a number greater than or equal to 12 and less than or equal to 600 when the balloon flag is set.
Balloon_Term_must_be_a_smallint	RULE SPECIFICATION	Validates that the balloon term is a smallint value.
Balloon_Term_should_not_change	RULE SPECIFICATION	Validates that the balloon term is not changed unless it is not provided.
BalloonFlag_Is_Valid_Value	RULE SPECIFICATION	Validates that the balloon flag indicates the status Yes, No, or Unknown.
BalloonFlag_Unchanged	RULE SPECIFICATION	Validates that the balloon flag is not changed unless it indicates an unknown status or it is not provided.
Buydown_Flag_is_Unknown	RULE SPECIFICATION	Validates that the buydown flag indicates an unknown status.
Buydown_Flag_Must_Be_Valid_Value	RULE SPECIFICATION	Validates that the buydown flag indicates the status Yes, No, or Unknown.
Buydown_Flag_should_no_change	RULE SPECIFICATION	Validates that the buydown flag is not changed unless it indicates an unknown status or it is not provided.
Calc_LTV_GT_20pct_Change_from_Orig_LTV	RULE SPECIFICATION	Validates that the calculated loan-to-value ratio differs from the original loan-to-value ratio by more than 20 percent.
CBS_is_Number_Between_300_and_899	RULE SPECIFICATION	Validates that the origination credit bureau score is a valid whole number between 300 and 899.
CC_must_be_Specific_Value_or_empty_str	RULE SPECIFICATION	Validates that the credit class value is within a set of defined values.
Closing_Date_Check	RULE SPECIFICATION	Validates that the closing date is a valid date with the format YYYY-MM-DD . The date should not contain spaces and should not be null.
ClsngDate_Trm_3Mnth_Grtr_Than_Curr_Mnth	RULE SPECIFICATION	Validates that the closing date plus the loan term plus three months does not indicate a date that is earlier than the current month.
CLTV_Is_Number_GT_10pct_and_LT_150pct	RULE SPECIFICATION	Validates that the combined loan-to-value ratio is a number greater than 10 percent and less than 150 percent.
Credit_Class_Must_Be_Specific_Value	RULE SPECIFICATION	Validates that the credit class value is within a set of defined values.
Credit_class_should_not_change	RULE SPECIFICATION	Validates that the current credit class value matches the credit class value from the previous month.
FirstPayDate_Before_NextDueDate	RULE SPECIFICATION	Validates that the first payment date is not later than the next payment date.
FirstPayDate_date_restrictions	RULE SPECIFICATION	Validates that the first payment date is not more than three months later than the current month or more than 40 years ago.
FirstPayDate_Valid_Date	RULE SPECIFICATION	Validates that the input string is a valid date value in the format YYYYMMDD .
Fixed_loans_not_have_an_ARM_IRAP	RULE SPECIFICATION	Validates that a fixed loan does not have an adjustable rate mortgage initial rate adjustment period.
Fixed_Loans_not_have_ARM_IRP	RULE SPECIFICATION	Validates that a fixed loan does not have an adjustable rate mortgage initial rate period.
For_NCL_OPV_must_be_valid_positive_num	RULE SPECIFICATION	For a non-commercial loan, validates that the original property value is a valid positive whole number that is greater than or equal to 1,000 and less than or equal to 10,000,000.
FPD_LessThanOrEqual_ClosingDate	RULE SPECIFICATION	Validates that the closing date is earlier than or equal to the first payment date.
Frontend_DTI_is_Positive_Whole_Number	RULE SPECIFICATION	Validates that the original front-end debt to income value is a valid positive whole number.
If_not_a_Balloon_not_have_a_Balloon_Trm	RULE SPECIFICATION	Validates that a loan that is not a balloon loan does not have a balloon term.
Interest_Only_At_Origin_cannot_change	RULE SPECIFICATION	Validates that the interest-only mortgage at origination value is not changed unless it is unknown or it is not provided.
Interest_Only_At_Origination_is_Unknown	RULE SPECIFICATION	Validates that the interest-only mortgage at origination value is unknown.
Lien_Position_At_Origin_Must_Be_1	RULE SPECIFICATION	Validates that the lien position at origination is 1.
Lien_Position_at_Origin_No_change	RULE SPECIFICATION	Validates that the lien position at origination is not changed unless it is unknown or it is not provided.
Lien_Position_at_Origin_Specific_Value	RULE SPECIFICATION	Validates that the lien position at origination is within a set of defined values.
Loan_Closing_Date_Less_or_Equal_40_Yrs	RULE SPECIFICATION	Validates that the year of the loan closing date is not more than 40 years ago.
Loan_Closing_Month_Not_Greater_Curr_Mnt	RULE SPECIFICATION	Validates that the month of the loan closing date is earlier than the current month.
Loan_Number_Length_Check	RULE SPECIFICATION	Validates that the loan number is not empty or null and does not contain more than 32 characters.
Loan_Type_is_Other	RULE SPECIFICATION	Validates that the loan is a commercial loan.
Loan_Type_is_Unknown_or_Other	RULE SPECIFICATION	Validates that the loan is a commercial loan or the loan type is unknown.
LoanAmount_Unchanged_if_NotEmpty	RULE SPECIFICATION	Validates that the original loan amount disbursed is not changed unless the amount is not provided.
LoanPurpose_is_Other_or_Unknown	RULE SPECIFICATION	Validates that the loan purpose is not defined or is unknown.
LoanPurpose_Unchanged	RULE SPECIFICATION	Validates that the loan purpose coding value is not changed unless it is unknown or it is not provided.
Loans_with_ARM_Init_Rate_Period_is_ARM	RULE SPECIFICATION	Validates that a loan with an adjustable rate mortgage initial rate period is an adjustable rate mortgage.
LoanSource_is_Unknown	RULE SPECIFICATION	Validates that the loan source is unknown.
LoanSource_Unchanged	RULE SPECIFICATION	Validates that the loan source is not changed unless it is unknown or it is not provided.
LoanType_Unchanged	RULE SPECIFICATION	Validates that the loan type is not changed unless it is unknown or it is not provided.
LVT_GT_prcnt_range_for_NonHARP_and_HARP	RULE SPECIFICATION	Validates that the original loan-to-value ratio is a number greater than ten percent and less than 150 percent for HARP (Home Affordable Refinance Program) loans or a number greater than ten percent and less than 125 percent for non-HARP loans.
MI_Coverage_Pct_At_Origin_no_change	RULE SPECIFICATION	Validates that mortgage insurance cover percentage at origination is not changed unless the percentage is not provided.
MI_Coverage_Percent_At_Origin_datatype	RULE SPECIFICATION	Validates that mortgage insurance cover percentage at origination fits a decimal (4, 2) datatype field or is an empty string.
MI_Coverage_Prcnt_Origin_btwn_1_50_pct	RULE SPECIFICATION	Validates that mortgage insurance cover percentage at origination is a value between one percent and 50 percent.
Neg_Amortization_Flag_be_Specifc_Value	RULE SPECIFICATION	Validates that the negative amortization flag value is within a set of defined values or is an empty string.
Neg_Amortization_Flag_no_change	RULE SPECIFICATION	Validates that the negative amortization flag value is not changed unless it is not provided.
Negative_Amortization_Flag_be_Y_or_N	RULE SPECIFICATION	Validates that the negative amortization flag value indicates yes or no.
NonHARP_Loan_and_LTV_GTE_125pct	RULE SPECIFICATION	Validates that a loan is not a HARP loan and the calculated original loan-to-value ratio is greater than or equal to 125 percent.
Num_Of_Units_not_change	RULE SPECIFICATION	Validates that the number of units is not changed unless it is unknown or it is not provided.
Number_of_Units_is_Unknown_or_Other	RULE SPECIFICATION	Validates that the loan is a commercial loan and the number of units is not specified.
NumOfUnits_is_Specific_Value_or_Unknow	RULE SPECIFICATION	Validates that the number of units is within a set of defined values.
Occupancy_Code_Must_be_Specific_Value	RULE SPECIFICATION	Validates that the occupancy code is within a set of defined values
Occupancy_is_Unknown	RULE SPECIFICATION	Validates that the occupancy value is unknown.
Occupancy_no_change	RULE SPECIFICATION	Validates that the occupancy value is not changed unless it is unknown or it is not provided.
Opt_ARM_At_Origin_same_as_prior_month	RULE SPECIFICATION	Validates that the option adjustable rate mortgage at origination flag is same as the previous month.
Opt_ARM_Origin_Spec_Valu_or_an_emty_str	RULE SPECIFICATION	Validates that the option adjustable rate mortgage at origination value is Y or N or an empty string.
Option_ARM_Origin_must_be_Spec_Value	RULE SPECIFICATION	Validates that the option adjustable rate mortgage at origination value is Y or N.
Orig_Backend_DTI_Unchanged_If_Provided	RULE SPECIFICATION	Validates that the original back-end debt-to-income ratio is not changed unless it is not provided.
Orig_CBS_no_change	RULE SPECIFICATION	Validates that the origination credit bureau score is not changed unless it is not provided.
Orig_Frontend_DTI_Unchanged_If_Provided	RULE SPECIFICATION	Validates that the original Frontend DTI is not changed unless it is not provided
Orig_Loan_Term_number_between_12_600	RULE SPECIFICATION	Validates that the original loan term is a number between 12 and 600.
Orig_LoanAmount_Disbursed_be_integer	RULE SPECIFICATION	Validates that the original loan amount disbursed is an integer value.
Orig_LoanAmount_Disbursed_valid_pos_num	RULE SPECIFICATION	Validates that the original loan amount disbursed is a valid positive whole number.
Original_Backend_DTI_is_Positive_Number	RULE SPECIFICATION	Validates that the original back-end debt-to-income ratio is a valid positive whole number and is less than 100.
Original_Backend_DTI_is_SmallInt	RULE SPECIFICATION	Validates that the original back-end debt-to-income ratio is a smallint value.
Original_CLTV_Is_4_2_format_or_Is_Empty	RULE SPECIFICATION	Validates that the original combined loan-to-value ratio fits a decimal (4, 2) datatype field or is an empty string.
Original_CLTV_Not_Provided	RULE SPECIFICATION	Validates that the original combined loan-to-value ratio is not provided.
Original_CLTV_Unchanged_If_Not_Empty	RULE SPECIFICATION	Validates that the original combined loan-to-value ratio is not changed unless it is not provided.
Original_Frontend_DTI_GT_Backend_DTI	RULE SPECIFICATION	Validates that the original front-end debt-to-income ratio is greater than the back-end debt-to-income ratio.
Original_Frontend_DTI_is_Smallint	RULE SPECIFICATION	Validates that the original front-end debt-to-income ratio is a smallint value.
Original_LVT_Is_Number_with_4_2_format	RULE SPECIFICATION	Validates that the original loan-to-value ratio fits a decimal (4, 2) datatype field or is an empty string.
Original_LVT_Unchanged_If_Not_Empty	RULE SPECIFICATION	Validates that the original loan-to-value ratio is not changed unless it is not provided.
Original_Property_Value_an_Integer	RULE SPECIFICATION	Validates that the original property value is an integer.
OriginalPropertyValue_Unchanged	RULE SPECIFICATION	Validates that the original property value is not changed unless it is not provided.
Origination_CBS_a_smallint	RULE SPECIFICATION	Validates that the origination credit bureau score is a smallint value.
Origination_CBS_between_300_899	RULE SPECIFICATION	Validates that the origination credit bureau score is a value between 300 and 899.
Origination_CBS_should_not_change	RULE SPECIFICATION	Validates that the origination credit bureau score is not changed unless it is not provided.
Prop_ZIPCode_Less_than_equal_to_5_chars	RULE SPECIFICATION	Validates that the property Zip Code contains five or more characters or is an empty string.
Property_type_cannot_change	RULE SPECIFICATION	Validates that the property type is not changed unless it is unknown or it is not provided.
PropertyState_Length_Not_GreaterThan_2	RULE SPECIFICATION	Validates that the state code for the property contains not more than two characters.
PropertyType_is_Unknown	RULE SPECIFICATION	Validates that the property type is unknown.
Recourse_Flag_is_Unknown	RULE SPECIFICATION	Validates that the recourse flag indicates an unknown status.
RecourseFlag_Unchanged	RULE SPECIFICATION	Validates that the recourse flag is not changed unless it is unknown or it is not provided.
State_Abbr_Valid_for_NonCommercial_Loan	RULE SPECIFICATION	For non-commercial loans, validates that the property state is a valid postal abbreviation of one of the 50 states, or DC, or a valid United States possession.
ThreeDigit_ZipCode_Consisent_with_State	RULE SPECIFICATION	Validates that the first three digits of a Zip Code are consistent with a state in the United States.
Zipcode_Unchanged_and_NotEmpty	RULE SPECIFICATION	Validates that the property Zip Code is not changed unless it is not provided.
ZipCode5_for_NonCommercial_Loan	RULE SPECIFICATION	For non-commercial loans, validates that the property Zip Code contains five digits.

Rename Saved Search

Table of Contents

Data Quality accelerator bundles

Data Quality accelerator bundles

Data Quality bundle for financial services

Data Quality bundle for financial services

General assets

United States Mortgage assets