| BorrowerReservesMonthlyPaymentCount |
| Base Entity | QUALIFICATION |
| Attribute Name | BorrowerReservesMonthlyPaymentCount |
| Logical Rolename | |
| ColumnName | BorrowerReservesMonthlyPaymentCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of loan payments that are available to the borrower from verified financial reserves after closing. CALCULATED RESULTS FIELD |
| Note |
| BorrowerReservesMonthlyPaymentCount Logical Attribute Properties |
| Logical Attribute Name | BorrowerReservesMonthlyPaymentCount |
| Datatype | INTEGER |
| Nullable | NO |
| BorrowerReservesMonthlyPaymentCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerReservesMonthlyPaymentCount Bound Attachments |
| Name | Current Value |
| BorrowerReservesMonthlyPaymentCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerReservesMonthlyPaymentCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerReservesMonthlyPaymentCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerReservesMonthlyPaymentCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerReservesMonthlyPaymentCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HousingExpenseRatioPercent |
| Base Entity | QUALIFICATION |
| Attribute Name | HousingExpenseRatioPercent |
| Logical Rolename | |
| ColumnName | HousingExpenseRatioPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The ratio of the proposed housing expenses to the qualifying income of the borrowers as per lender or investor guidelines. AKA Front End Ratio. CALCULATED RESULT FIELD |
| Note |
| HousingExpenseRatioPercent Logical Attribute Properties |
| Logical Attribute Name | HousingExpenseRatioPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| HousingExpenseRatioPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HousingExpenseRatioPercent Bound Attachments |
| Name | Current Value |
| HousingExpenseRatioPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HousingExpenseRatioPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HousingExpenseRatioPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HousingExpenseRatioPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HousingExpenseRatioPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectedReservesAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | ProjectedReservesAmount |
| Logical Rolename | |
| ColumnName | ProjectedReservesAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Based on investor guidelines, the projected dollar amount of remaining liquid assets after settlement. CALCULATED RESULTS FIELD. |
| Note |
| ProjectedReservesAmount Logical Attribute Properties |
| Logical Attribute Name | ProjectedReservesAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| ProjectedReservesAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectedReservesAmount Bound Attachments |
| Name | Current Value |
| ProjectedReservesAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectedReservesAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectedReservesAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectedReservesAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectedReservesAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingPaymentAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | QualifyingPaymentAmount |
| Logical Rolename | |
| ColumnName | QualifyingPaymentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The PITI used to qualify the borrower for a loan, calculated using the investor or regulator specified interest rate that is higher than the initial rate. |
| Note |
| QualifyingPaymentAmount Logical Attribute Properties |
| Logical Attribute Name | QualifyingPaymentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| QualifyingPaymentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| QualifyingPaymentAmount Bound Attachments |
| Name | Current Value |
| QualifyingPaymentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| QualifyingPaymentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingPaymentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingPaymentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingPaymentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRatePercent |
| Base Entity | QUALIFICATION |
| Attribute Name | QualifyingRatePercent |
| Logical Rolename | |
| ColumnName | QualifyingRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The rate used to calculate the borrowers payment (PITI) to qualify the borrower for the subject mortgage. |
| Note |
| QualifyingRatePercent Logical Attribute Properties |
| Logical Attribute Name | QualifyingRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| QualifyingRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| QualifyingRatePercent Bound Attachments |
| Name | Current Value |
| QualifyingRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| QualifyingRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateType |
| Base Entity | QUALIFICATION |
| Attribute Name | QualifyingRateType |
| Logical Rolename | |
| ColumnName | QualifyingRateType |
| RoleName | |
| Domain | QualifyingRateEnum |
| Definition | Indicates what interest rate was used to qualify the borrower in correlation with the note rate. |
| Note |
| QualifyingRateType Logical Attribute Properties |
| Logical Attribute Name | QualifyingRateType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| QualifyingRateType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| QualifyingRateType Reference Value (Bound to Domain) |
| Name | ValidationRule409 |
| Description | |
| Type | By List |
| Value | Value Description |
| AboveNoteRate | AboveNoteRate |
| AtNoteRate | AtNoteRate |
| BelowNoteRate | BelowNoteRate |
| BoughtDownRate | BoughtDownRate |
| Other | Other |
| QualifyingRateType Bound Attachments |
| Name | Current Value |
| QualifyingRateType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| QualifyingRateType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateTypeOtherDescription |
| Base Entity | QUALIFICATION |
| Attribute Name | QualifyingRateTypeOtherDescription |
| Logical Rolename | |
| ColumnName | QualifyingRateTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the Qualifying Rate type if Other is selected. |
| Note |
| QualifyingRateTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | QualifyingRateTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| QualifyingRateTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| QualifyingRateTypeOtherDescription Bound Attachments |
| Name | Current Value |
| QualifyingRateTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| QualifyingRateTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualifyingRateTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SummaryInterestedPartyContributionsPercent |
| Base Entity | QUALIFICATION |
| Attribute Name | SummaryInterestedPartyContributionsPercent |
| Logical Rolename | |
| ColumnName | SummaryInterestedPartyContributionsPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Percentage of the loan amount contributed by all interested parties. This may be captured on the Uniform Underwriting Transmittal Summary (1008/1077). CALCULATED RESULTS and FORM SPECIFIC |
| Note |
| SummaryInterestedPartyContributionsPercent Logical Attribute Properties |
| Logical Attribute Name | SummaryInterestedPartyContributionsPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| SummaryInterestedPartyContributionsPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SummaryInterestedPartyContributionsPercent Bound Attachments |
| Name | Current Value |
| SummaryInterestedPartyContributionsPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SummaryInterestedPartyContributionsPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SummaryInterestedPartyContributionsPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SummaryInterestedPartyContributionsPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SummaryInterestedPartyContributionsPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalDebtExpenseRatioPercent |
| Base Entity | QUALIFICATION |
| Attribute Name | TotalDebtExpenseRatioPercent |
| Logical Rolename | |
| ColumnName | TotalDebtExpenseRatioPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The ratio of all debt payments of the borrowers, including proposed housing expenses, to the qualifying income of the borrowers. AKA Back End Ratio. CALCULATED RESULT FIELD |
| Note |
| TotalDebtExpenseRatioPercent Logical Attribute Properties |
| Logical Attribute Name | TotalDebtExpenseRatioPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TotalDebtExpenseRatioPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalDebtExpenseRatioPercent Bound Attachments |
| Name | Current Value |
| TotalDebtExpenseRatioPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalDebtExpenseRatioPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalDebtExpenseRatioPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalDebtExpenseRatioPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalDebtExpenseRatioPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalLiabilitiesMonthlyPaymentAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | TotalLiabilitiesMonthlyPaymentAmount |
| Logical Rolename | |
| ColumnName | TotalLiabilitiesMonthlyPaymentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total monthly liabilities for all borrowers on the loan. CALCULATED RESULTS FIELD. |
| Note |
| TotalLiabilitiesMonthlyPaymentAmount Logical Attribute Properties |
| Logical Attribute Name | TotalLiabilitiesMonthlyPaymentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TotalLiabilitiesMonthlyPaymentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalLiabilitiesMonthlyPaymentAmount Bound Attachments |
| Name | Current Value |
| TotalLiabilitiesMonthlyPaymentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalLiabilitiesMonthlyPaymentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalLiabilitiesMonthlyPaymentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalLiabilitiesMonthlyPaymentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalLiabilitiesMonthlyPaymentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyCurrentHousingExpenseAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | TotalMonthlyCurrentHousingExpenseAmount |
| Logical Rolename | |
| ColumnName | TotalMonthlyCurrentHousingExpenseAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total monthly current housing expense for all borrowers on the loan. CALCULATED RESULTS FIELD. |
| Note |
| TotalMonthlyCurrentHousingExpenseAmount Logical Attribute Properties |
| Logical Attribute Name | TotalMonthlyCurrentHousingExpenseAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TotalMonthlyCurrentHousingExpenseAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalMonthlyCurrentHousingExpenseAmount Bound Attachments |
| Name | Current Value |
| TotalMonthlyCurrentHousingExpenseAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalMonthlyCurrentHousingExpenseAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyCurrentHousingExpenseAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyCurrentHousingExpenseAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyCurrentHousingExpenseAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyIncomeAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | TotalMonthlyIncomeAmount |
| Logical Rolename | |
| ColumnName | TotalMonthlyIncomeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total monthly income for all borrowers on the loan. CALCULATED RESULTS FIELD. |
| Note |
| TotalMonthlyIncomeAmount Logical Attribute Properties |
| Logical Attribute Name | TotalMonthlyIncomeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TotalMonthlyIncomeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalMonthlyIncomeAmount Bound Attachments |
| Name | Current Value |
| TotalMonthlyIncomeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalMonthlyIncomeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyIncomeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyIncomeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyIncomeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyProposedHousingExpenseAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | TotalMonthlyProposedHousingExpenseAmount |
| Logical Rolename | |
| ColumnName | TotalMonthlyProposedHousingExpenseAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total monthly proposed housing expense for all borrowers on the loan. CALCULATED RESULTS FIELD. |
| Note |
| TotalMonthlyProposedHousingExpenseAmount Logical Attribute Properties |
| Logical Attribute Name | TotalMonthlyProposedHousingExpenseAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TotalMonthlyProposedHousingExpenseAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalMonthlyProposedHousingExpenseAmount Bound Attachments |
| Name | Current Value |
| TotalMonthlyProposedHousingExpenseAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalMonthlyProposedHousingExpenseAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyProposedHousingExpenseAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyProposedHousingExpenseAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMonthlyProposedHousingExpenseAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalVerifiedReservesAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | TotalVerifiedReservesAmount |
| Logical Rolename | |
| ColumnName | TotalVerifiedReservesAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The actual dollar amount of remaining verified liquid assets after settlement. CALCULATED RESULTS FIELD |
| Note |
| TotalVerifiedReservesAmount Logical Attribute Properties |
| Logical Attribute Name | TotalVerifiedReservesAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TotalVerifiedReservesAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalVerifiedReservesAmount Bound Attachments |
| Name | Current Value |
| TotalVerifiedReservesAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalVerifiedReservesAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalVerifiedReservesAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalVerifiedReservesAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalVerifiedReservesAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedAssetsTotalAmount |
| Base Entity | QUALIFICATION |
| Attribute Name | VerifiedAssetsTotalAmount |
| Logical Rolename | |
| ColumnName | VerifiedAssetsTotalAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total amount of all assets of the borrowers that have been verified by the lender. This may be used on the Uniform Underwritting Transmittal Summary. Calculated results field. |
| Note |
| VerifiedAssetsTotalAmount Logical Attribute Properties |
| Logical Attribute Name | VerifiedAssetsTotalAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VerifiedAssetsTotalAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VerifiedAssetsTotalAmount Bound Attachments |
| Name | Current Value |
| VerifiedAssetsTotalAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VerifiedAssetsTotalAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedAssetsTotalAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedAssetsTotalAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedAssetsTotalAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |