COMPARISON_TO_NEIGHBORHOOD Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
LivingUnitCount	MISMOCount	INTEGER	NO	Number of separate living units (i.e. in a structure such as an apartment or duplex).
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.
RentControlDescription	MISMOString	VARCHAR(0)	NO	Description of the existing or proposed rent controls for a property.
RentControlStatusType	RentControlStatusEnum	VARCHAR(0)	YES	Specifies the existence or likelihood of rent controls such as controls on businesses and apartment complexes.
StoriesCount	MISMOCount	INTEGER	NO	Specifies the number of habitable levels above grade in a structure such as in a 2 story house, a cape cod with 1.5 stories or a 2 story condominium unit in a multi-level building.
StructureFeatureType	StructureFeatureEnum	VARCHAR(0)	YES	Specifies an aspect of the structure that is typical to its neighborhood.
StructureFeatureTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe a structure feature if Other is selected as the Structure Feature Type.
StructureTypicalToNeighborhoodAtypicalDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing how the structure differs from the typical neighborhood structure
StructureTypicalToNeighborhoodExistsIndicator	MISMOIndicator	BIT	NO	Indicates that the aspect specified by Structure Typical To Neighborhood is present in the structure
TypicalApartmentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the typical comparable buildings in the property neighborhood.
TypicalApartmentEstimatedVacancyPercent	MISMOPercent	DECIMAL(0, 2)	NO	The estimated vacancy percentage for a typical two-to-four family building the property neighborhood.
TypicalApartmentRentHighPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The high end of the range of typical market rents in the neighborhood.
TypicalApartmentRentLowPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The low end of the range of typical market rents in the neighborhood.
TypicalApartmentRentTrendType	TypicalApartmentRentTrendEnum	VARCHAR(0)	YES	Specifies the current trend in rent prices for the typical apartment in the neighborhood.
TypicalApartmentVacancyTrendType	TypicalApartmentVacancyTrendEnum	VARCHAR(0)	YES	Specifies the current trend in vacancy rates for the typical apartment in the neighborhood.

COMPARISON_TO_NEIGHBORHOOD Keys

Key Name

Key Type

Keys

COMPARISON_TO_NEIGHBORHOOD Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

COMPARISON_TO_NEIGHBORHOOD Check Constraints

Check Constraint Name

CheckConstraint

COMPARISON_TO_NEIGHBORHOOD Bound Attachments

Name	Current Value

COMPARISON_TO_NEIGHBORHOOD User-Defined Mappings

Model

Name

Description

COMPARISON_TO_NEIGHBORHOOD Data Movement Rules

Name

Type

Rule Text/Value