| AdjustmentChangeEffectiveDueDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeEffectiveDueDate |
| Logical Rolename | |
| ColumnName | AdjustmentChangeEffectiveDueDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The effective payment due date of the Interest Rate, principal and interest Payment or Service Fee Change. |
| Note |
| AdjustmentChangeEffectiveDueDate Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeEffectiveDueDate |
| Datatype | DATE |
| Nullable | NO |
| AdjustmentChangeEffectiveDueDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeEffectiveDueDate Bound Attachments |
| Name | Current Value |
| AdjustmentChangeEffectiveDueDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeEffectiveDueDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeEffectiveDueDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeEffectiveDueDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeEffectiveDueDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | SequenceNumber |
| Logical Rolename | |
| ColumnName | SequenceNumber |
| RoleName | |
| Domain | XSD:Integer |
| Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
| Note |
| SequenceNumber Logical Attribute Properties |
| Logical Attribute Name | SequenceNumber |
| Datatype | INTEGER |
| Nullable | YES |
| SequenceNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SequenceNumber Bound Attachments |
| Name | Current Value |
| SequenceNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SequenceNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeIndexRatePercent |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeIndexRatePercent |
| Logical Rolename | |
| ColumnName | AdjustmentChangeIndexRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The index value used to calculate the interest rate percent for this adjustment. |
| Note |
| AdjustmentChangeIndexRatePercent Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeIndexRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AdjustmentChangeIndexRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeIndexRatePercent Bound Attachments |
| Name | Current Value |
| AdjustmentChangeIndexRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeIndexRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeIndexRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeIndexRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeIndexRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeInterestRatePercent |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeInterestRatePercent |
| Logical Rolename | |
| ColumnName | AdjustmentChangeInterestRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The calculated or pre-determined interest rate percent that will be effective on the Adjustment Change Effective Due Date. |
| Note |
| AdjustmentChangeInterestRatePercent Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeInterestRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AdjustmentChangeInterestRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeInterestRatePercent Bound Attachments |
| Name | Current Value |
| AdjustmentChangeInterestRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeInterestRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeInterestRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeInterestRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeInterestRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeOccurrenceExtendedTermMonthsCount |
| Logical Rolename | |
| ColumnName | AdjustmentChangeOccurrenceExtendedTermMonthsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | For loans where the term of the loan can be extended rather than increasing the principal and interest payment, this is the new term of the loan including any extension. |
| Note |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeOccurrenceExtendedTermMonthsCount |
| Datatype | INTEGER |
| Nullable | NO |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount Bound Attachments |
| Name | Current Value |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceExtendedTermMonthsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrencePassThroughRatePercent |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeOccurrencePassThroughRatePercent |
| Logical Rolename | |
| ColumnName | AdjustmentChangeOccurrencePassThroughRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The new rate, expressed as a percent, at which the Servicer passes through interest on the loan to the investor. It can be computed using either a top-down formula: Loan Interest Rate - Servicing Fee Rate - Excess Yield Rate -Lender Guaranty Fee Rate, or |
| Note |
| AdjustmentChangeOccurrencePassThroughRatePercent Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeOccurrencePassThroughRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AdjustmentChangeOccurrencePassThroughRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeOccurrencePassThroughRatePercent Bound Attachments |
| Name | Current Value |
| AdjustmentChangeOccurrencePassThroughRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeOccurrencePassThroughRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrencePassThroughRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrencePassThroughRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrencePassThroughRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceType |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeOccurrenceType |
| Logical Rolename | |
| ColumnName | AdjustmentChangeOccurrenceType |
| RoleName | |
| Domain | AdjustmentChangeOccurrenceEnum |
| Definition | Indicates the reason for the Interest Rate, principal and interest Payment or Service Fee change on an existing mortgage loan. |
| Note |
| AdjustmentChangeOccurrenceType Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeOccurrenceType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| AdjustmentChangeOccurrenceType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeOccurrenceType Reference Value (Bound to Domain) |
| Name | ValidationRule11 |
| Description | |
| Type | By List |
| Value | Value Description |
| ARM | A change in the mortgages interest rate or PI Payment related to an Adjustable Rate Mortgage contract. |
| Conversion | A change in interest rate related to the conversion of a mortgage to a fixed rate loan. |
| GEM | Referred to as Growing Equity Mortgage. A change to the PI payment as defined in the original mortgage note. |
| GPM | Referred to as Graduated Payment Mortgage. A change to the PI payment as defined in the original mortgage note. |
| LoanToValue | A change in interest rate related to a comparison of the loan amount to the property value as a measure of equity in the property. |
| NonScheduled | A change in the mortgages interest rate or PI Payment not scheduled based upon the terms of the mortgage note. |
| Other | Other |
| TimelyPaymentReward | A change in interest rate related to the successive history of timely payments |
| AdjustmentChangeOccurrenceType Bound Attachments |
| Name | Current Value |
| AdjustmentChangeOccurrenceType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeOccurrenceType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceTypeOtherDescription |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeOccurrenceTypeOtherDescription |
| Logical Rolename | |
| ColumnName | AdjustmentChangeOccurrenceTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the Adjustment Change Occurrence type if Other is selected. |
| Note |
| AdjustmentChangeOccurrenceTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeOccurrenceTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AdjustmentChangeOccurrenceTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeOccurrenceTypeOtherDescription Bound Attachments |
| Name | Current Value |
| AdjustmentChangeOccurrenceTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeOccurrenceTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeOccurrenceTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangePrincipalAndInterestPaymentAmount |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangePrincipalAndInterestPaymentAmount |
| Logical Rolename | |
| ColumnName | AdjustmentChangePrincipalAndInterestPaymentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the principal and interest payment associated with the Adjustment Change Effective Due Date. |
| Note |
| AdjustmentChangePrincipalAndInterestPaymentAmount Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangePrincipalAndInterestPaymentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AdjustmentChangePrincipalAndInterestPaymentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangePrincipalAndInterestPaymentAmount Bound Attachments |
| Name | Current Value |
| AdjustmentChangePrincipalAndInterestPaymentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangePrincipalAndInterestPaymentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangePrincipalAndInterestPaymentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangePrincipalAndInterestPaymentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangePrincipalAndInterestPaymentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeProjectedPrincipalBalanceAmount |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeProjectedPrincipalBalanceAmount |
| Logical Rolename | |
| ColumnName | AdjustmentChangeProjectedPrincipalBalanceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The projected principal balance amortized to the date for which interest rate, principal and interest payment, or convertible calculations were performed. |
| Note |
| AdjustmentChangeProjectedPrincipalBalanceAmount Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeProjectedPrincipalBalanceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AdjustmentChangeProjectedPrincipalBalanceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeProjectedPrincipalBalanceAmount Bound Attachments |
| Name | Current Value |
| AdjustmentChangeProjectedPrincipalBalanceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeProjectedPrincipalBalanceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeProjectedPrincipalBalanceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeProjectedPrincipalBalanceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeProjectedPrincipalBalanceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeAmount |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeServiceFeeAmount |
| Logical Rolename | |
| ColumnName | AdjustmentChangeServiceFeeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The recalculated fixed dollar amount that is paid to the servicer by the investor for servicing the mortgage if a service fee percent is not expressed. |
| Note |
| AdjustmentChangeServiceFeeAmount Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeServiceFeeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AdjustmentChangeServiceFeeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeServiceFeeAmount Bound Attachments |
| Name | Current Value |
| AdjustmentChangeServiceFeeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeServiceFeeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeRatePercent |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentChangeServiceFeeRatePercent |
| Logical Rolename | |
| ColumnName | AdjustmentChangeServiceFeeRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The recalculated percentage of interest collected that is paid to the servicer by the investor for servicing the mortgage (gross). |
| Note |
| AdjustmentChangeServiceFeeRatePercent Logical Attribute Properties |
| Logical Attribute Name | AdjustmentChangeServiceFeeRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AdjustmentChangeServiceFeeRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentChangeServiceFeeRatePercent Bound Attachments |
| Name | Current Value |
| AdjustmentChangeServiceFeeRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentChangeServiceFeeRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentChangeServiceFeeRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentRuleType |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | AdjustmentRuleType |
| Logical Rolename | |
| ColumnName | AdjustmentRuleType |
| RoleName | |
| Domain | AdjustmentRuleEnum |
| Definition | Specifies whether the occurrence of the adjustment is the first change or a subsequent change |
| Note |
| AdjustmentRuleType Logical Attribute Properties |
| Logical Attribute Name | AdjustmentRuleType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| AdjustmentRuleType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdjustmentRuleType Reference Value (Bound to Domain) |
| Name | ValidationRule12 |
| Description | |
| Type | By List |
| Value | Value Description |
| First | First |
| Subsequent | Subsequent |
| AdjustmentRuleType Bound Attachments |
| Name | Current Value |
| AdjustmentRuleType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdjustmentRuleType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentRuleType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentRuleType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdjustmentRuleType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | BalloonResetDate |
| Logical Rolename | |
| ColumnName | BalloonResetDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the balloon loan was reset to the current market rate for the remainder of the amortization period. |
| Note |
| BalloonResetDate Logical Attribute Properties |
| Logical Attribute Name | BalloonResetDate |
| Datatype | DATE |
| Nullable | NO |
| BalloonResetDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BalloonResetDate Bound Attachments |
| Name | Current Value |
| BalloonResetDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BalloonResetDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CarryoverRatePercent |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | CarryoverRatePercent |
| Logical Rolename | |
| ColumnName | CarryoverRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The cumulative unapplied difference between the calculated interest rate and the capped Interest Rate that can be used to modify the calculated interest rate at future interest rate change dates. Carryover Rate Percent is only present if Carryover Rate In |
| Note |
| CarryoverRatePercent Logical Attribute Properties |
| Logical Attribute Name | CarryoverRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| CarryoverRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CarryoverRatePercent Bound Attachments |
| Name | Current Value |
| CarryoverRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CarryoverRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CarryoverRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CarryoverRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CarryoverRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ChangeOccurrenceExtendedTermMonthsCount |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | ChangeOccurrenceExtendedTermMonthsCount |
| Logical Rolename | |
| ColumnName | ChangeOccurrenceExtendedTermMonthsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | For loans where the term of the loan can be extended rather than increasing the principal and interest payment, this is the new term of the loan including any extension. |
| Note |
| ChangeOccurrenceExtendedTermMonthsCount Logical Attribute Properties |
| Logical Attribute Name | ChangeOccurrenceExtendedTermMonthsCount |
| Datatype | INTEGER |
| Nullable | NO |
| ChangeOccurrenceExtendedTermMonthsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ChangeOccurrenceExtendedTermMonthsCount Bound Attachments |
| Name | Current Value |
| ChangeOccurrenceExtendedTermMonthsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ChangeOccurrenceExtendedTermMonthsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ChangeOccurrenceExtendedTermMonthsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ChangeOccurrenceExtendedTermMonthsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ChangeOccurrenceExtendedTermMonthsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleStatusType |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | ConvertibleStatusType |
| Logical Rolename | |
| ColumnName | ConvertibleStatusType |
| RoleName | |
| Domain | ConvertibleStatusEnum |
| Definition | Indicates whether the mortgagor has exercised the option to convert the ARM loan to a fixed rate loan. |
| Note |
| ConvertibleStatusType Logical Attribute Properties |
| Logical Attribute Name | ConvertibleStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ConvertibleStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConvertibleStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule81 |
| Description | |
| Type | By List |
| Value | Value Description |
| Active | Conversion option currently active. |
| Exercised | Mortgagor exercised option to convert to fixed rate. |
| Expired | Conversion option has expired. |
| ConvertibleStatusType Bound Attachments |
| Name | Current Value |
| ConvertibleStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConvertibleStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastRateChangeNotificationDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | LastRateChangeNotificationDate |
| Logical Rolename | |
| ColumnName | LastRateChangeNotificationDate |
| RoleName | |
| Domain | MISMODate |
| Definition | Date of last ARM change notification mailed to Mortgagor |
| Note |
| LastRateChangeNotificationDate Logical Attribute Properties |
| Logical Attribute Name | LastRateChangeNotificationDate |
| Datatype | DATE |
| Nullable | NO |
| LastRateChangeNotificationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LastRateChangeNotificationDate Bound Attachments |
| Name | Current Value |
| LastRateChangeNotificationDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LastRateChangeNotificationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastRateChangeNotificationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastRateChangeNotificationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastRateChangeNotificationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LatestConversionEffectiveDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | LatestConversionEffectiveDate |
| Logical Rolename | |
| ColumnName | LatestConversionEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The most recent date on which a change in the terms of the loan, as described in the note, became effective. |
| Note |
| LatestConversionEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | LatestConversionEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| LatestConversionEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LatestConversionEffectiveDate Bound Attachments |
| Name | Current Value |
| LatestConversionEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LatestConversionEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LatestConversionEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LatestConversionEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LatestConversionEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionEffectiveDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextConversionOptionEffectiveDate |
| Logical Rolename | |
| ColumnName | NextConversionOptionEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The next payment due date for which the mortgage has the option to convert to a fixed rate loan. |
| Note |
| NextConversionOptionEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | NextConversionOptionEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| NextConversionOptionEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextConversionOptionEffectiveDate Bound Attachments |
| Name | Current Value |
| NextConversionOptionEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextConversionOptionEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionNoticeDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextConversionOptionNoticeDate |
| Logical Rolename | |
| ColumnName | NextConversionOptionNoticeDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the next conversion option notice is due to be sent. |
| Note |
| NextConversionOptionNoticeDate Logical Attribute Properties |
| Logical Attribute Name | NextConversionOptionNoticeDate |
| Datatype | DATE |
| Nullable | NO |
| NextConversionOptionNoticeDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextConversionOptionNoticeDate Bound Attachments |
| Name | Current Value |
| NextConversionOptionNoticeDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextConversionOptionNoticeDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionNoticeDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionNoticeDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextConversionOptionNoticeDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextDemandConversionOptionNoticeDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextDemandConversionOptionNoticeDate |
| Logical Rolename | |
| ColumnName | NextDemandConversionOptionNoticeDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The next payment due date on which a conversion option notice will be sent as a courtesy for a demand convertible loan. |
| Note |
| NextDemandConversionOptionNoticeDate Logical Attribute Properties |
| Logical Attribute Name | NextDemandConversionOptionNoticeDate |
| Datatype | DATE |
| Nullable | NO |
| NextDemandConversionOptionNoticeDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextDemandConversionOptionNoticeDate Bound Attachments |
| Name | Current Value |
| NextDemandConversionOptionNoticeDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextDemandConversionOptionNoticeDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextDemandConversionOptionNoticeDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextDemandConversionOptionNoticeDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextDemandConversionOptionNoticeDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate |
| Logical Rolename | |
| ColumnName | NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The due date of the next payment for which the new principal and interest payment is calculated without regard to per change or lifetime caps. |
| Note |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate Logical Attribute Properties |
| Logical Attribute Name | NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate |
| Datatype | DATE |
| Nullable | NO |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate Bound Attachments |
| Name | Current Value |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnorePrincipalAndInterestPaymentAdjustmentCapsDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnoreRateAdjustmentCapsDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextIgnoreRateAdjustmentCapsDate |
| Logical Rolename | |
| ColumnName | NextIgnoreRateAdjustmentCapsDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The due date of the next payment for which the new interest rate is calculated without regard to periodic, per change or lifetime caps. |
| Note |
| NextIgnoreRateAdjustmentCapsDate Logical Attribute Properties |
| Logical Attribute Name | NextIgnoreRateAdjustmentCapsDate |
| Datatype | DATE |
| Nullable | NO |
| NextIgnoreRateAdjustmentCapsDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextIgnoreRateAdjustmentCapsDate Bound Attachments |
| Name | Current Value |
| NextIgnoreRateAdjustmentCapsDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextIgnoreRateAdjustmentCapsDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnoreRateAdjustmentCapsDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnoreRateAdjustmentCapsDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextIgnoreRateAdjustmentCapsDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextPrincipalAndInterestPaymentChangeEffectiveDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextPrincipalAndInterestPaymentChangeEffectiveDate |
| Logical Rolename | |
| ColumnName | NextPrincipalAndInterestPaymentChangeEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The payment due date of the next principal and interest payment to be calculated. |
| Note |
| NextPrincipalAndInterestPaymentChangeEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | NextPrincipalAndInterestPaymentChangeEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| NextPrincipalAndInterestPaymentChangeEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextPrincipalAndInterestPaymentChangeEffectiveDate Bound Attachments |
| Name | Current Value |
| NextPrincipalAndInterestPaymentChangeEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextPrincipalAndInterestPaymentChangeEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextPrincipalAndInterestPaymentChangeEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextPrincipalAndInterestPaymentChangeEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextPrincipalAndInterestPaymentChangeEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextRateAdjustmentEffectiveDate |
| Logical Rolename | |
| ColumnName | NextRateAdjustmentEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date on which the next interest rate adjustment goes into effect. |
| Note |
| NextRateAdjustmentEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | NextRateAdjustmentEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| NextRateAdjustmentEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextRateAdjustmentEffectiveDate Bound Attachments |
| Name | Current Value |
| NextRateAdjustmentEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextRateAdjustmentEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveNoticeDate |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | NextRateAdjustmentEffectiveNoticeDate |
| Logical Rolename | |
| ColumnName | NextRateAdjustmentEffectiveNoticeDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The interest rate change effective date for which the next interest rate change notice is to be sent, if notices are not sent to the mortgagor for every change. |
| Note |
| NextRateAdjustmentEffectiveNoticeDate Logical Attribute Properties |
| Logical Attribute Name | NextRateAdjustmentEffectiveNoticeDate |
| Datatype | DATE |
| Nullable | NO |
| NextRateAdjustmentEffectiveNoticeDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NextRateAdjustmentEffectiveNoticeDate Bound Attachments |
| Name | Current Value |
| NextRateAdjustmentEffectiveNoticeDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NextRateAdjustmentEffectiveNoticeDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveNoticeDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveNoticeDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NextRateAdjustmentEffectiveNoticeDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RateAdjustmentPercent |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | RateAdjustmentPercent |
| Logical Rolename | |
| ColumnName | RateAdjustmentPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Percentage to be added to current or original interest rate, if the interest rate on the subject loan can change. |
| Note |
| RateAdjustmentPercent Logical Attribute Properties |
| Logical Attribute Name | RateAdjustmentPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RateAdjustmentPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RateAdjustmentPercent Bound Attachments |
| Name | Current Value |
| RateAdjustmentPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RateAdjustmentPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RateAdjustmentPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RateAdjustmentPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RateAdjustmentPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicerARMPlanIdentifier |
| Base Entity | RATE_OR_PAYMENT_CHANGE_OCCURRENCE |
| Attribute Name | ServicerARMPlanIdentifier |
| Logical Rolename | |
| ColumnName | ServicerARMPlanIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identifies the servicers plan of the varying loan payment and/or rate change characteristics. |
| Note |
| ServicerARMPlanIdentifier Logical Attribute Properties |
| Logical Attribute Name | ServicerARMPlanIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ServicerARMPlanIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ServicerARMPlanIdentifier Bound Attachments |
| Name | Current Value |
| ServicerARMPlanIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ServicerARMPlanIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicerARMPlanIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicerARMPlanIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicerARMPlanIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |