| HMDA_HOEPALoanStatusIndicator |
| Base Entity | HMDA_LOAN |
| Attribute Name | HMDA_HOEPALoanStatusIndicator |
| Logical Rolename | |
| ColumnName | HMDA_HOEPALoanStatusIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Flag used to indicate that loan is to be reported as a HOEPA (Home Ownership and Equity Protection Act of 1994) loan for HMDA reporting. |
| Note |
| HMDA_HOEPALoanStatusIndicator Logical Attribute Properties |
| Logical Attribute Name | HMDA_HOEPALoanStatusIndicator |
| Datatype | BIT |
| Nullable | NO |
| HMDA_HOEPALoanStatusIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HMDA_HOEPALoanStatusIndicator Bound Attachments |
| Name | Current Value |
| HMDA_HOEPALoanStatusIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HMDA_HOEPALoanStatusIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDA_HOEPALoanStatusIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDA_HOEPALoanStatusIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDA_HOEPALoanStatusIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPreapprovalType |
| Base Entity | HMDA_LOAN |
| Attribute Name | HMDAPreapprovalType |
| Logical Rolename | |
| ColumnName | HMDAPreapprovalType |
| RoleName | |
| Domain | HMDAPreapprovalEnum |
| Definition | Specifies if the loan meets the HMDA Preapproval reporting requirements as defined in paragraph (b)(1). |
| Note |
| HMDAPreapprovalType Logical Attribute Properties |
| Logical Attribute Name | HMDAPreapprovalType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| HMDAPreapprovalType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HMDAPreapprovalType Reference Value (Bound to Domain) |
| Name | ValidationRule197 |
| Description | |
| Type | By List |
| Value | Value Description |
| NotApplicable | NotApplicable |
| PreapprovalWasNotRequested | PreapprovalWasNotRequested |
| PreapprovalWasRequested | PreapprovalWasRequested |
| HMDAPreapprovalType Bound Attachments |
| Name | Current Value |
| HMDAPreapprovalType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HMDAPreapprovalType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPreapprovalType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPreapprovalType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPreapprovalType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPurposeOfLoanType |
| Base Entity | HMDA_LOAN |
| Attribute Name | HMDAPurposeOfLoanType |
| Logical Rolename | |
| ColumnName | HMDAPurposeOfLoanType |
| RoleName | |
| Domain | HMDAPurposeOfLoanEnum |
| Definition | Specifies the HMDA Purpose of Loan as defined in Regulation C. The definitions of a home improvement loan and a refinancing were substantially revised in the final rules adopted in 2002. |
| Note |
| HMDAPurposeOfLoanType Logical Attribute Properties |
| Logical Attribute Name | HMDAPurposeOfLoanType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| HMDAPurposeOfLoanType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HMDAPurposeOfLoanType Reference Value (Bound to Domain) |
| Name | ValidationRule198 |
| Description | |
| Type | By List |
| Value | Value Description |
| HomeImprovement | HomeImprovement |
| HomePurchase | HomePurchase |
| Refinancing | Refinancing |
| HMDAPurposeOfLoanType Bound Attachments |
| Name | Current Value |
| HMDAPurposeOfLoanType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HMDAPurposeOfLoanType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPurposeOfLoanType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPurposeOfLoanType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDAPurposeOfLoanType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDARateSpreadPercent |
| Base Entity | HMDA_LOAN |
| Attribute Name | HMDARateSpreadPercent |
| Logical Rolename | |
| ColumnName | HMDARateSpreadPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The difference between the annual percentage rate (APR) and the average prime offer rate (APOR) as required for HMDA Reporting Requirements. |
| Note |
| HMDARateSpreadPercent Logical Attribute Properties |
| Logical Attribute Name | HMDARateSpreadPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| HMDARateSpreadPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HMDARateSpreadPercent Bound Attachments |
| Name | Current Value |
| HMDARateSpreadPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HMDARateSpreadPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDARateSpreadPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDARateSpreadPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HMDARateSpreadPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |