| ForbearancePrincipalReductionAmount |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | ForbearancePrincipalReductionAmount |
| Logical Rolename | |
| ColumnName | ForbearancePrincipalReductionAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The amount of the UPB forgiven by the lender. |
| Note |
| ForbearancePrincipalReductionAmount Logical Attribute Properties |
| Logical Attribute Name | ForbearancePrincipalReductionAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| ForbearancePrincipalReductionAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ForbearancePrincipalReductionAmount Bound Attachments |
| Name | Current Value |
| ForbearancePrincipalReductionAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ForbearancePrincipalReductionAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ForbearancePrincipalReductionAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ForbearancePrincipalReductionAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ForbearancePrincipalReductionAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestBearingUPBAmount |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | InterestBearingUPBAmount |
| Logical Rolename | |
| ColumnName | InterestBearingUPBAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The portion of the UPB on which interest is being collected. |
| Note |
| InterestBearingUPBAmount Logical Attribute Properties |
| Logical Attribute Name | InterestBearingUPBAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InterestBearingUPBAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestBearingUPBAmount Bound Attachments |
| Name | Current Value |
| InterestBearingUPBAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestBearingUPBAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestBearingUPBAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestBearingUPBAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestBearingUPBAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionType |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | LoanModificationActionType |
| Logical Rolename | |
| ColumnName | LoanModificationActionType |
| RoleName | |
| Domain | LoanModificationActionTypeEnum |
| Definition | Identifies the modification action that resulted in a change or changes to the loan note terms. |
| Note |
| LoanModificationActionType Logical Attribute Properties |
| Logical Attribute Name | LoanModificationActionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanModificationActionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanModificationActionType Reference Value (Bound to Domain) |
| Name | ValidationRule261 |
| Description | |
| Type | By List |
| Value | Value Description |
| BorrowerDelinquencyWorkout | A modification action that is initiated by the borrower. |
| Capitalization | A modification action that incorporates past due amounts and/or fees into the unpaid principal balance. |
| ChangeOfPaymentFrequency | ChangeOfPaymentFrequency |
| ConstructionToPermanentFinancing | ConstructionToPermanentFinancing |
| HAMP | A modification action initiated under the Home Affordable Modification Program |
| LenderPortfolioManagement | A modification action initiated by the lender holding the loan in order to optimize the portfolio's performance. |
| Other | Other |
| PrincipalForgiveness | A modification action that writes off a portion of the unpaid principal balance. |
| Restructure | A modification action that completely changes the nature and features of the original loan. |
| UnscheduledPaymentRecast | A modification action initiated when a borrower makes a large curtailment. |
| LoanModificationActionType Bound Attachments |
| Name | Current Value |
| LoanModificationActionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanModificationActionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionTypeOtherDescription |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | LoanModificationActionTypeOtherDescription |
| Logical Rolename | |
| ColumnName | LoanModificationActionTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Loan Modification Action Type. |
| Note |
| LoanModificationActionTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | LoanModificationActionTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LoanModificationActionTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanModificationActionTypeOtherDescription Bound Attachments |
| Name | Current Value |
| LoanModificationActionTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanModificationActionTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationActionTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationEffectiveDate |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | LoanModificationEffectiveDate |
| Logical Rolename | |
| ColumnName | LoanModificationEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date on which the Modification Agreement goes into effect. |
| Note |
| LoanModificationEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | LoanModificationEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| LoanModificationEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanModificationEffectiveDate Bound Attachments |
| Name | Current Value |
| LoanModificationEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanModificationEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanModificationEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAdditionalEndorsementIndicator |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | ModificationAdditionalEndorsementIndicator |
| Logical Rolename | |
| ColumnName | ModificationAdditionalEndorsementIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true the lender is required to obtain one or more subordination agreements and/or a title policy endorsement to ensure the modified loan retains its first lien position. |
| Note |
| ModificationAdditionalEndorsementIndicator Logical Attribute Properties |
| Logical Attribute Name | ModificationAdditionalEndorsementIndicator |
| Datatype | BIT |
| Nullable | NO |
| ModificationAdditionalEndorsementIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ModificationAdditionalEndorsementIndicator Bound Attachments |
| Name | Current Value |
| ModificationAdditionalEndorsementIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ModificationAdditionalEndorsementIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAdditionalEndorsementIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAdditionalEndorsementIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAdditionalEndorsementIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAgreementAcceptanceCutoffDate |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | ModificationAgreementAcceptanceCutoffDate |
| Logical Rolename | |
| ColumnName | ModificationAgreementAcceptanceCutoffDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date by which the borrower must accept the terms of the modificaiton agreement. |
| Note |
| ModificationAgreementAcceptanceCutoffDate Logical Attribute Properties |
| Logical Attribute Name | ModificationAgreementAcceptanceCutoffDate |
| Datatype | DATE |
| Nullable | NO |
| ModificationAgreementAcceptanceCutoffDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ModificationAgreementAcceptanceCutoffDate Bound Attachments |
| Name | Current Value |
| ModificationAgreementAcceptanceCutoffDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ModificationAgreementAcceptanceCutoffDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAgreementAcceptanceCutoffDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAgreementAcceptanceCutoffDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationAgreementAcceptanceCutoffDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationEstimatedRequestProcessingDaysCount |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | ModificationEstimatedRequestProcessingDaysCount |
| Logical Rolename | |
| ColumnName | ModificationEstimatedRequestProcessingDaysCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The estimated number of days required to process the modification request. |
| Note |
| ModificationEstimatedRequestProcessingDaysCount Logical Attribute Properties |
| Logical Attribute Name | ModificationEstimatedRequestProcessingDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| ModificationEstimatedRequestProcessingDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ModificationEstimatedRequestProcessingDaysCount Bound Attachments |
| Name | Current Value |
| ModificationEstimatedRequestProcessingDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ModificationEstimatedRequestProcessingDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationEstimatedRequestProcessingDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationEstimatedRequestProcessingDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationEstimatedRequestProcessingDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationSubmissionCutoffDate |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | ModificationSubmissionCutoffDate |
| Logical Rolename | |
| ColumnName | ModificationSubmissionCutoffDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date by which the borrower must submit documentation required to determine whether they are eligible to participate in the modification program. |
| Note |
| ModificationSubmissionCutoffDate Logical Attribute Properties |
| Logical Attribute Name | ModificationSubmissionCutoffDate |
| Datatype | DATE |
| Nullable | NO |
| ModificationSubmissionCutoffDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ModificationSubmissionCutoffDate Bound Attachments |
| Name | Current Value |
| ModificationSubmissionCutoffDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ModificationSubmissionCutoffDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationSubmissionCutoffDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationSubmissionCutoffDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationSubmissionCutoffDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanEffectiveDate |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | ModificationTrialPlanEffectiveDate |
| Logical Rolename | |
| ColumnName | ModificationTrialPlanEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the trial plan goes into effect; also referred to as the beginning of the Loan Modification Trial Period. |
| Note |
| ModificationTrialPlanEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | ModificationTrialPlanEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| ModificationTrialPlanEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ModificationTrialPlanEffectiveDate Bound Attachments |
| Name | Current Value |
| ModificationTrialPlanEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ModificationTrialPlanEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanReturnOfDocumentsCutoffDate |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | ModificationTrialPlanReturnOfDocumentsCutoffDate |
| Logical Rolename | |
| ColumnName | ModificationTrialPlanReturnOfDocumentsCutoffDate |
| RoleName | |
| Domain | MISMODate |
| Definition | he date by which the borrower must send the Loan Modification Trial Plan conditions checklist, documentation, and first payment. |
| Note |
| ModificationTrialPlanReturnOfDocumentsCutoffDate Logical Attribute Properties |
| Logical Attribute Name | ModificationTrialPlanReturnOfDocumentsCutoffDate |
| Datatype | DATE |
| Nullable | NO |
| ModificationTrialPlanReturnOfDocumentsCutoffDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ModificationTrialPlanReturnOfDocumentsCutoffDate Bound Attachments |
| Name | Current Value |
| ModificationTrialPlanReturnOfDocumentsCutoffDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ModificationTrialPlanReturnOfDocumentsCutoffDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanReturnOfDocumentsCutoffDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanReturnOfDocumentsCutoffDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ModificationTrialPlanReturnOfDocumentsCutoffDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NonInterestBearingUPBAmount |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | NonInterestBearingUPBAmount |
| Logical Rolename | |
| ColumnName | NonInterestBearingUPBAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The portion of the UPB on which interest is no longer being collected. |
| Note |
| NonInterestBearingUPBAmount Logical Attribute Properties |
| Logical Attribute Name | NonInterestBearingUPBAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| NonInterestBearingUPBAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NonInterestBearingUPBAmount Bound Attachments |
| Name | Current Value |
| NonInterestBearingUPBAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NonInterestBearingUPBAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NonInterestBearingUPBAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NonInterestBearingUPBAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NonInterestBearingUPBAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationInterestRatePercent |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | PreModificationInterestRatePercent |
| Logical Rolename | |
| ColumnName | PreModificationInterestRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The interest rate of the modified loan prior to the modification taking place. |
| Note |
| PreModificationInterestRatePercent Logical Attribute Properties |
| Logical Attribute Name | PreModificationInterestRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PreModificationInterestRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PreModificationInterestRatePercent Bound Attachments |
| Name | Current Value |
| PreModificationInterestRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PreModificationInterestRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationInterestRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationInterestRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationInterestRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationPrincipalAndInterestPaymentAmount |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | PreModificationPrincipalAndInterestPaymentAmount |
| Logical Rolename | |
| ColumnName | PreModificationPrincipalAndInterestPaymentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The principal and interest payment amount of the modified loan prior to the modification taking place. |
| Note |
| PreModificationPrincipalAndInterestPaymentAmount Logical Attribute Properties |
| Logical Attribute Name | PreModificationPrincipalAndInterestPaymentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PreModificationPrincipalAndInterestPaymentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PreModificationPrincipalAndInterestPaymentAmount Bound Attachments |
| Name | Current Value |
| PreModificationPrincipalAndInterestPaymentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PreModificationPrincipalAndInterestPaymentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationPrincipalAndInterestPaymentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationPrincipalAndInterestPaymentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationPrincipalAndInterestPaymentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationUPBAmount |
| Base Entity | MODIFICATION_DETAIL |
| Attribute Name | PreModificationUPBAmount |
| Logical Rolename | |
| ColumnName | PreModificationUPBAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The unpaid principal balance amount of the modified loan prior to the modification taking place. |
| Note |
| PreModificationUPBAmount Logical Attribute Properties |
| Logical Attribute Name | PreModificationUPBAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PreModificationUPBAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PreModificationUPBAmount Bound Attachments |
| Name | Current Value |
| PreModificationUPBAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PreModificationUPBAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationUPBAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationUPBAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PreModificationUPBAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |