ASSET_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
AssetAccountIdentifier	MISMOIdentifier	VARCHAR(0)	NO	A unique identifier of the borrowers asset. Collected on the URLA in Section VI (Assets).
AssetAccountInNameOfDescription	MISMOString	VARCHAR(0)	NO	The name of the persons or entity(ies) in whose name the account is held.
AssetAccountType	AssetAccountEnum	VARCHAR(0)	YES	Specifies the type of account in which the assets are held. Usually used when pledging assets as collateral.
AssetAccountTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Asset Account Type.
AssetCashOrMarketValueAmount	MISMOAmount	DECIMAL(0, 2)	NO	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 neit
AssetDescription	MISMOString	VARCHAR(0)	NO	A text description that further defines the Asset. This could be used to describe the shares associated with the stocks, bonds or mutual funds, retirement funds or business owned that the borrower has disclosed (named) as an asset.
AssetLiquidityIndicator	MISMOIndicator	BIT	NO	When true, indicates that the asset is classified as liquid. When false, indicates that the asset is classified as non liquid.
AssetType	AssetEnum	VARCHAR(0)	YES	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
AssetTypeOtherDescription	MISMOString	VARCHAR(0)	NO	AssetTypeOtherDescription
AutomobileMakeDescription	MISMOString	VARCHAR(0)	NO	AutomobileMakeDescription
AutomobileModelYear	MISMOYear	DATE	NO	AutomobileModelYear
LifeInsuranceFaceValueAmount	MISMOAmount	DECIMAL(0, 2)	NO	LifeInsuranceFaceValueAmount
StockBondMutualFundShareCount	MISMOCount	INTEGER	NO	StockBondMutualFundShareCount
VerifiedIndicator	MISMOIndicator	BIT	NO	VerifiedIndicator

ASSET_DETAIL Keys

Key Name

Key Type

Keys

ASSET_DETAIL Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

ASSET_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

ASSET_DETAIL Bound Attachments

Name	Current Value

ASSET_DETAIL User-Defined Mappings

Model

Name

Description

ASSET_DETAIL Data Movement Rules

Name

Type

Rule Text/Value