Informatica Data Quality
- Informatica Data Quality 10.5
- All Products
[Informatica_DQ_Content]\Rule Specifications
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
|