Logical data dictionary

Note: This page may take up to several minutes to display due to its size.

Version 1.0
Generated on 7/7/00
Copyright 2000 Mortgage Bankers Association of America, Inc.

Permission to use, copy, modify, and distribute the MISMO
DTD and its accompanying documentation for any purpose and without
fee is hereby granted in perpetuity, provided that the above copyright
notice and this paragraph appear in all copies. The copyright holders make
no representation about the suitability of the DTD for any purpose.

Processes included in this dictionary:

Credit Reporting, MI, Secondary, Underwriting, Service ordering

Name	Description	Source	Context	Processes	Datatype
Agency Case Identifier	The FHA-assigned case number for FHA loans or VA-assigned case number for VA loans. The number is used by the FHA or VA to identify a loan. Collected on the URLA in Section I (Agency Case Number).	URLA	Application	Underwriting	Numeric
Alimony Child Support Obligations Indicator	Borrowers declaration regarding obligations for alimony, child support, etc. Collected on the URLA in Section VIII line g.	URLA	Declarations	Credit Reporting, Underwriting	Boolean
Alimony Owed To Name	The unstructured name of the person to whom alimony payments are owed by the borrower. Collected on the URLA in Section VI (Liabilities Alimony Owed To).	URLA	Liability	Underwriting	String
Alterations Improvements and Repairs Conventional Amount	The cost of any alterations, improvements, repairs and rehabilitation to be made on the subject property. Collected on the URLA in Section II((b)Cost of Improvements) for construction loans and refinance loans. Also collected on the URLA in Section VII line b.	URLA	Application	Underwriting	Money
Alterations Improvements and Repairs FHA/VA Amount	The dollar amount of improvements and repairs to be financed by the borrower, if reflected in the appraised value or if required by the appraiser for VA/FHA loans. Collected on the URLA in Section VII line b.	URLA	Application	Underwriting	Money
Annual Percentage Rate Percent	The annual percentage rate (APR) for this loan.	(not specified)	(not specified)	Secondary	Numeric
Application Interviewer Signed Date	The date on which the interviewer obtained HMDA information and signed the loan application. Collected on the URLA in Section X (Interviewers Signature Date).	URLA	Parties to Transaction	Credit Reporting, Underwriting	Date/Time
Application Taken Method Type	Specifies the method used to take the application as determined by the interviewer. Collected on the URLA in Section X (This Application Was Taken By).	URLA	Application	Credit Reporting, Underwriting	Enumerated: Face-to-face: Application was taken in a face to face interview. Mail: Application was taken by mail Telephone: Application was taken over the telephone.
Appraisal Effective Date	Effective date of the appraisal report on the subject property.	Valuation	Appraisal	Service ordering, Underwriting	Date/Time
Appraisal Method Type	Method used by the appraiser to arrive at the appraised value.	Valuation	Appraisal	Service ordering, MI, Underwriting	Enumerated: Automated Valuation Method: Broker's Price Opinion: Drive By: Full Appraisal:
Appraisal Property Condition Type	Indicates status of property and conditions under which the appraiser estimated value.	Valuation	Appraisal	Service ordering, MI, Underwriting	Enumerated: As Is: Subject to Completion per Plans and Specifications: Subject To Repairs Alterations Inspections Or Conditions:
Appraiser License Identifier	State license number of the appraiser who completed the final estimate of value for the subject property.	Valuation	Appraisal	MI, Underwriting	String
Appraiser Name	Full name of the appraiser who completed the final estimate of value for the subject property.	Valuation	Appraisal	MI, Underwriting	String
ARM Conversion Option Indicator	Indicates whether the adjustable rate mortgage (ARM) has the option to convert to a fixed rate mortgage.	LP	Product	Underwriting	Boolean
ARM Index Current Value Percent	The current value stated as a percent of the index used to calculate the initial interest rate for an adjustable rate mortgage. Could be the value of the index as of the closing date or if the loan has not closed the current index rate.	LP	Product	MI, Underwriting	Numeric(8,7)
ARM Index Margin Percent	The percentage stated in the loan program representing the spread between the ARM Index value and the mortgage interest rate. The gross mortgage margin is added to the index value to establish a new gross coupon rate.	Lender	Product	MI, Underwriting	Numeric(8,7)
ARM Index Type	Specifies the type of index to be used to determine the interest rate at each adjustment.	LP	Product	MI, Underwriting	Enumerated: 1 Year Treasury: 11th District Cost of Funds: 3 Year Treasury: 6-Month Treasury Bill: Daily Certificate of Deposit Rate: Fannie Mae 60-Day Required Net Yield: Fannie Mae LIBOR: Federal Cost of Funds: Freddie Mac 60-Day Required Net Yield: Freddie Mac LIBOR: London Interbank Offered Rate: Monthly Average Constant Maturing Treasury: National Average Contract Rate (FHLBB): National Monthly Median Cost of Funds: Other: Treasury Bill Daily Value: Wall Street Journal LIBOR: Weekly Average Certificate of Deposit Rate: Weekly Average Constant Maturing Treasury: Weekly Average Prime Rate: Weekly Average Secondary Market Treasury Bill - Investment Yield: Weekly Average Treasury Auction Average - Bond Discount Yield: Weekly Treasury Auction Average - Investment Yield:
ARM Qualifying Rate Percent	The rate used to calculate the borrowers PITI to qualify the borrower for the subject mortgage for ARM loans.	Lender	Product	MI, Underwriting	Numeric(8,7)
Arms Length Indicator	Indicates whether the loan transaction can be described as an arms length transaction. An arms length transaction is defined as a transaction in which the parties involved are entirely independent of each other, deal with each other as strangers, and have no reason for collusion.	LP	UW Case	Underwriting	Boolean
Asset Account Identifier	A unique identifier of the borrowers asset. Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Cash or Market Value Amount	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 neither being under any compulsion to buy or sell. (e.g., IBMs closing quote) Market value and cash values tend to be equal. Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	Money
Asset Description	A free-form text field used to capture additional information or a description of the borrowers asset. Collected on the URLA in Section VI (Assets - Other Assets Itemize).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Face Value Amount	The dollar amount of the face value of the borrowers Asset Type. The face value is the par value or actual selling price of the asset or the amount the issuer contracts to repay. (Collected on the URLA in Section VI (Assets - Face Amount Life Insurance).	URLA	Asset	Credit Reporting, Underwriting	Money
Asset Holder Address 1	The unstructured street address of the individual or institution holding the borrowers asset (e.g., checking). Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Holder Address 2	The unit or suite number (if any) of the address of the individual or institution holding the borrowers asset. Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Holder City	The city in which the individual or institution holding borrowers asset is located. Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Holder Country	The country in which the individual or institution holding the borrowers asset is located if not the U.S.A. Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Holder Name	The unstructured name of the individual or institution that holds the borrowers asset (e.g., bank name for checking account). Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Holder Postal Code	The postal code (zip code) of the address of the individual or institution holding the borrowers asset. Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Holder State	The state in which the individual or institution holding the borrowers asset is located. Collected on the URLA in Section VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	String
Asset Net Cash Value Amount	The dollar amount of the net cash value of the borrowers Asset Type. The net cash value is the market value of an asset less any required reductions. (E.g., value of IRA after paying taxes, penalties and loans) Collected on the URLA in Section VI (Assets - Life Insurance Net Cash Value).	URLA	Asset	Credit Reporting, Underwriting	Money
Asset Type	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 VI (Assets).	URLA	Asset	Credit Reporting, Underwriting	Enumerated: 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) & market (e.g., value of 4% bond when yields are 6%). Collected on the URLA in Section VI (Assets - Stocks & Bonds). Bridge Loan Not Deposited: Proceeds of a loan (secured by borrowers present house) to provide homebuyer with funds for down payment & closing costs on a new home before selling present house, which have not yet been deposited to borrowers accounts or included with other assets disclosed. Collected on the URLA in Section VI (Assets - Other Assets). Cash On Hand: Currency physically possessed by borrower, not deposited in any financial institution. Considered liquid. Collected on the URLA in Section VI (Assets - Other Assets). Certificate of Deposit / Time Deposit: 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 VI (Assets). Checking Account: 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 in Section VI (Assets - Checking Account). Earnest Money Cash Deposit Toward Purchase: 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). Gifts Not Deposited: 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 Assets). Grants Not Deposited: 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 on the URLA in Section VI (Assets - Other Assets). Life Insurance: 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 that amount. Detail of amounts for each policy collected on URLA in Section VI (Assets - Life Insurance Net Cash Value). Money Market Fund: 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). Mutual Fund : 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 & Bonds). Net Worth of Business Owned: 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 Liquid Assets: General category to disclose detail of other borrower assets that have a ready market where a quick sale would yield the amount disclosed (e.g., commodity contract, certain currencies or coins). Typically has free text description. Collected on the URLA in Section VI (Assets - Other Assets). Other Non-Liquid Assets: General category to disclose detail of other borrower assets that have little ready market (e.g., statues). Typically has FREE TEXT description. Collected on the URLA in Section VI (Assets - Other Assets). Pending Net Sale Proceeds from Real Estate Assets: Estimated net cash proceeds (sales price - obligations) from anticipated sale of borrowers real estate assets. Real Estate Owned: Market value of real estate owned by the borrower. Collected on the URLA in Section VI (Schedule of Real Estate Owned). Retirement Funds - Total: Sum of all 401ks, IRAs, etc. controlled by borrower(vested) valued at market. Collected on the URLA in Section VI (Assets - Vested Retirement Fund). Savings Account: 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). Secured Borrowed Funds Not Deposited: 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 & Bonds). Trust Account: 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 VI (Assets - Other Assets).
Asset Verification Status Type	Specifies the verification status associated with the borrowers corresponding asset type.	Lender	Asset	Credit Reporting, Underwriting	Enumerated: Not Verified: Data related to the asset has not been verified. To Be Verified: Data related to the asset is to be verified, but has not been verified. Verified: Data related to the asset has been verified.
Asset Verified By Name	The name or initials of the person who verified information in the record.	Credit Report	Credit	Credit Reporting	String
Asset Verified Comment	Any remarks by the person specified in the Verified By person about the data in the record.	Credit Report	Credit	Credit Reporting	String
Asset Verified Date	The date that the information in the record was verified.	Credit Report	Credit	Credit Reporting	Date/Time
Asset Vested Value Amount	The vested dollar amount of the borrowers Asset Type. A vested interest is a legal claim or right to the present or future enjoyment of the asset. (E.g. Typically borrowers 401K or similar retirement plan.) Collected on the URLA in Section VI (Assets Vested Interest in Retirement Fund).	URLA	Asset	Credit Reporting, Underwriting	Money
Authorized Representative Name	The unstructured name of the authorized representative employed by the lender.	Lender	Parties To Transaction	MI	String
Automobile Make Description	A free-form text field used to capture the make and model of borrowers vehicle disclosed as asset. Collected on the URLA in Section VI Assets (Automobiles Owned).	URLA	Asset	Credit Reporting, Underwriting	String
Automobile Model Year	A free-form text field used to capture the model year of borrowers vehicle disclosed as asset. Collected on the URLA in Section VI Assets (Automobiles Owned).	URLA	Asset	Credit Reporting, Underwriting	String
Bankruptcy Past Seven Years Indicator	Borrowers answer to the question: Have you been declared bankrupt within the past 7 years? Collected on the URLA in Section VII line b.	URLA	Declarations	Credit Reporting, Secondary, Underwriting	Boolean
Base Loan Amount	The base loan amount to be loaned to the borrower not including PMI, MIP, or Funding Fee. Collected on the URLA in Section VII line m.	URLA	Application	Service ordering, MI, Underwriting	Money
Basis for Loan Qualification Type	A statement made by two borrowers on a single loan application indicating whether or not the income and assets of another person (including spouse) will be used as a basis for loan qualification. Collected on the URLA in the Header Paragraph - Check Box.	URLA	Application	Underwriting	Enumerated: Income and assets of a person/s other than the borrower will be used: The income or assets of a person other than the borrower (including the borrower’s spouse) will be used as a basis for loan qualification Income and assets of person/s other than the borrower will not be used: The income or assets of the borrower’s 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 pro
Below Market Subordinate Financing Provided Indicator	Indicates whether the seller provided below-market subordinat