COMPARABLE_ADJUSTMENT Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
ComparableAdjustmentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount of the adjustment applied to the price for the property feature identified by the Comparable Adjustment Type.
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
ComparableAdjustmentDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to further describe a property feature which is identified in the Comparable Adjustment Type.
ComparableAdjustmentType	ComparableAdjustmentEnum	VARCHAR(0)	YES	Specifies the type of price adjustment that is made when when comparing to sales and listings to value a property. Each type corresponds to a feature of the property. E.g. Condition, age, view, etc.
ComparableAdjustmentTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to capture additional information when other is selected for Comparable Price Adjustment Type.

COMPARABLE_ADJUSTMENT Keys

Key Name

Key Type

Keys

COMPARABLE_ADJUSTMENT Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
COMPARABLE_ADJUSTMENTS	Identifying	One To Zero or More					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

COMPARABLE_ADJUSTMENT Check Constraints

Check Constraint Name

CheckConstraint

COMPARABLE_ADJUSTMENT Bound Attachments

Name	Current Value

COMPARABLE_ADJUSTMENT User-Defined Mappings

Model

Name

Description

COMPARABLE_ADJUSTMENT Data Movement Rules

Name

Type

Rule Text/Value