HEATING_SYSTEM Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
ComponentAdjustmentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount (either positive or negative) adjustment being made for a specific component of the property.
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.
ComponentClassificationType	ComponentClassificationEnum	VARCHAR(0)	YES	Specifies whether the component is considered real or personal property.
ConditionRatingDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the condition rating of the identified component.
ConditionRatingType	ConditionRatingEnum	VARCHAR(0)	YES	A rating of the quality of the identified component.
HeatingFuelType	HeatingFuelEnum	VARCHAR(0)	YES	Indicates the type of fuel used by the heating system.
HeatingFuelTypeOtherDescription	MISMOString	VARCHAR(0)	NO	Free form description of fuel tuype if Type Other is selected.
HeatingSystemDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the heating system identified by the heating system type.
HeatingSystemPrimaryIndicator	MISMOIndicator	BIT	NO	Indicates that the heating system is the primary unit, not a secondary or additional system.
HeatingSystemType	HeatingSystemEnum	VARCHAR(0)	YES	Specifies the type of heating
HeatingSystemTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Heating Type.
QualityRatingDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the quality rating of the identified component.
QualityRatingType	QualityRatingEnum	VARCHAR(0)	YES	A rating of the quality of the identified component type.
SystemPermanentIndicator	MISMOIndicator	BIT	NO	When true indicates that the system specified is a permanent, attached system otherwise it is portable.

HEATING_SYSTEM Keys

Key Name

Key Type

Keys

HEATING_SYSTEM Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

HEATING_SYSTEM Check Constraints

Check Constraint Name

CheckConstraint

HEATING_SYSTEM Bound Attachments

Name	Current Value

HEATING_SYSTEM User-Defined Mappings

Model

Name

Description

HEATING_SYSTEM Data Movement Rules

Name

Type

Rule Text/Value