HMDA_LOAN Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
HMDA_HOEPALoanStatusIndicator	MISMOIndicator	BIT	NO	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.
HMDAPreapprovalType	HMDAPreapprovalEnum	VARCHAR(0)	YES	Specifies if the loan meets the HMDA Preapproval reporting requirements as defined in paragraph (b)(1).
HMDAPurposeOfLoanType	HMDAPurposeOfLoanEnum	VARCHAR(0)	YES	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.
HMDARateSpreadPercent	MISMOPercent	DECIMAL(0, 2)	NO	The difference between the annual percentage rate (APR) and the average prime offer rate (APOR) as required for HMDA Reporting Requirements.

HMDA_LOAN Keys

Key Name

Key Type

Keys

HMDA_LOAN Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
LOAN	Identifying	One to Zero or One					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

HMDA_LOAN Check Constraints

Check Constraint Name

CheckConstraint

HMDA_LOAN Bound Attachments

Name	Current Value

HMDA_LOAN User-Defined Mappings

Model

Name

Description

HMDA_LOAN Data Movement Rules

Name

Type

Rule Text/Value