STRUCTURE_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
AccessoryUnitCount	MISMOCount	INTEGER	NO	A free-form text field used to describe the item of the structure being rated if Other is selected as the Structure Analysis Rating Item Type.
AdditionsDescription	MISMOString	VARCHAR(0)	NO	Describes the number of accessory units associated with the structure
AgeYearsCount	MISMOCount	INTEGER	NO	A free-form text field describing the additions made to the structure
AtticExistsIndicator	MISMOIndicator	BIT	NO	The chronological age measured in years. (i.e. the age of a structure)
BuildingCount	MISMOCount	INTEGER	NO	Indicates that the structure has an attic.
CharacteristicsAffectMarketabilityDescription	MISMOString	VARCHAR(0)	NO	The number of separate buildings that compose the structure. This is generally one, but may be multiple buildings for detached duplexes that comprise a 2-4 unit.
ElevatorCount	MISMOCount	INTEGER	NO	A free-form text field describing the characteristics that affect marketability
GrossBuildingAreaSquareFeetNumber	MISMONumeric	DECIMAL(0, 2)	NO	Number of elevators.
GrossLivingAreaSquareFeetDataSourceDescription	MISMOString	VARCHAR(0)	NO	The total area of the structure not limited to living areas
LivingUnitCount	MISMOCount	INTEGER	NO	A free-from text field describing where the value of Gross Living Area Square Feet Count came from.
RentControlDescription	MISMOString	VARCHAR(0)	NO	Number of separate living units (i.e. in a structure such as an apartment or duplex).
RentControlStatusType	RentControlStatusEnum	VARCHAR(0)	YES	Description of the existing or proposed rent controls for a property.
StoriesNumber	MISMONumeric	DECIMAL(0, 2)	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.
StructureConditionDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the general condition of the structure.
StructureConstructionStatusDescription	MISMOString	VARCHAR(0)	NO	A free-form field used to hold additional comments concerning the current status of the construction of the structure.
StructureNeverOccupiedIndicator	MISMOIndicator	BIT	NO	Indicates that the structure has never been occupied since it was completed.
StructureSingleFamilyResidenceIndicator	MISMOIndicator	BIT	NO	Indicates that the structure is a single-family residence.
StructureStateDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the existence or proposed construction of a structure.
StructureStateType	StructureStateEnum	VARCHAR(0)	YES	Indicates whether the construction of the structure is complete.

STRUCTURE_DETAIL Keys

Key Name

Key Type

Keys

STRUCTURE_DETAIL Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

STRUCTURE_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

STRUCTURE_DETAIL Bound Attachments

Name	Current Value

STRUCTURE_DETAIL User-Defined Mappings

Model

Name

Description

STRUCTURE_DETAIL Data Movement Rules

Name

Type

Rule Text/Value