Table of Contents

Search

  1. Preface
  2. Introduction to Accelerators
  3. Core Accelerator
  4. Data Domains Accelerator
  5. Australia/New Zealand Accelerator
  6. BCBS 239/CCAR Accelerator
  7. Brazil Accelerator
  8. Financial Services Accelerator
  9. France Accelerator
  10. Germany Accelerator
  11. India Accelerator
  12. Italy Accelerator
  13. Portugal Accelerator
  14. Spain Accelerator
  15. United Kingdom Accelerator
  16. U.S./Canada Accelerator

Accelerator Guide

Accelerator Guide

BCBS 239/CCAR Rule Specifications

BCBS 239/CCAR Rule Specifications

Use the rule specifications to verify the input data against different aspects of BCBS 239 and CCAR.
Find the rule specifications in the following repository location:
[Informatica_DQ_Content]\Rule Specifications
The following table describes the rule specifications in the BCBS 239/CCAR accelerator:
Name
Description
rlsp_ARM_Initial_Rate_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The initial rate of an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_Initial_Rate_Period_must_be_a_small_int
The initial rate period of an adjustable rate mortgage must be a smallint value.
rlsp_ARM_Initial_Rate_Period_should_not_be_populated_for_Fixed_Rate_Loans
The initial rate period of an adjustable rate mortgage should not be populated for fixed-rate loans.
rlsp_ARM_Initial_Rate_Should_Not_Be_Greater_Then_Or_Equal_to_18_or_less_than_1
The initial rate of an adjustable rate mortgage should not be greater than or equal to 18 or less than 1.
rlsp_ARM_Lifetime_Rate_Cap_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The lifetime rate cap on an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_Lifetime_Rate_Floor_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The lifetime rate floor of an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_loans_should_have_ARM_Initial_Rate_Period
An adjustable rate mortgage loan should have an initial rate period.
rlsp_ARM_Margin_at_Origination_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The margin at origination of an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_Margin_at_Origination_should_not_change_unless_it_was_not_provided
The margin at origination of an adjustable rate mortgage should not change unless it is not provided.
rlsp_ARM_Negative_Amortization_Limit_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The negative amortization limit of an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_Negative_Amortization_Limit_should_be_an_empty_string_if_Negative_Amortization_not_allowed
The negative amortization limit of an adjustable rate mortgage should be an empty string if negative amortization is not allowed.
rlsp_ARM_Negative_Amortization_Limit_Should_Not_Be_Greater_Than_125_Pct
The negative amortization limit of an adjustable rate mortgage should not be greater than 125 percent.
rlsp_ARM_Negative_Amortization_Limit_should_not_be_populated_for_Fixed_Rate_Loans
The negative amortization limit of an adjustable rate mortgage should not be populated for fixed-rate loans.
rlsp_ARM_Periodic_Pay_Cap_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The periodic pay cap on an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_Periodic_Pay_Floor_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The periodic pay floor on an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_Periodic_Rate_Cap_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The periodic rate cap on an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_ARM_Periodic_Rate_Floor_must_be_able_to_fit_a_decimal_7_5_datatype_field_or_an_empty_string
The periodic rate floor on an adjustable rate mortgage must fit a decimal (7,5) datatype field or must be an empty string.
rlsp_Balance_LT_125_pct_LoanAmountDisp
The balance should be less than 125 percent of the original loan amount disbursed.
rlsp_Balloon_Term_must_be_a_number_greater_than_equal_to_12_and_less_or_equal_to_600_when_Balloon_Flag_is_Y
The balloon term must be a number greater than or equal to 12 and less than or equal to 600 when the balloon flag is set.
rlsp_Balloon_Term_must_be_a_smallint
The balloon term must be a smallint value.
rlsp_Balloon_Term_should_not_change_unless_it_was_not_provided
The balloon term should not change unless it is not provided.
rlsp_BalloonFlag_Is_Valid_Value
The balloon flag must indicate yes, no, or unknown.
rlsp_BalloonFlag_Unchanged_unless_Unknown_or_Empty
The balloon flag should not change unless it indicates an unknown status or it is not provided.
rlsp_Buydown_Flag_is_Unknown
The buydown flag indicates an unknown status.
rlsp_Buydown_Flag_Must_Be_Valid_Value
The buydown flag must indicate yes, no, or unknown.
rlsp_Buydown_Flag_should_not_change_unless_it_was_Unknown_or_not_provided
The buydown flag should not change unless it indicates an unknown status or it is not provided.
rlsp_Calc_LTV_Has_GT_20pct_Change_from_Original_LTV
The calculated loan-to-value ratio differs from the original loan-to-value ratio by more than 20 percent.
rlsp_Closing_Date_Check
The closing date must be a valid date with the format YYYY-MM-DD, must not contain spaces, and must not be null.
rlsp_ClosingDate_Plus_Term_and_3Months_Greater_Than_Current_Month
The closing date plus the loan term plus three months should not indicate a date that is earlier than the current month.
rlsp_CLTV_Is_Number_GT_10pct_and_LT_150pct
The combined loan-to-value ratio must be a number greater than 10 percent and less than 150 percent.
rlsp_Credit_Bureau_Score_is_Whole_Number_Between_300_and_899
The origination credit bureau score must be a valid whole number between 300 and 899.
rlsp_Credit_Class_Must_Be_Specific_Value
The credit class value must be within a set of defined values.
rlsp_Credit_Class_must_be_Specific_Value_or_an_empty_string
The credit class value must be within a set of defined values or must be an empty string.
rlsp_Credit_class_should_not_change
The current credit class value should match the credit class value from the previous month.
rlsp_FirstPayDate_Before_NextDueDate
The first payment date should not be later than the next payment date.
rlsp_FirstPayDate_LessThanOrEqual_3Months_After_and_LessThan_40_Years_Passed_CurrentDate
The first payment date must not be more than three months later than the current month or more than 40 years ago.
rlsp_FirstPayDate_LessThanOrEqual_ClosingDate
The closing date must be earlier than or equal to the first payment date.
rlsp_FirstPayDate_Valid_Date
The input string must be a valid date value in the format YYYYMMDD.
rlsp_Fixed_loans_should_not_have_an_ARM_Initial_Rate_Adjustment_Period
A fixed loan should not have an adjustable rate mortgage initial rate adjustment period.
rlsp_Fixed_Loans_should_not_have_ARM_Initial_Rate_Period
A fixed loan should not have an adjustable rate mortgage initial rate period.
rlsp_For_Non_Commercial_Loans_Original_Property_Value_must_be_a_valid_positive_whole_number
For a non-commercial loan, the original property value must be a valid positive whole number that is greater than or equal to 1,000 and less than or equal to 10,000,000.
rlsp_Frontend_DTI_is_Positive_Whole_Number
The original front-end debt to income value must be a valid positive whole number.
rlsp_If_not_a_Balloon_should_not_have_a_Balloon_Term
A loan that is not a balloon loan should not have a balloon term.
rlsp_Interest_Only_At_Origination_cannot_change_unless_it_was_Unknown_or_not_provided
The interest-only at origination value cannot change unless it is unknown or it is not provided.
rlsp_Interest_Only_At_Origination_is_Unknown
The interest-only at origination value is unknown.
rlsp_Lien_Position_At_Origin_Must_Be_1
The lien position at origination must be 1.
rlsp_Lien_Position_at_Origination_cannot_change_unless_it_was_Unknown_or_not_provided
The lien position at origination cannot change unless it is unknown or it is not provided.
rlsp_Lien_Position_at_Origination_Must_Be_Specific_Value
The lien position at origination must be within a set of defined values.
rlsp_Loan_Closing_Date_Less_Than_or_Equal_40_Years_Ago
The year of the loan closing date should be no more than 40 years ago.
rlsp_Loan_Closing_Month_Not_Greater_Than_Current_Month
The month of the loan closing date is earlier than the current month.
rlsp_Loan_Number_Length_Check
The loan number is not empty or null and contains no more than 32 characters.
rlsp_Loan_Type_is_Other
The loan is a commercial loan.
rlsp_Loan_Type_is_Unknown_or_Other
The loan is a commercial loan or the loan type is unknown.
rlsp_LoanAmount_Unchanged_if_NotEmpty
The original loan amount disbursed should not change unless the amount is not provided.
rlsp_LoanPurpose_is_Other_or_Unknown
The loan purpose is not defined or is unknown.
rlsp_LoanPurpose_Unchanged_unless_Unknown_or_not_provided
The loan purpose coding value should not change unless it is unknown or it is not provided.
rlsp_Loans_with_ARM_Initial_Rate_Period_should_be_ARMs
A loan with an adjustable rate mortgage initial rate period should be an adjustable rate mortgage.
rlsp_LoanSource_is_Unknown
The loan source is unknown.
rlsp_LoanSource_Unchanged_unless_Unknown_or_not_provided
The loan source must not change unless it is unknown or it is not provided.
rlsp_LoanType_Unchanged_Unless_Unknown_or_not_Provided
The loan type must not change unless it is unknown or it is not provided.
rlsp_LVT_GT_10pct_and_LT_125pct_for_Non_HARP_and_150pct_for_HARP
The original loan-to-value ratio must be 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.
rlsp_MI_Coverage_Pct_At_Origination_should_not_change_unless_it_was_not_provided
Mortgage insurance cover percentage at origination should not change unless the percentage is not provided.
rlsp_MI_Coverage_Percent_At_Origination_must_be_able_to_fit_a_decimal_4_2_datatype_field_or_an_empty_string
Mortgage insurance cover percentage at origination must fit a decimal (4, 2) datatype field or must be an empty string.
rlsp_MI_Coverage_Percent_At_Origination_should_be_between_1_and_50_pct
Mortgage insurance cover percentage at origination should be a value between one percent and 50 percent.
rlsp_Negative_Amortization_Flag_must_be_Specifc_Value_or_an_empty_string
The negative amortization flag value must be within a set of defined values or must be an empty string.
rlsp_Negative_Amortization_Flag_must_be_Y_or_N
The negative amortization flag value must indicate yes or no.
rlsp_Negative_Amortization_Flag_should_not_change_unless_it_was_not_provided
The negative amortization flag value should not change unless it is not provided.
rlsp_NonHARP_Loan_and_LTV_GTE_125pct
A loan is not a HARP loan and the calculated original loan-to-value ratio is greater than or equal to 125 percent.
rlsp_Number_of_Units_is_Unknown_or_Other
The loan is a commercial loan and the number of units is not specified.
rlsp_Number_Of_Units_should_not_change_unless_it_was_U_or_not_provided
The number of units should not change unless it is unknown or it is not provided.
rlsp_NumberOfUnits_is_Specific_Value_or_Unknow
The number of units must be within a set of defined values.
rlsp_Occupancy_cannot_change_unless_it_was_Unknown_or_not_provided
The occupancy value should not change unless it is unknown or it is not provided.
rlsp_Occupancy_Code_Must_be_Specific_Value_or_Unknown
The occupancy code must be within a set of defined values.
rlsp_Occupancy_is_Unknown
The occupancy value is unknown.
rlsp_Option_ARM_At_Origination_must_be_Specific_Value
The option adjustable rate mortgage at origination value must be Y or N.
rlsp_Option_ARM_At_Origination_must_be_Specific_Value_or_an_empty_string
The option adjustable rate mortgage at origination value must be Y or N or an empty string.
rlsp_Option_ARM_At_Origination_must_be_the_same_as_prior_month
The option adjustable rate mortgage at origination flag must be the same as the previous month.
rlsp_Origin_Credit_Bureau_Score_should_not_change_unless_it_was_not_provided
The origination credit bureau score should not change unless it is not provided.
rlsp_Original_Backend_DTI_is_Positive_Whole_Number
The original back-end debt-to-income ratio must be a valid positive whole number and must be less than 100.
rlsp_Original_Backend_DTI_is_SmallInt
The original back-end debt-to-income ratio must be a smallint value.
rlsp_Original_Backend_DTI_Unchanged_If_Provided
The original back-end debt-to-income ratio should not change unless it is not provided.
rlsp_Original_CLTV_Is_4_2_format_or_Is_Empty
The original combined loan-to-value ratio must fit a decimal (4, 2) datatype field or must be an empty string.
rlsp_Original_CLTV_Not_Provided
The original combined loan-to-value ratio is not provided.
rlsp_Original_CLTV_Unchanged_If_Not_Empty
The original combined loan-to-value ratio should not change unless it is not provided.
rlsp_Original_Frontend_DTI_GT_Backend_DTI
The original front-end debt-to-income ratio is greater than the back-end debt-to-income ratio.
rlsp_Original_Frontend_DTI_is_Smallint
The original front-end debt-to-income ratio must be a smallint value.
rlsp_Original_Frontend_DTI_Unchanged_If_Provided
The original Frontend DTI should not change unless it is not provided
rlsp_Original_Loan_Amount_Disbursed_must_be_a_valid_positive_whole_number
The original loan amount disbursed must be a valid positive whole number.
rlsp_Original_Loan_Amount_Disbursed_must_be_an_integer
The original loan amount disbursed must be an integer value.
rlsp_Original_Loan_Term_should_be_a_number_between_12_and_600
The original loan term should be a number between 12 and 600.
rlsp_Original_LVT_Is_Number_with_4_2_format
The original loan-to-value ratio must fit a decimal (4, 2) datatype field or must be an empty string.
rlsp_Original_LVT_Unchanged_If_Not_Empty
The original loan-to-value ratio should not change unless it is not provided.
rlsp_Original_Property_Value_must_be_an_Integer
The original property value must be an integer.
rlsp_OriginalPropertyValue_Unchanged_if_Not_Empty
The original property value should not change unless it is not provided.
rlsp_Origination_Credit_Bureau_Score_is_not_between_300_and_899
The origination credit bureau score is a value between 300 and 899.
rlsp_Origination_Credit_Bureau_Score_must_be_a_smallint
The origination credit bureau score must be a smallint value.
rlsp_Origination_Credit_Bureau_Score_should_not_change_unless_it_was_not_provided
The origination credit bureau score should not change unless it is not provided.
rlsp_Property_type_cannot_change_unless_it_was_Unknown_or_not_provided
The property type cannot change unless it is unknown or it is not provided.
rlsp_Property_ZIP_Code_Sould_Be_Less_than_or_equal_to_5_characters_or_an_empty_string
The property ZIP Code must contain five or more characters or must be an empty string.
rlsp_PropertyState_Length_Not_GreaterThan_2
The state code for the property contains no more than two characters.
rlsp_PropertyType_is_Unknown
The property type is unknown.
rlsp_Recourse_Flag_is_Unknown
The recourse flag indicates an unknown status.
rlsp_RecourseFlag_Unchanged_unless_Unknown_or_Empty
The recourse flag should not change unless it is unknown or it is not provided.
rlsp_State_Abbreviation_Valid_for_Non_Commercial_Loan
For non-commercial loans, the property state must be a valid postal abbreviation of one of the 50 States, or DC, or a valid United States possession.
rlsp_Three_Digit_Zip_Code_must_be_Consisent_with_State
A three-digit ZIP Code must be consistent with a United States state.
rlsp_ZipCode_Length_of_5_for_NonCommercial_Loan
For non-commercial loans, the property ZIP Code should contain five digits.
rlsp_Zipcode_Unchanged_and_NotEmpty
The property ZIP Code should not change unless it is not provided