RESEARCH Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
ComparableDataSourceDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the source of information for the comparable property.
ComparableHasPriorSalesIndicator	MISMOIndicator	BIT	NO	Indicates whether the comparable property has prior sales history.
ComparableListingsPriceRangeHighAmount	MISMOAmount	DECIMAL(0, 2)	NO	Specifies the high listing value in the range of values within the group of comparable listing properties researched.
ComparableListingsPriceRangeLowAmount	MISMOAmount	DECIMAL(0, 2)	NO	Specifies the low listing value in the range of values within the group of comparable listing properties researched.
ComparableListingsResearchedCount	MISMOCount	INTEGER	NO	Specifies the total number of comparable property listings researched.
ComparableSalesPriceRangeHighAmount	MISMOAmount	DECIMAL(0, 2)	NO	Specifies the high sale value in the range of values within the group of comparable sales researched.
ComparableSalesPriceRangeLowAmount	MISMOAmount	DECIMAL(0, 2)	NO	Specifies the low sale value in the range of values within the group of comparable sales researched.
ComparableSalesResearchedCount	MISMOCount	INTEGER	NO	Specifies the total number of comparable property sales researched.
SalesHistoryNotResearchedCommentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe or comment on why the sales or transfer history research of the subject property and comparable sales was not performed.
SalesHistoryResearchedIndicator	MISMOIndicator	BIT	NO	Indicates that the sales or transfer history research of the subject property and comparable sales was performed.
SubjectHasPriorSalesIndicator	MISMOIndicator	BIT	NO	Indicates whether the subject property has prior sales history.

RESEARCH Keys

Key Name

Key Type

Keys

RESEARCH Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

RESEARCH Check Constraints

Check Constraint Name

CheckConstraint

RESEARCH Bound Attachments

Name	Current Value

RESEARCH User-Defined Mappings

Model

Name

Description

RESEARCH Data Movement Rules

Name

Type

Rule Text/Value