MARKET_TREND Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
MarketTrendsAdverseFinancingIndicator	MISMOIndicator	BIT	NO	Indicates that a trend toward adverse financing conditions is occurring.
MarketTrendsForeclosureActivityIndicator	MISMOIndicator	BIT	NO	Indicates whether the REO or foreclosure activity is significant.
MarketTrendsHistoricAnalysisCommentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe or analyze the historic trends and factors relevant to forecasting the sales price of a property.
MarketTrendsHistoricPricesType	MarketTrendsHistoricPricesEnum	VARCHAR(0)	YES	Specifies the historic trend of sales prices in a neighborhood (e.g. Increasing, Stable, or Decreasing).
MarketTrendsInterestRatesType	MarketTrendsInterestRatesEnum	VARCHAR(0)	YES	Specifies the mortgage interest rate trend (e.g. Decreasing, Stable, or Increasing).
MarketTrendsReconciliationCommentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe or analyze the anticipated trend of market conditions and prices during the marketing time of the prospective subject property.
MarketTrendsSalesActivityType	MarketTrendsSalesActivityEnum	VARCHAR(0)	YES	Specifies the sale activity trend of properties similar to the subject property (e.g. Decreasing, Stable, Increasing).

MARKET_TREND Keys

Key Name

Key Type

Keys

MARKET_TREND Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

MARKET_TREND Check Constraints

Check Constraint Name

CheckConstraint

MARKET_TREND Bound Attachments

Name	Current Value

MARKET_TREND User-Defined Mappings

Model

Name

Description

MARKET_TREND Data Movement Rules

Name

Type

Rule Text/Value