| AssetAccountIdentifier |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetAccountIdentifier |
| Logical Rolename | |
| ColumnName | AssetAccountIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | A unique identifier of the borrowers asset. Collected on the URLA in Section VI (Assets). |
| Note |
| AssetAccountIdentifier Logical Attribute Properties |
| Logical Attribute Name | AssetAccountIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AssetAccountIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetAccountIdentifier Bound Attachments |
| Name | Current Value |
| AssetAccountIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetAccountIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountInNameOfDescription |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetAccountInNameOfDescription |
| Logical Rolename | |
| ColumnName | AssetAccountInNameOfDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | The name of the persons or entity(ies) in whose name the account is held. |
| Note |
| AssetAccountInNameOfDescription Logical Attribute Properties |
| Logical Attribute Name | AssetAccountInNameOfDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AssetAccountInNameOfDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetAccountInNameOfDescription Bound Attachments |
| Name | Current Value |
| AssetAccountInNameOfDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetAccountInNameOfDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountInNameOfDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountInNameOfDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountInNameOfDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountType |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetAccountType |
| Logical Rolename | |
| ColumnName | AssetAccountType |
| RoleName | |
| Domain | AssetAccountEnum |
| Definition | Specifies the type of account in which the assets are held. Usually used when pledging assets as collateral. |
| Note |
| AssetAccountType Logical Attribute Properties |
| Logical Attribute Name | AssetAccountType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| AssetAccountType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetAccountType Reference Value (Bound to Domain) |
| Name | ValidationRule29 |
| Description | |
| Type | By List |
| Value | Value Description |
| BorrowerManagedAccount | BorrowerManagedAccount |
| Other | Other |
| RelatedPartyManagedAccount | RelatedPartyManagedAccount |
| AssetAccountType Bound Attachments |
| Name | Current Value |
| AssetAccountType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetAccountType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountTypeOtherDescription |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetAccountTypeOtherDescription |
| Logical Rolename | |
| ColumnName | AssetAccountTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Asset Account Type. |
| Note |
| AssetAccountTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | AssetAccountTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AssetAccountTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetAccountTypeOtherDescription Bound Attachments |
| Name | Current Value |
| AssetAccountTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetAccountTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetAccountTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetCashOrMarketValueAmount |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetCashOrMarketValueAmount |
| Logical Rolename | |
| ColumnName | AssetCashOrMarketValueAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the cash or market value of the borrowers Asset Type. The market value is the price at which an asset is transferred between a willing buyer and a willing seller, each of whom has a reasonable knowledge of all pertinent facts and neit |
| Note |
| AssetCashOrMarketValueAmount Logical Attribute Properties |
| Logical Attribute Name | AssetCashOrMarketValueAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AssetCashOrMarketValueAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetCashOrMarketValueAmount Bound Attachments |
| Name | Current Value |
| AssetCashOrMarketValueAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetCashOrMarketValueAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetCashOrMarketValueAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetCashOrMarketValueAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetCashOrMarketValueAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetDescription |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetDescription |
| Logical Rolename | |
| ColumnName | AssetDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A text description that further defines the Asset. This could be used to describe the shares associated with the stocks, bonds or mutual funds, retirement funds or business owned that the borrower has disclosed (named) as an asset. |
| Note |
| AssetDescription Logical Attribute Properties |
| Logical Attribute Name | AssetDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AssetDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetDescription Bound Attachments |
| Name | Current Value |
| AssetDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetLiquidityIndicator |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetLiquidityIndicator |
| Logical Rolename | |
| ColumnName | AssetLiquidityIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the asset is classified as liquid. When false, indicates that the asset is classified as non liquid. |
| Note |
| AssetLiquidityIndicator Logical Attribute Properties |
| Logical Attribute Name | AssetLiquidityIndicator |
| Datatype | BIT |
| Nullable | NO |
| AssetLiquidityIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetLiquidityIndicator Bound Attachments |
| Name | Current Value |
| AssetLiquidityIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetLiquidityIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetLiquidityIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetLiquidityIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetLiquidityIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetType |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetType |
| Logical Rolename | |
| ColumnName | AssetType |
| RoleName | |
| Domain | AssetEnum |
| Definition | Specifies the general names (type) of items commonly listed as financial assets of the borrower(s) in a mortgage loan transaction. Assets may be either liquid or fixed and are associated with a corresponding asset amount. Collected on the URLA in Section |
| Note |
| AssetType Logical Attribute Properties |
| Logical Attribute Name | AssetType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| AssetType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetType Reference Value (Bound to Domain) |
| Name | ValidationRule31 |
| Description | |
| Type | By List |
| Value | Value Description |
| Automobile | Car or similar personal transportation vehicle disclosed as borrowers asset. Usually linked to make or model and year. Typical valuation method is market (blue book). Collected on the URLA in Section VI (Assets). |
| Bond | An interest-bearing certificate of debt with maturity date. An obligation of issuing entity. Typical valuation is face value (e.g., $1,000 denomination) and market (e.g., value of 4% bond when yields are 6%). Collected on the URLA in Section VI (Assets) |
| BorrowerEstimatedTotalAssets | The asset amount used by the lender to qualify the borrower for the loan. |
| BridgeLoanNotDeposited | Proceeds of a loan (secured by borrowers present house) to provide homebuyer with funds for down payment and closing costs on a new home before selling present house, which have not yet been deposited to borrowers accounts or included with other assets disc |
| CashOnHand | Currency physically possessed by borrower, not deposited in any financial institution. Considered liquid. Collected on the URLA in Section VI (Assets - Other Assets). |
| CertificateOfDepositTimeDeposit | Certificates issued by financial institutions with a stated term or interest rate, and with a set maturity date. The bank pays the holder in due course at maturity. Early withdrawal subject to penalty. Considered liquid. Collected on the URLA in Section V |
| CheckingAccount | Transaction account with a financial institution. Accounts purpose is to effect transfer of owners funds to others by various methods (e.g., check, EFT, ACH, draft). Technical name is demand deposit account (DDA). Considered liquid. Collected on the URLA |
| EarnestMoneyCashDepositTowardPurchase | Deposit made to bind the conditions of a real estate sale. Deposited in escrow account controlled by others, so funds cannot be included in disclosure in any other account. Collected on the URLA in Section VI (Assets - Cash Deposit). |
| GiftsNotDeposited | Money given as gift (no repayment expected) to Borrowers to assist in home purchase, usually from relatives or close friend, where gift funds have not yet been deposited or included with other assets. Collected on the URLA in Section VI (Assets - Other As |
| GiftsTotal | The total amount given as a gift either deposited or not, (no repayment expected) to borrowers to assist in home purchase, usually from relatives or close friends. |
| GrantsNotDeposited | Money scheduled to be given as grant (no repayment expected) to Borrowers to assist in home purchase, usually from local organization or charity, where grant funds have not yet been deposited to borrowers accounts or included with other assets. Collected |
| LifeInsurance | A life insurance policy with a value or investment component. Details of amounts for each policy collected on URLA in Section VI (Assets - Life Insurance Face Amount) or Accumulated investment cash value of life insurance policy, net of any loans against |
| MoneyMarketFund | Mutual fund that allows individuals to participate in managed investments in short-term debt securities, such as certificates of deposit and Treasury bills. Considered liquid. Collected on the URLA in Section VI (Assets). |
| MutualFund | Financial entity that invests its shareholders funds in stocks and bonds of other entities with the objective of obtaining a return on its shareholders investment. Collected on the URLA in Section VI (Assets - Stocks and Bonds). |
| NetWorthOfBusinessOwned | For a business owned by borrower, the amount resulting from the calculation Assets minus liabilities. Collected on the URLA in Section VI (Assets - Net Worth of Business). |
| Other | Other |
| PendingNetSaleProceedsFromRealEstateAssets | Estimated net cash proceeds (sales price - obligations) from anticipated sale of borrowers real estate assets. |
| RealEstateOwned | Market value of real estate owned by the borrower. Collected on the URLA in Section VI (Schedule of Real Estate Owned). |
| RelocationMoney | The funds that are being contributed by an outside party to be added to the closing funds. The Asset value is necessary for multiple borrowers, who each may have their own credit. |
| RetirementFund | 401Ks, IRAs, etc. controlled by borrower (vested) valued at market. Collected on the URLA in Section VI (Assets - Vested Retirement Fund). |
| SaleOtherAssets | The amount that will be applied to closing funds from the sale of assets not otherwise identified. |
| SavingsAccount | Interest-paying account with a financial institution whose main purpose is to earn interest on owners funds held therein. This is NOT a demand deposit account. Considered liquid. Collected on the URLA in Section VI (Assets - Savings Account). |
| SecuredBorrowedFundsNotDeposited | Proceeds from a loan secured by borrowers assets, which have not yet been deposited to borrowers accounts or included with other assets disclosed. Considered liquid. Collected on the URLA in Section VI (Assets - Other Assets). |
| Stock | Financial instrument evidencing an ownership interest in entity that issued the stock. Typical valuation method is Market. Collected on the URLA in Section VI (Assets - Stocks and Bonds). |
| TrustAccount | Fiduciary relationship where legal title to a property is transferred to a trustee with the intention the property be administered by the trustee for benefit of the beneficiary, who holds equitable title to such property. Collected on the URLA in Section |
| AssetType Bound Attachments |
| Name | Current Value |
| AssetType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetTypeOtherDescription |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AssetTypeOtherDescription |
| Logical Rolename | |
| ColumnName | AssetTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | AssetTypeOtherDescription |
| Note |
| AssetTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | AssetTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AssetTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssetTypeOtherDescription Bound Attachments |
| Name | Current Value |
| AssetTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssetTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssetTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileMakeDescription |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AutomobileMakeDescription |
| Logical Rolename | |
| ColumnName | AutomobileMakeDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | AutomobileMakeDescription |
| Note |
| AutomobileMakeDescription Logical Attribute Properties |
| Logical Attribute Name | AutomobileMakeDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AutomobileMakeDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AutomobileMakeDescription Bound Attachments |
| Name | Current Value |
| AutomobileMakeDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AutomobileMakeDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileMakeDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileMakeDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileMakeDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileModelYear |
| Base Entity | ASSET_DETAIL |
| Attribute Name | AutomobileModelYear |
| Logical Rolename | |
| ColumnName | AutomobileModelYear |
| RoleName | |
| Domain | MISMOYear |
| Definition | AutomobileModelYear |
| Note |
| AutomobileModelYear Logical Attribute Properties |
| Logical Attribute Name | AutomobileModelYear |
| Datatype | DATE |
| Nullable | NO |
| AutomobileModelYear Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AutomobileModelYear Bound Attachments |
| Name | Current Value |
| AutomobileModelYear User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AutomobileModelYear Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileModelYear Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileModelYear Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AutomobileModelYear Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LifeInsuranceFaceValueAmount |
| Base Entity | ASSET_DETAIL |
| Attribute Name | LifeInsuranceFaceValueAmount |
| Logical Rolename | |
| ColumnName | LifeInsuranceFaceValueAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | LifeInsuranceFaceValueAmount |
| Note |
| LifeInsuranceFaceValueAmount Logical Attribute Properties |
| Logical Attribute Name | LifeInsuranceFaceValueAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LifeInsuranceFaceValueAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LifeInsuranceFaceValueAmount Bound Attachments |
| Name | Current Value |
| LifeInsuranceFaceValueAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LifeInsuranceFaceValueAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LifeInsuranceFaceValueAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LifeInsuranceFaceValueAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LifeInsuranceFaceValueAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| StockBondMutualFundShareCount |
| Base Entity | ASSET_DETAIL |
| Attribute Name | StockBondMutualFundShareCount |
| Logical Rolename | |
| ColumnName | StockBondMutualFundShareCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | StockBondMutualFundShareCount |
| Note |
| StockBondMutualFundShareCount Logical Attribute Properties |
| Logical Attribute Name | StockBondMutualFundShareCount |
| Datatype | INTEGER |
| Nullable | NO |
| StockBondMutualFundShareCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| StockBondMutualFundShareCount Bound Attachments |
| Name | Current Value |
| StockBondMutualFundShareCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| StockBondMutualFundShareCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| StockBondMutualFundShareCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| StockBondMutualFundShareCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| StockBondMutualFundShareCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedIndicator |
| Base Entity | ASSET_DETAIL |
| Attribute Name | VerifiedIndicator |
| Logical Rolename | |
| ColumnName | VerifiedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | VerifiedIndicator |
| Note |
| VerifiedIndicator Logical Attribute Properties |
| Logical Attribute Name | VerifiedIndicator |
| Datatype | BIT |
| Nullable | NO |
| VerifiedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VerifiedIndicator Bound Attachments |
| Name | Current Value |
| VerifiedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VerifiedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VerifiedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |