| BankruptcySuspenseBalanceAmount |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | BankruptcySuspenseBalanceAmount |
| Logical Rolename | |
| ColumnName | BankruptcySuspenseBalanceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Unapplied funds related to a loan that is in bankruptcy |
| Note |
| BankruptcySuspenseBalanceAmount Logical Attribute Properties |
| Logical Attribute Name | BankruptcySuspenseBalanceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BankruptcySuspenseBalanceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BankruptcySuspenseBalanceAmount Bound Attachments |
| Name | Current Value |
| BankruptcySuspenseBalanceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BankruptcySuspenseBalanceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BankruptcySuspenseBalanceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BankruptcySuspenseBalanceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BankruptcySuspenseBalanceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyEffectiveDate |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | DelinquencyEffectiveDate |
| Logical Rolename | |
| ColumnName | DelinquencyEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date that the delinquency of the loan started, could be at day 16 or day 30 depending on the Investor requirements. |
| Note |
| DelinquencyEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | DelinquencyEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| DelinquencyEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DelinquencyEffectiveDate Bound Attachments |
| Name | Current Value |
| DelinquencyEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DelinquencyEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionType |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | DelinquencyReportingPropertyOverallConditionType |
| Logical Rolename | |
| ColumnName | DelinquencyReportingPropertyOverallConditionType |
| RoleName | |
| Domain | DelinquencyReportingPropertyOverallConditionEnum |
| Definition | Used to report the overall condition of the property associated with this loan as identified through a property inspector or through direct contact with Borrower, Neighbors, Real Estate Agent, etc. |
| Note |
| DelinquencyReportingPropertyOverallConditionType Logical Attribute Properties |
| Logical Attribute Name | DelinquencyReportingPropertyOverallConditionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| DelinquencyReportingPropertyOverallConditionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DelinquencyReportingPropertyOverallConditionType Reference Value (Bound to Domain) |
| Name | ValidationRule129 |
| Description | |
| Type | By List |
| Value | Value Description |
| Excellent | Excellent |
| Fair | Fair |
| Good | Good |
| NoPropertyInspection | NoPropertyInspection |
| Other | Other |
| Poor | Poor |
| PropertyInaccessible | PropertyInaccessible |
| Unknown | Unknown |
| DelinquencyReportingPropertyOverallConditionType Bound Attachments |
| Name | Current Value |
| DelinquencyReportingPropertyOverallConditionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DelinquencyReportingPropertyOverallConditionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | DelinquencyReportingPropertyOverallConditionTypeOtherDescription |
| Logical Rolename | |
| ColumnName | DelinquencyReportingPropertyOverallConditionTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe the data source type if Other is selected as the Delinquency Reporting Property Overall Condition Type. |
| Note |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | DelinquencyReportingPropertyOverallConditionTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription Bound Attachments |
| Name | Current Value |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DelinquencyReportingPropertyOverallConditionTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonType |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | LoanDelinquencyReasonType |
| Logical Rolename | |
| ColumnName | LoanDelinquencyReasonType |
| RoleName | |
| Domain | LoanDelinquencyReasonEnum |
| Definition | The reason why the Borrower has become delinquent on the loan. |
| Note |
| LoanDelinquencyReasonType Logical Attribute Properties |
| Logical Attribute Name | LoanDelinquencyReasonType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanDelinquencyReasonType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanDelinquencyReasonType Reference Value (Bound to Domain) |
| Name | ValidationRule256 |
| Description | |
| Type | By List |
| Value | Value Description |
| AbandonmentOfProperty | The borrower has abandoned the property for reasons that are not known (the Servicer has been unable to locate the borrower). |
| BusinessFailure | The failure the business of a self-employed borrower , or the inability of the business to generate sufficient profit, has reduced the ability of the borrower to meet his or her financial obligations. |
| CasualtyLoss | The borrower has experienced a sudden, unexpected property as a result of an accident, fire, storm, theft, earthquake, etc. |
| CurtailmentOfIncome | The income of the borrower has been reduced, because of a garnishment of wages, a change to a lower paying job, reduced commissions or overtime pay, loss of a part-time job, etc. |
| DeathOfMortgagorFamilyMember | The principal borrower has incurred extraordinary expenses because of the death of a family member or because of taking on sole responsibility for repayment of the mortgage as a result of the death of a co-borrower. |
| DeathOfPrincipalMortgagor | The principal borrower has died. |
| DistantEmploymentTransfer | The principal borrower has been transferred or relocated to a distant job location. The additional expenses for moving and housing in the new location have affected his or her ability to pay those expensed and the mortgage debt. |
| EnergyEnvironmentCost | The borrower has incurred excessive energy related costs, or costs associated with the removal of environmental hazards, in, on, or near the property. |
| ExcessiveObligations | The borrower has incurred excessive debts (either in a single instance or built up over time) that prevent him or her from making payments on both those debts and the mortgage debt. |
| Fraud | The delinquency is attributable to a legal dispute arising from a fraudulent or illegal action that occurred in connection with the origination of the mortgage (or later). |
| IllnessOfMortgagorFamilyMember | The principal borrower has incurred extraordinary expenses because of the illness of a family member or because of taking on sole responsibility for repayment of the mortgage as a result of the illness of aco-borrower. |
| IllnessOfPrincipalMortgagor | A prolonged illness keeps the principal borrower from working and generating income. |
| InabilityToRentProperty | The borrower needs rental income to make the mortgage payments and is having difficulty in finding a tenant for a one-family investment property or for one or more of the units in a one- to four-family property. |
| InabilityToSellProperty | The borrower is having difficulty selling the property. |
| Incarceration | The principal borrower has been imprisoned (regardless of whether he or she is still incarcerated). |
| MaritalDifficulties | Problems associated with separation or divorce - such as a dispute over ownership of the property, a decision not to make payments until the divorce settlement is final, a reduction in the income available to repay the mortgage debt, etc. - are affecting the ability of the borrowers to make mortgage payments. |
| MilitaryService | The principal borrower has been called to active duty, but his or her military pay is not sufficient to continue to pay the existing mortgage debt. |
| Other | The delinquency is attributable to reasons that are not otherwise included in the enumerated list. |
| PaymentAdjustment | An increase in the scheduled payment of a graduated payment or adjustable-rate mortgage; increased monthly escrow accruals needed to pay higher taxes, insurance premiums, or special assessments; or the need to make up an escrow shortage over the next year, is affecting the ability to make the new payment by the borrowers. |
| PaymentDispute | The borrower refuses to make payment(s) because of a disagreement with the Servicer about the amount of the mortgage payment, the acceptance of a partial payment, or the application of previous payments, until the dispute is resolved. |
| PropertyProblem | The condition of the property (substandard construction, expensive and extensive repairs needed, subsidence or sinkholes on property, impaired rights on ingress and egress, etc.) or the dissatisfaction with the property or the neighborhood is affecting the willingness to pay the mortgage by the borrowers. |
| ServicingProblems | There is a dispute by the Borrower in regards to how their loan has been serviced, normally centered around escrow advances, application of payments or interest rate changes. This would be used if the Servicer is having operational issues that are preventing them from effectively servicing the loan (loan set up problems, lock box delays, transfer of servicing, etc.) |
| TransferOfOwnershipPending | The borrower has agreed to sell the property and has decided not to make any additional payments. |
| UnableToContactBorrower | The reason for the delinquency cannot be determined because the borrower cannot be located or has not responded to inquiries. |
| Unemployment | The principal income of the borrowers has been reduced because of a loss of job. |
| LoanDelinquencyReasonType Bound Attachments |
| Name | Current Value |
| LoanDelinquencyReasonType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanDelinquencyReasonType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonTypeOtherDescription |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | LoanDelinquencyReasonTypeOtherDescription |
| Logical Rolename | |
| ColumnName | LoanDelinquencyReasonTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the Loan Delinquency Reason type if Other is selected. |
| Note |
| LoanDelinquencyReasonTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | LoanDelinquencyReasonTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LoanDelinquencyReasonTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanDelinquencyReasonTypeOtherDescription Bound Attachments |
| Name | Current Value |
| LoanDelinquencyReasonTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanDelinquencyReasonTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyReasonTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyCurrentOccupancyType |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | PropertyCurrentOccupancyType |
| Logical Rolename | |
| ColumnName | PropertyCurrentOccupancyType |
| RoleName | |
| Domain | PropertyCurrentOccupancyEnum |
| Definition | Specifies the property occupancy status of a subject property. |
| Note |
| PropertyCurrentOccupancyType Logical Attribute Properties |
| Logical Attribute Name | PropertyCurrentOccupancyType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PropertyCurrentOccupancyType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyCurrentOccupancyType Reference Value (Bound to Domain) |
| Name | ValidationRule393 |
| Description | |
| Type | By List |
| Value | Value Description |
| Abandoned | Abandoned |
| AdverseOccupied | AdverseOccupied |
| OwnerOccupied | OwnerOccupied |
| RemovedOrDestroyed | RemovedOrDestroyed |
| TenantOccupied | TenantOccupied |
| Unknown | Unknown |
| Vacant | Vacant |
| PropertyCurrentOccupancyType Bound Attachments |
| Name | Current Value |
| PropertyCurrentOccupancyType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyCurrentOccupancyType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyCurrentOccupancyType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyCurrentOccupancyType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyCurrentOccupancyType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanDownPaymentAmount |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | RepaymentPlanDownPaymentAmount |
| Logical Rolename | |
| ColumnName | RepaymentPlanDownPaymentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The initial lump sum amount paid prior to the first monthly payment for the Repayment Plan. |
| Note |
| RepaymentPlanDownPaymentAmount Logical Attribute Properties |
| Logical Attribute Name | RepaymentPlanDownPaymentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RepaymentPlanDownPaymentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RepaymentPlanDownPaymentAmount Bound Attachments |
| Name | Current Value |
| RepaymentPlanDownPaymentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RepaymentPlanDownPaymentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanDownPaymentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanDownPaymentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanDownPaymentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanMonthlyDueAmount |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | RepaymentPlanMonthlyDueAmount |
| Logical Rolename | |
| ColumnName | RepaymentPlanMonthlyDueAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The Repayment Plan monthly payment amount. The amount of repayment scheduled to be paid each month under the Repayment Plan. |
| Note |
| RepaymentPlanMonthlyDueAmount Logical Attribute Properties |
| Logical Attribute Name | RepaymentPlanMonthlyDueAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RepaymentPlanMonthlyDueAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RepaymentPlanMonthlyDueAmount Bound Attachments |
| Name | Current Value |
| RepaymentPlanMonthlyDueAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RepaymentPlanMonthlyDueAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanMonthlyDueAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanMonthlyDueAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanMonthlyDueAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanTermMonthsCount |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | RepaymentPlanTermMonthsCount |
| Logical Rolename | |
| ColumnName | RepaymentPlanTermMonthsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The duration in months of a repayment plan agreement established with the borrower |
| Note |
| RepaymentPlanTermMonthsCount Logical Attribute Properties |
| Logical Attribute Name | RepaymentPlanTermMonthsCount |
| Datatype | INTEGER |
| Nullable | NO |
| RepaymentPlanTermMonthsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RepaymentPlanTermMonthsCount Bound Attachments |
| Name | Current Value |
| RepaymentPlanTermMonthsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RepaymentPlanTermMonthsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanTermMonthsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanTermMonthsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RepaymentPlanTermMonthsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxAdvancesOnAccountsNotEscrowedIndicator |
| Base Entity | DELINQUENCY_NOTIFICATION_DETAIL |
| Attribute Name | TaxAdvancesOnAccountsNotEscrowedIndicator |
| Logical Rolename | |
| ColumnName | TaxAdvancesOnAccountsNotEscrowedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the Servicer has incurred advances to pay delinquent taxes on a non-escrowed account. |
| Note |
| TaxAdvancesOnAccountsNotEscrowedIndicator Logical Attribute Properties |
| Logical Attribute Name | TaxAdvancesOnAccountsNotEscrowedIndicator |
| Datatype | BIT |
| Nullable | NO |
| TaxAdvancesOnAccountsNotEscrowedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TaxAdvancesOnAccountsNotEscrowedIndicator Bound Attachments |
| Name | Current Value |
| TaxAdvancesOnAccountsNotEscrowedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TaxAdvancesOnAccountsNotEscrowedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxAdvancesOnAccountsNotEscrowedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxAdvancesOnAccountsNotEscrowedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxAdvancesOnAccountsNotEscrowedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |