AFFORDABLE_LENDING Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
FNMCommunityLendingProductType	FNMCommunityLendingProductEnum	VARCHAR(0)	YES	Specifies the type of the Fannie Mae community lending product that is associated with the loan.
FNMCommunityLendingProductTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to capture a description of the FNM Community Lending Product Type when Other is selected.
FNMCommunitySecondsIndicator	MISMOIndicator	BIT	NO	Indicates whether the loan is a Fannie Mae Community Seconds.
FNMNeighborsMortgageEligibilityIndicator	MISMOIndicator	BIT	NO	Indicates whether the loan is eligible to be a Fannie Mae Neighbors mortgage.
HUDIncomeLimitAdjustmentPercent	MISMOPercent	DECIMAL(0, 2)	NO	The percentage by which the HUD Median Income can be exceeded in certain high cost areas.
HUDLendingIncomeLimitAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total dollar amount for HUD based on the median income and adjustment factors.
HUDMedianIncomeAmount	MISMOAmount	DECIMAL(0, 2)	NO	The HUD estimated median family incomes to determine borrower eligibility for all applications related to affordable lending products.

AFFORDABLE_LENDING Keys

Key Name

Key Type

Keys

AFFORDABLE_LENDING 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

AFFORDABLE_LENDING Check Constraints

Check Constraint Name

CheckConstraint

AFFORDABLE_LENDING Bound Attachments

Name	Current Value

AFFORDABLE_LENDING User-Defined Mappings

Model

Name

Description

AFFORDABLE_LENDING Data Movement Rules

Name

Type

Rule Text/Value