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. Portugal Accelerator
  13. Spain Accelerator
  14. United Kingdom Accelerator
  15. 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

0 COMMENTS

We’d like to hear from you!