| AdditionalBorrowerAssetsConsideredIndicator |
| Base Entity | URLA_DETAIL |
| Attribute Name | AdditionalBorrowerAssetsConsideredIndicator |
| Logical Rolename | |
| ColumnName | AdditionalBorrowerAssetsConsideredIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | A text field used to specify the Unplatted Description Type when "Other" is selected from the enumerated list. |
| Note |
| AdditionalBorrowerAssetsConsideredIndicator Logical Attribute Properties |
| Logical Attribute Name | AdditionalBorrowerAssetsConsideredIndicator |
| Datatype | BIT |
| Nullable | NO |
| AdditionalBorrowerAssetsConsideredIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdditionalBorrowerAssetsConsideredIndicator Bound Attachments |
| Name | Current Value |
| AdditionalBorrowerAssetsConsideredIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdditionalBorrowerAssetsConsideredIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalBorrowerAssetsConsideredIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalBorrowerAssetsConsideredIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalBorrowerAssetsConsideredIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalBorrowerAssetsNotConsideredIndicator |
| Base Entity | URLA_DETAIL |
| Attribute Name | AdditionalBorrowerAssetsNotConsideredIndicator |
| Logical Rolename | |
| ColumnName | AdditionalBorrowerAssetsNotConsideredIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | The income or assets of a person other than the borrower (including the spouse of the borrower ) will be used as a basis for loan qualification. |
| Note |
| AdditionalBorrowerAssetsNotConsideredIndicator Logical Attribute Properties |
| Logical Attribute Name | AdditionalBorrowerAssetsNotConsideredIndicator |
| Datatype | BIT |
| Nullable | NO |
| AdditionalBorrowerAssetsNotConsideredIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdditionalBorrowerAssetsNotConsideredIndicator Bound Attachments |
| Name | Current Value |
| AdditionalBorrowerAssetsNotConsideredIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdditionalBorrowerAssetsNotConsideredIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalBorrowerAssetsNotConsideredIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalBorrowerAssetsNotConsideredIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalBorrowerAssetsNotConsideredIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AlterationsImprovementsAndRepairsAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | AlterationsImprovementsAndRepairsAmount |
| Logical Rolename | |
| ColumnName | AlterationsImprovementsAndRepairsAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The income or assets of the borrowers spouse will not be used as a basis for loan qualification, but his or her liabilities must be considered because the borrower resides in a community property state, the security property is located in a community prop |
| Note |
| AlterationsImprovementsAndRepairsAmount Logical Attribute Properties |
| Logical Attribute Name | AlterationsImprovementsAndRepairsAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AlterationsImprovementsAndRepairsAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AlterationsImprovementsAndRepairsAmount Bound Attachments |
| Name | Current Value |
| AlterationsImprovementsAndRepairsAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AlterationsImprovementsAndRepairsAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AlterationsImprovementsAndRepairsAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AlterationsImprovementsAndRepairsAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AlterationsImprovementsAndRepairsAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationSignedByLoanOriginatorDate |
| Base Entity | URLA_DETAIL |
| Attribute Name | ApplicationSignedByLoanOriginatorDate |
| Logical Rolename | |
| ColumnName | ApplicationSignedByLoanOriginatorDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The cost of any alterations, improvements, repairs and rehabilitation to be made on the subject property. Collected on the URLA in Section VII line b. |
| Note |
| ApplicationSignedByLoanOriginatorDate Logical Attribute Properties |
| Logical Attribute Name | ApplicationSignedByLoanOriginatorDate |
| Datatype | DATE |
| Nullable | NO |
| ApplicationSignedByLoanOriginatorDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ApplicationSignedByLoanOriginatorDate Bound Attachments |
| Name | Current Value |
| ApplicationSignedByLoanOriginatorDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ApplicationSignedByLoanOriginatorDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationSignedByLoanOriginatorDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationSignedByLoanOriginatorDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationSignedByLoanOriginatorDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARMTypeDescription |
| Base Entity | URLA_DETAIL |
| Attribute Name | ARMTypeDescription |
| Logical Rolename | |
| ColumnName | ARMTypeDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | The date on which the Loan Originator obtained HMDA information and signed the loan application. Collected on the URLA in Section X (Interviewers Signature Date). |
| Note |
| ARMTypeDescription Logical Attribute Properties |
| Logical Attribute Name | ARMTypeDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ARMTypeDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ARMTypeDescription Bound Attachments |
| Name | Current Value |
| ARMTypeDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ARMTypeDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARMTypeDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARMTypeDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARMTypeDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationTakenMethodType |
| Base Entity | URLA_DETAIL |
| Attribute Name | ApplicationTakenMethodType |
| Logical Rolename | |
| ColumnName | ApplicationTakenMethodType |
| RoleName | |
| Domain | ApplicationTakenMethodEnum |
| Definition | A free-form text field used to collect additional information or a description of the ARM program. Collected on the URLA in Section I (Amortization Type:ARM). |
| Note |
| ApplicationTakenMethodType Logical Attribute Properties |
| Logical Attribute Name | ApplicationTakenMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ApplicationTakenMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ApplicationTakenMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule17 |
| Description | |
| Type | By List |
| Value | Value Description |
| FaceToFace | Application was taken in a face to face inter . |
| Fax | Fax |
| Internet | Application taken via the internet. |
| Application was taken by mail | |
| Telephone | Application was taken over the telephone. |
| ApplicationTakenMethodType Bound Attachments |
| Name | Current Value |
| ApplicationTakenMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ApplicationTakenMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationTakenMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationTakenMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationTakenMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerPaidDiscountPointsTotalAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | BorrowerPaidDiscountPointsTotalAmount |
| Logical Rolename | |
| ColumnName | BorrowerPaidDiscountPointsTotalAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount of discount points that are paid by the borrower. Collected on the URLA in Section VII line h. |
| Note |
| BorrowerPaidDiscountPointsTotalAmount Logical Attribute Properties |
| Logical Attribute Name | BorrowerPaidDiscountPointsTotalAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BorrowerPaidDiscountPointsTotalAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerPaidDiscountPointsTotalAmount Bound Attachments |
| Name | Current Value |
| BorrowerPaidDiscountPointsTotalAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerPaidDiscountPointsTotalAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerPaidDiscountPointsTotalAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerPaidDiscountPointsTotalAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerPaidDiscountPointsTotalAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedInterestRatePercent |
| Base Entity | URLA_DETAIL |
| Attribute Name | BorrowerRequestedInterestRatePercent |
| Logical Rolename | |
| ColumnName | BorrowerRequestedInterestRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The interest rate that is being requested on the loan application. Collected on the URLA in Section I (Interest Rate). |
| Note |
| BorrowerRequestedInterestRatePercent Logical Attribute Properties |
| Logical Attribute Name | BorrowerRequestedInterestRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BorrowerRequestedInterestRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerRequestedInterestRatePercent Bound Attachments |
| Name | Current Value |
| BorrowerRequestedInterestRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerRequestedInterestRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedInterestRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedInterestRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedInterestRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedLoanAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | BorrowerRequestedLoanAmount |
| Logical Rolename | |
| ColumnName | BorrowerRequestedLoanAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount of the mortgage note being originated that is being requested by the borrower. This amount may include financed PMI, MIP and Funding Fees. It is collected on the URLA in Section I (Amount) and in Section VII line o. |
| Note |
| BorrowerRequestedLoanAmount Logical Attribute Properties |
| Logical Attribute Name | BorrowerRequestedLoanAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BorrowerRequestedLoanAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerRequestedLoanAmount Bound Attachments |
| Name | Current Value |
| BorrowerRequestedLoanAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerRequestedLoanAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedLoanAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedLoanAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerRequestedLoanAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EstimatedClosingCostsAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | EstimatedClosingCostsAmount |
| Logical Rolename | |
| ColumnName | EstimatedClosingCostsAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the estimated loan fees, title fees, appraisal fees and other closing costs associated with the subject transaction excluding discount points. Collected on the URLA in Section VII line f. |
| Note |
| EstimatedClosingCostsAmount Logical Attribute Properties |
| Logical Attribute Name | EstimatedClosingCostsAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| EstimatedClosingCostsAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EstimatedClosingCostsAmount Bound Attachments |
| Name | Current Value |
| EstimatedClosingCostsAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EstimatedClosingCostsAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EstimatedClosingCostsAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EstimatedClosingCostsAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EstimatedClosingCostsAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderRegistrationIdentifier |
| Base Entity | URLA_DETAIL |
| Attribute Name | LenderRegistrationIdentifier |
| Logical Rolename | |
| ColumnName | LenderRegistrationIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | A tracking number assigned by the wholesale lender to identify the loan for pipeline management. |
| Note |
| LenderRegistrationIdentifier Logical Attribute Properties |
| Logical Attribute Name | LenderRegistrationIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LenderRegistrationIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LenderRegistrationIdentifier Bound Attachments |
| Name | Current Value |
| LenderRegistrationIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LenderRegistrationIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderRegistrationIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderRegistrationIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderRegistrationIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeFinancedAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | MIAndFundingFeeFinancedAmount |
| Logical Rolename | |
| ColumnName | MIAndFundingFeeFinancedAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of private mortgage insurance premium, FHA up-front MI Premium or VA funding fee that is rolled into loan amount. Used if PMI / MIP / VA funding fee will be added to loan amount. Collected on the URLA in Section VII line n. |
| Note |
| MIAndFundingFeeFinancedAmount Logical Attribute Properties |
| Logical Attribute Name | MIAndFundingFeeFinancedAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| MIAndFundingFeeFinancedAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MIAndFundingFeeFinancedAmount Bound Attachments |
| Name | Current Value |
| MIAndFundingFeeFinancedAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MIAndFundingFeeFinancedAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeFinancedAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeFinancedAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeFinancedAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeTotalAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | MIAndFundingFeeTotalAmount |
| Logical Rolename | |
| ColumnName | MIAndFundingFeeTotalAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total amount paid to initiate private mortgage insurance, FHA up-front MI premium or the VA funding fee. Collected on the URLA in Section VII line g. |
| Note |
| MIAndFundingFeeTotalAmount Logical Attribute Properties |
| Logical Attribute Name | MIAndFundingFeeTotalAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| MIAndFundingFeeTotalAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MIAndFundingFeeTotalAmount Bound Attachments |
| Name | Current Value |
| MIAndFundingFeeTotalAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MIAndFundingFeeTotalAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeTotalAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeTotalAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIAndFundingFeeTotalAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaidItemsEstimatedAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | PrepaidItemsEstimatedAmount |
| Logical Rolename | |
| ColumnName | PrepaidItemsEstimatedAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of escrow / impound to be held by the lender, which is to be collected at closing for future payment of taxes, insurance or other obligations on the subject property. Collected on the URLA in Section VII line e. |
| Note |
| PrepaidItemsEstimatedAmount Logical Attribute Properties |
| Logical Attribute Name | PrepaidItemsEstimatedAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PrepaidItemsEstimatedAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PrepaidItemsEstimatedAmount Bound Attachments |
| Name | Current Value |
| PrepaidItemsEstimatedAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PrepaidItemsEstimatedAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaidItemsEstimatedAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaidItemsEstimatedAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaidItemsEstimatedAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | PurchasePriceAmount |
| Logical Rolename | |
| ColumnName | PurchasePriceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount paid by the borrower for the property pledged as security for the mortgage. The purchase price is presented on the offer to purchase. |
| Note |
| PurchasePriceAmount Logical Attribute Properties |
| Logical Attribute Name | PurchasePriceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PurchasePriceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PurchasePriceAmount Bound Attachments |
| Name | Current Value |
| PurchasePriceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PurchasePriceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceNetAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | PurchasePriceNetAmount |
| Logical Rolename | |
| ColumnName | PurchasePriceNetAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The result of subtracting financing and sales concession amounts above those allowed by guidelines from the Purchase Price Amount of the subject property. CALCULATED RESULTS FIELD |
| Note |
| PurchasePriceNetAmount Logical Attribute Properties |
| Logical Attribute Name | PurchasePriceNetAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PurchasePriceNetAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PurchasePriceNetAmount Bound Attachments |
| Name | Current Value |
| PurchasePriceNetAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PurchasePriceNetAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceNetAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceNetAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PurchasePriceNetAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementCostsAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | RefinanceImprovementCostsAmount |
| Logical Rolename | |
| ColumnName | RefinanceImprovementCostsAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount of improvements either made or to be made at time of refinance. Collected on the URLA in Section II Describe Improvements Costs. |
| Note |
| RefinanceImprovementCostsAmount Logical Attribute Properties |
| Logical Attribute Name | RefinanceImprovementCostsAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RefinanceImprovementCostsAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RefinanceImprovementCostsAmount Bound Attachments |
| Name | Current Value |
| RefinanceImprovementCostsAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RefinanceImprovementCostsAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementCostsAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementCostsAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementCostsAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementsType |
| Base Entity | URLA_DETAIL |
| Attribute Name | RefinanceImprovementsType |
| Logical Rolename | |
| ColumnName | RefinanceImprovementsType |
| RoleName | |
| Domain | RefinanceImprovementsEnum |
| Definition | Specifies whether the improvements associated with a refinance have been made to the property or if they are planned. Collected on the URLA in Section II (Refinance - Describe Improvements - Check Box.) |
| Note |
| RefinanceImprovementsType Logical Attribute Properties |
| Logical Attribute Name | RefinanceImprovementsType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| RefinanceImprovementsType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RefinanceImprovementsType Reference Value (Bound to Domain) |
| Name | ValidationRule421 |
| Description | |
| Type | By List |
| Value | Value Description |
| Made | Made |
| ToBeMade | ToBeMade |
| Unknown | Unknown |
| RefinanceImprovementsType Bound Attachments |
| Name | Current Value |
| RefinanceImprovementsType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RefinanceImprovementsType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementsType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementsType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceImprovementsType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceIncludingDebtsToBePaidOffAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | RefinanceIncludingDebtsToBePaidOffAmount |
| Logical Rolename | |
| ColumnName | RefinanceIncludingDebtsToBePaidOffAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total amount of all debt to be repaid with funds from refinancing the mortgage loan on the subject property. Collected on the URLA in Section VII line d. |
| Note |
| RefinanceIncludingDebtsToBePaidOffAmount Logical Attribute Properties |
| Logical Attribute Name | RefinanceIncludingDebtsToBePaidOffAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RefinanceIncludingDebtsToBePaidOffAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RefinanceIncludingDebtsToBePaidOffAmount Bound Attachments |
| Name | Current Value |
| RefinanceIncludingDebtsToBePaidOffAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RefinanceIncludingDebtsToBePaidOffAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceIncludingDebtsToBePaidOffAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceIncludingDebtsToBePaidOffAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceIncludingDebtsToBePaidOffAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProposedImprovementsDescription |
| Base Entity | URLA_DETAIL |
| Attribute Name | RefinanceProposedImprovementsDescription |
| Logical Rolename | |
| ColumnName | RefinanceProposedImprovementsDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture additional information text entries on the URLA associated with the improvements to be made on property being refinanced. Collected on the URLA in Section II (Refinance - Describe Improvements To Be Made). |
| Note |
| RefinanceProposedImprovementsDescription Logical Attribute Properties |
| Logical Attribute Name | RefinanceProposedImprovementsDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| RefinanceProposedImprovementsDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RefinanceProposedImprovementsDescription Bound Attachments |
| Name | Current Value |
| RefinanceProposedImprovementsDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RefinanceProposedImprovementsDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProposedImprovementsDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProposedImprovementsDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProposedImprovementsDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundableApplicationFeeIndicator |
| Base Entity | URLA_DETAIL |
| Attribute Name | RefundableApplicationFeeIndicator |
| Logical Rolename | |
| ColumnName | RefundableApplicationFeeIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the Application Fee is refundable. |
| Note |
| RefundableApplicationFeeIndicator Logical Attribute Properties |
| Logical Attribute Name | RefundableApplicationFeeIndicator |
| Datatype | BIT |
| Nullable | NO |
| RefundableApplicationFeeIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RefundableApplicationFeeIndicator Bound Attachments |
| Name | Current Value |
| RefundableApplicationFeeIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RefundableApplicationFeeIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundableApplicationFeeIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundableApplicationFeeIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundableApplicationFeeIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RequiredDepositIndicator |
| Base Entity | URLA_DETAIL |
| Attribute Name | RequiredDepositIndicator |
| Logical Rolename | |
| ColumnName | RequiredDepositIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether a deposit balance is required to be maintained at an account at the lending institution as a condition of the loan. This does not affect the Annual Percentage Rate or any fees. This is disclosed on the Truth in Lending Disclosure. Move t |
| Note |
| RequiredDepositIndicator Logical Attribute Properties |
| Logical Attribute Name | RequiredDepositIndicator |
| Datatype | BIT |
| Nullable | NO |
| RequiredDepositIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RequiredDepositIndicator Bound Attachments |
| Name | Current Value |
| RequiredDepositIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RequiredDepositIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RequiredDepositIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RequiredDepositIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RequiredDepositIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SellerPaidClosingCostsAmount |
| Base Entity | URLA_DETAIL |
| Attribute Name | SellerPaidClosingCostsAmount |
| Logical Rolename | |
| ColumnName | SellerPaidClosingCostsAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The estimated closing costs that the seller of the subject property will pay. Collected on the URLA in Section VII line k. |
| Note |
| SellerPaidClosingCostsAmount Logical Attribute Properties |
| Logical Attribute Name | SellerPaidClosingCostsAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| SellerPaidClosingCostsAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SellerPaidClosingCostsAmount Bound Attachments |
| Name | Current Value |
| SellerPaidClosingCostsAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SellerPaidClosingCostsAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SellerPaidClosingCostsAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SellerPaidClosingCostsAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SellerPaidClosingCostsAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |