Home Mortgage Disclosure Attributes
Snowflake table name : CYBERSYN.HOME_MORTGAGE_DISCLOSURE_ATTRIBUTES
| Name | Description | Type | Example |
|---|---|---|---|
| Year of mortgage application | VARCHAR |
|
| Legal entity identifier of the institution receiving the mortgage application | VARCHAR |
|
| Name of the financial institution receiving the mortgage application | VARCHAR |
|
| A unique identifier of the Census Tract where the property is located. Joinable to the GEOGRAPHY_INDEX table | VARCHAR |
|
| A unique identifier of the county where the property is located. Joinable to the GEOGRAPHY_INDEX table | VARCHAR |
|
| Name of the county where the property is located | VARCHAR |
|
| A unique identifier of the core based statistical area or metropolitan division where the property is located. Joinable to the GEOGRAPHY_INDEX table | VARCHAR |
|
| Name of the core based statistical area or metropolitan division where the property is located. | VARCHAR |
|
| A unique identifier of the state where the property is located. Joinable to the GEOGRAPHY_INDEX table | VARCHAR |
|
| Name of the state where the property is located | VARCHAR |
|
| Final application decision (e.g., Loan originated, Application denied, etc.) | VARCHAR |
|
| Principal reason for the denial of a mortgage | VARCHAR |
|
| Full array of all reasons for the denial of a mortgage | ARRAY |
|
| Type of entity purchasing a loan from the institution (e.g., Fannie Mae, Freddie Mac, etc.) | VARCHAR |
|
| Purpose for of loan (e.g., Home purchase, Refinancing, etc.) | VARCHAR |
|
| If the application is primarily for a business or commercial purpose | VARCHAR |
|
| Type of loan (Conventional, FHA, VA, RHS, or FSA) | VARCHAR |
|
| If the application involved a request for a pre-approval of a home purchase loan | VARCHAR |
|
| Amount of the loan or amount applied for | NUMBER |
|
| Number of months after which the legal obligation will mature or terminate | NUMBER |
|
| Interest rate of the loan | FLOAT |
|
| Points paid to the creditor to reduce the interest rate (in USD) | NUMBER |
|
| Difference between APR & APOR for a comparable transaction as of the date the rate is set | FLOAT |
|
| Number of months until the first date the interest rate may change after closing or account opening | NUMBER |
|
| If the contractual terms include interest-only payments | VARCHAR |
|
| Gross annual income relied on in making the credit decision (in USD) | NUMBER |
|
| Ratio of the applicant's total monthly debt to the total monthly income | VARCHAR |
|
| Value of the property securing the loan | NUMBER |
|
| Ratio of the total amount of debt secured by the property to the value of the property | NUMBER |
|
| Lien status of the property securing the loan | VARCHAR |
|
| Amount of lender credits (in USD) | NUMBER |
|
| Total points and fees charged in connection with the loan (in USD) | NUMBER |
|
| Total of all itemized amounts that are designated borrower-paid at or before closing (in USD) | NUMBER |
|
| Amount of total loan costs in USD | NUMBER |
|
| Term of any prepayment penalty in months | NUMBER |
|
| If the contractual terms include a term that would cause the loan to be a negative amortization loan | VARCHAR |
|
| If the contractual terms include a balloon payment | VARCHAR |
|
| If the application is for a reverse mortgage | VARCHAR |
|
| If the application is for an open-end line of credit | VARCHAR |
|
| If the loan is a high-cost mortgage | VARCHAR |
|
| If the reported loan amount exceeds the GSE (government sponsored enterprise) conforming loan limit | VARCHAR |
|
| If the contractual terms allow for payments other than fully amortizing, negative amortizing, balloon, or interest only payments | VARCHAR |
|
| Number of individual dwelling units related to the property securing the loan | VARCHAR |
|
| Occupancy type for the home (principal residence, second residence, investment property) | VARCHAR |
|
| Construction method for the home (site-built, manufactured home) | VARCHAR |
|
| Applicants land property interest in the land on which a manufactured home is located | VARCHAR |
|
| If the application is secured by a manufactured home and land, or by a manufactured home and not land | VARCHAR |
|
| Percentage of multifamily affordable units as a fraction of total units | FLOAT |
|
| Age of the applicant | VARCHAR |
|
| Sex of the applicant | VARCHAR |
|
| Race of the applicant | VARCHAR |
|
| Ethnicity of the applicant | VARCHAR |
|
| If the applicant age is above 62 | BOOLEAN |
|
| Credit scoring model used to generate the score relied on in the credit decision (e.g., VantageScore 3.0, Experian Fair Isaac) | VARCHAR |
|
| Age of the co-applicant | VARCHAR |
|
| Sex of the co-applicant | VARCHAR |
|
| Race of the co-applicant | VARCHAR |
|
| Ethnicity of the co-applicant | VARCHAR |
|
| If the co-applicant age is above 62 | BOOLEAN |
|
| Credit scoring model used to generate the score relied on in the credit decision (e.g., VantageScore 3.0, Experian Fair Isaac) | VARCHAR |
|
| Median family income for the MSA (via FFIEC) | NUMBER |
|
| Percentage of tract median family income compared to MSA/MD median family income | FLOAT |
|
| Total population in the census tract | NUMBER |
|
| Count of family homes that are fewer than 5 families in the census tract | NUMBER |
|
| Count of homes, including individual condos, that are lived in by owner (owner occupied) in the census tract | NUMBER |
|
| Tract median age of homes in the census tract | NUMBER |
|
| Percentage of minority population to total population in the census tract | FLOAT |
|
| Whether the applicant or borrower submitted the application directly to the financial institution | VARCHAR |
|
| Automated underwriting system used by the financial institution to evaluate the application | VARCHAR |
|
| If the obligation arising from the application was initially payable to the financial institution | VARCHAR |
|
Last updated