| CarryoverRateIndicator |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | CarryoverRateIndicator |
| Logical Rolename | |
| ColumnName | CarryoverRateIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the difference between capped and uncapped interest rate is to be carried over and applied to a future interest rate change. If Carryover Rate Indicator is present, any accumulated rate is placed in Carryover Rate Percent. |
| Note |
| CarryoverRateIndicator Logical Attribute Properties |
| Logical Attribute Name | CarryoverRateIndicator |
| Datatype | BIT |
| Nullable | NO |
| CarryoverRateIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CarryoverRateIndicator Bound Attachments |
| Name | Current Value |
| CarryoverRateIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CarryoverRateIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CarryoverRateIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CarryoverRateIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CarryoverRateIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CeilingRatePercent |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | CeilingRatePercent |
| Logical Rolename | |
| ColumnName | CeilingRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The stated maximum percentage to which the interest rate can increase over the life of the loan. |
| Note |
| CeilingRatePercent Logical Attribute Properties |
| Logical Attribute Name | CeilingRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| CeilingRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CeilingRatePercent Bound Attachments |
| Name | Current Value |
| CeilingRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CeilingRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CeilingRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CeilingRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CeilingRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestExclusionIndicator |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | DeferredInterestExclusionIndicator |
| Logical Rolename | |
| ColumnName | DeferredInterestExclusionIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that any accumulated deferred interest is excluded from the principal balance when a new payment is calculated for an ARM loan with negative amortization. |
| Note |
| DeferredInterestExclusionIndicator Logical Attribute Properties |
| Logical Attribute Name | DeferredInterestExclusionIndicator |
| Datatype | BIT |
| Nullable | NO |
| DeferredInterestExclusionIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DeferredInterestExclusionIndicator Bound Attachments |
| Name | Current Value |
| DeferredInterestExclusionIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DeferredInterestExclusionIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestExclusionIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestExclusionIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestExclusionIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangeMonthsCount |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | FirstRateChangeMonthsCount |
| Logical Rolename | |
| ColumnName | FirstRateChangeMonthsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of months after origination in which the first interest rate adjustment occurs, if the interest rate on the subject loan can change. |
| Note |
| FirstRateChangeMonthsCount Logical Attribute Properties |
| Logical Attribute Name | FirstRateChangeMonthsCount |
| Datatype | INTEGER |
| Nullable | NO |
| FirstRateChangeMonthsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FirstRateChangeMonthsCount Bound Attachments |
| Name | Current Value |
| FirstRateChangeMonthsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FirstRateChangeMonthsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangeMonthsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangeMonthsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangeMonthsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangePaymentEffectiveDate |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | FirstRateChangePaymentEffectiveDate |
| Logical Rolename | |
| ColumnName | FirstRateChangePaymentEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The due date of the first payment reflecting the first interest rate change for the loan. |
| Note |
| FirstRateChangePaymentEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | FirstRateChangePaymentEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| FirstRateChangePaymentEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FirstRateChangePaymentEffectiveDate Bound Attachments |
| Name | Current Value |
| FirstRateChangePaymentEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FirstRateChangePaymentEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangePaymentEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangePaymentEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FirstRateChangePaymentEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloorRatePercent |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | FloorRatePercent |
| Logical Rolename | |
| ColumnName | FloorRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The stated minimum percentage the interest rate can decrease to over the life of the loan. |
| Note |
| FloorRatePercent Logical Attribute Properties |
| Logical Attribute Name | FloorRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FloorRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloorRatePercent Bound Attachments |
| Name | Current Value |
| FloorRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloorRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloorRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloorRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloorRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodType |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateAdjustmentCalculationMethodType |
| Logical Rolename | |
| ColumnName | InterestRateAdjustmentCalculationMethodType |
| RoleName | |
| Domain | InterestRateAdjustmentCalculationMethodEnum |
| Definition | Specifies a method employed to calculate the interest rate of the loan. |
| Note |
| InterestRateAdjustmentCalculationMethodType Logical Attribute Properties |
| Logical Attribute Name | InterestRateAdjustmentCalculationMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| InterestRateAdjustmentCalculationMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateAdjustmentCalculationMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule228 |
| Description | |
| Type | By List |
| Value | Value Description |
| AddFixedPercentageToCurrentInterestRate | AddFixedPercentageToCurrentInterestRate |
| AddFixedPercentageToOriginalInterestRate | AddFixedPercentageToOriginalInterestRate |
| AddImpliedMarginToValueOfFinancialIndex | AddImpliedMarginToValueOfFinancialIndex |
| AddIndexChangeToOriginalInterestRate | AddIndexChangeToOriginalInterestRate |
| AddMarginToValueOfFinancialIndex | AddMarginToValueOfFinancialIndex |
| Other | Other |
| Renegotiated | Renegotiated |
| InterestRateAdjustmentCalculationMethodType Bound Attachments |
| Name | Current Value |
| InterestRateAdjustmentCalculationMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateAdjustmentCalculationMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateAdjustmentCalculationMethodTypeOtherDescription |
| Logical Rolename | |
| ColumnName | InterestRateAdjustmentCalculationMethodTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Interest Rate Adjustment Calculation Method Type. |
| Note |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | InterestRateAdjustmentCalculationMethodTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription Bound Attachments |
| Name | Current Value |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAdjustmentCalculationMethodTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAverageValueCount |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateAverageValueCount |
| Logical Rolename | |
| ColumnName | InterestRateAverageValueCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of interest rates that should be averaged to calculate the new interest rate for an ARM change if rate averaging is applicable. |
| Note |
| InterestRateAverageValueCount Logical Attribute Properties |
| Logical Attribute Name | InterestRateAverageValueCount |
| Datatype | INTEGER |
| Nullable | NO |
| InterestRateAverageValueCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateAverageValueCount Bound Attachments |
| Name | Current Value |
| InterestRateAverageValueCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateAverageValueCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAverageValueCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAverageValueCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateAverageValueCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingType |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateLifetimeAdjustmentCeilingType |
| Logical Rolename | |
| ColumnName | InterestRateLifetimeAdjustmentCeilingType |
| RoleName | |
| Domain | InterestRateLifetimeAdjustmentCeilingEnum |
| Definition | Describes if a lifetime ceiling exists for the specified plan and the method of calculating the ceiling. This field used in conjunction with the Maximum Increase Rate. |
| Note |
| InterestRateLifetimeAdjustmentCeilingType Logical Attribute Properties |
| Logical Attribute Name | InterestRateLifetimeAdjustmentCeilingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| InterestRateLifetimeAdjustmentCeilingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateLifetimeAdjustmentCeilingType Reference Value (Bound to Domain) |
| Name | ValidationRule229 |
| Description | |
| Type | By List |
| Value | Value Description |
| AbsoluteRequiredCeiling | AbsoluteRequiredCeiling |
| FactorAddedToTheGreaterOfTheNetCommitmentYieldOrTheOriginalNoteRate | FactorAddedToTheGreaterOfTheNetCommitmentYieldOrTheOriginalNoteRate |
| FactorAddedToTheNetCommitmentYield | FactorAddedToTheNetCommitmentYield |
| FactorAddedToTheOriginalNoteRate | FactorAddedToTheOriginalNoteRate |
| NotApplicable | NotApplicable |
| Other | Other |
| InterestRateLifetimeAdjustmentCeilingType Bound Attachments |
| Name | Current Value |
| InterestRateLifetimeAdjustmentCeilingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateLifetimeAdjustmentCeilingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateLifetimeAdjustmentCeilingTypeOtherDescription |
| Logical Rolename | |
| ColumnName | InterestRateLifetimeAdjustmentCeilingTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Interest Rate Lifetime Adjustment Ceiling Type. |
| Note |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | InterestRateLifetimeAdjustmentCeilingTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription Bound Attachments |
| Name | Current Value |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentCeilingTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorType |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateLifetimeAdjustmentFloorType |
| Logical Rolename | |
| ColumnName | InterestRateLifetimeAdjustmentFloorType |
| RoleName | |
| Domain | InterestRateLifetimeAdjustmentFloorEnum |
| Definition | Describes if a lifetime floor exists for the specified plan and the method of calculating the floor. This field used in conjunction with the Maximum Decrease Rate. |
| Note |
| InterestRateLifetimeAdjustmentFloorType Logical Attribute Properties |
| Logical Attribute Name | InterestRateLifetimeAdjustmentFloorType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| InterestRateLifetimeAdjustmentFloorType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateLifetimeAdjustmentFloorType Reference Value (Bound to Domain) |
| Name | ValidationRule230 |
| Description | |
| Type | By List |
| Value | Value Description |
| AbsoluteMinimumNetInterestRate | AbsoluteMinimumNetInterestRate |
| FactorAddedToOriginalNoteRate | FactorAddedToOriginalNoteRate |
| InitialNoteRate | InitialNoteRate |
| NotApplicable | NotApplicable |
| Other | Other |
| InterestRateLifetimeAdjustmentFloorType Bound Attachments |
| Name | Current Value |
| InterestRateLifetimeAdjustmentFloorType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateLifetimeAdjustmentFloorType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateLifetimeAdjustmentFloorTypeOtherDescription |
| Logical Rolename | |
| ColumnName | InterestRateLifetimeAdjustmentFloorTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Interest Rate Lifetime Adjustment Floor Type. |
| Note |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | InterestRateLifetimeAdjustmentFloorTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription Bound Attachments |
| Name | Current Value |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateLifetimeAdjustmentFloorTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingPercent |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateRoundingPercent |
| Logical Rolename | |
| ColumnName | InterestRateRoundingPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage to which the interest rate is rounded when a new interest rate is calculated. This field is used in conjunction with Interest Rate Rounding Type which indicates how rounding should occur. |
| Note |
| InterestRateRoundingPercent Logical Attribute Properties |
| Logical Attribute Name | InterestRateRoundingPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InterestRateRoundingPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateRoundingPercent Bound Attachments |
| Name | Current Value |
| InterestRateRoundingPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateRoundingPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingType |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateRoundingType |
| Logical Rolename | |
| ColumnName | InterestRateRoundingType |
| RoleName | |
| Domain | InterestRateRoundingEnum |
| Definition | Specifies how the interest rate is rounded when a new interest rate is calculated for an ARM change. The interest rate can be rounded Up, Down or to the Nearest Percent. This field is used in conjunction with Interest Rate Rounding Percent which indicates the percentage to which the rounding occurs. |
| Note |
| InterestRateRoundingType Logical Attribute Properties |
| Logical Attribute Name | InterestRateRoundingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| InterestRateRoundingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateRoundingType Reference Value (Bound to Domain) |
| Name | ValidationRule79 |
| Description | |
| Type | By List |
| Value | Value Description |
| Down | Down |
| Nearest | Nearest |
| NoRounding | NoRounding |
| Up | Up |
| InterestRateRoundingType Bound Attachments |
| Name | Current Value |
| InterestRateRoundingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateRoundingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateRoundingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateTruncatedDigitsCount |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | InterestRateTruncatedDigitsCount |
| Logical Rolename | |
| ColumnName | InterestRateTruncatedDigitsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | Indicated the number of digits the interest rate should be truncated to. |
| Note |
| InterestRateTruncatedDigitsCount Logical Attribute Properties |
| Logical Attribute Name | InterestRateTruncatedDigitsCount |
| Datatype | INTEGER |
| Nullable | NO |
| InterestRateTruncatedDigitsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestRateTruncatedDigitsCount Bound Attachments |
| Name | Current Value |
| InterestRateTruncatedDigitsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestRateTruncatedDigitsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateTruncatedDigitsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateTruncatedDigitsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestRateTruncatedDigitsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanMarginCalculationMethodType |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | LoanMarginCalculationMethodType |
| Logical Rolename | |
| ColumnName | LoanMarginCalculationMethodType |
| RoleName | |
| Domain | LoanMarginCalculationMethodEnum |
| Definition | Describes how to calculate the margin on the loan. |
| Note |
| LoanMarginCalculationMethodType Logical Attribute Properties |
| Logical Attribute Name | LoanMarginCalculationMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanMarginCalculationMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanMarginCalculationMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule260 |
| Description | |
| Type | By List |
| Value | Value Description |
| BasedOnProduct | BasedOnProduct |
| Constant | Constant |
| LoanMarginCalculationMethodType Bound Attachments |
| Name | Current Value |
| LoanMarginCalculationMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanMarginCalculationMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanMarginCalculationMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanMarginCalculationMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanMarginCalculationMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MarginRatePercent |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | MarginRatePercent |
| Logical Rolename | |
| ColumnName | MarginRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The number of percentage points to be added to the index to arrive at the new interest rate. |
| Note |
| MarginRatePercent Logical Attribute Properties |
| Logical Attribute Name | MarginRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| MarginRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MarginRatePercent Bound Attachments |
| Name | Current Value |
| MarginRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MarginRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MarginRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MarginRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MarginRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumDecreaseRatePercent |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | MaximumDecreaseRatePercent |
| Logical Rolename | |
| ColumnName | MaximumDecreaseRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The maximum number of percentage points by which the interest rate can decrease from the original interest rate over the life of the loan. |
| Note |
| MaximumDecreaseRatePercent Logical Attribute Properties |
| Logical Attribute Name | MaximumDecreaseRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| MaximumDecreaseRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MaximumDecreaseRatePercent Bound Attachments |
| Name | Current Value |
| MaximumDecreaseRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MaximumDecreaseRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumDecreaseRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumDecreaseRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumDecreaseRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumIncreaseRatePercent |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | MaximumIncreaseRatePercent |
| Logical Rolename | |
| ColumnName | MaximumIncreaseRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The maximum number of percentage points by which the interest rate can increase from the original interest rate over the life of the loan. |
| Note |
| MaximumIncreaseRatePercent Logical Attribute Properties |
| Logical Attribute Name | MaximumIncreaseRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| MaximumIncreaseRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MaximumIncreaseRatePercent Bound Attachments |
| Name | Current Value |
| MaximumIncreaseRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MaximumIncreaseRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumIncreaseRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumIncreaseRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaximumIncreaseRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenInterestRateValuesCount |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | PaymentsBetweenInterestRateValuesCount |
| Logical Rolename | |
| ColumnName | PaymentsBetweenInterestRateValuesCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of payments between Interest Rate values that should be used if rate averaging is applicable |
| Note |
| PaymentsBetweenInterestRateValuesCount Logical Attribute Properties |
| Logical Attribute Name | PaymentsBetweenInterestRateValuesCount |
| Datatype | INTEGER |
| Nullable | NO |
| PaymentsBetweenInterestRateValuesCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PaymentsBetweenInterestRateValuesCount Bound Attachments |
| Name | Current Value |
| PaymentsBetweenInterestRateValuesCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PaymentsBetweenInterestRateValuesCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenInterestRateValuesCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenInterestRateValuesCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenInterestRateValuesCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenRateChangesCount |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | PaymentsBetweenRateChangesCount |
| Logical Rolename | |
| ColumnName | PaymentsBetweenRateChangesCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of payments between rate changes. |
| Note |
| PaymentsBetweenRateChangesCount Logical Attribute Properties |
| Logical Attribute Name | PaymentsBetweenRateChangesCount |
| Datatype | INTEGER |
| Nullable | NO |
| PaymentsBetweenRateChangesCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PaymentsBetweenRateChangesCount Bound Attachments |
| Name | Current Value |
| PaymentsBetweenRateChangesCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PaymentsBetweenRateChangesCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenRateChangesCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenRateChangesCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenRateChangesCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionPercent |
| Base Entity | INTEREST_RATE_LIFETIME_ADJUSTMENT_RULE |
| Attribute Name | TimelyPaymentRateReductionPercent |
| Logical Rolename | |
| ColumnName | TimelyPaymentRateReductionPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage amount the interest rate will be reduced if payments are made in a timely manner. |
| Note |
| TimelyPaymentRateReductionPercent Logical Attribute Properties |
| Logical Attribute Name | TimelyPaymentRateReductionPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TimelyPaymentRateReductionPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TimelyPaymentRateReductionPercent Bound Attachments |
| Name | Current Value |
| TimelyPaymentRateReductionPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TimelyPaymentRateReductionPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |