COOLING_SYSTEM 
EntityType  Dependent 
Logical Entity Name  COOLING_SYSTEM 
Default Table Name  DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/IMPROVEMENT/SYSTEM/COOLING_SYSTEMS/COOLING_SYSTEM 
Definition   
Note 
 

COOLING_SYSTEM Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
AdequateIndicator  MISMOIndicator  BIT  NO  Indicates that this feature is adequate for normal needs.Indicates that this feature is adequate for normal needs. 
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. 
ComponentAdjustmentAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount (either positive or negative) adjustment being made for a specific component of the property. 
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.
 
CoolingSystemDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to describe in detail the cooling system identified by the cooling system type. 
CoolingSystemPrimaryIndicator  MISMOIndicator  BIT  NO  Indicates that the cooling system is the primary unit, not a secondary or additional system. 
CoolingSystemType  CoolingSystemEnum  VARCHAR(0)  YES  Specifies the type of cooling system.
 
CoolingSystemTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Cooling System 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. 

COOLING_SYSTEM Keys 
Key Name  Key Type  Keys 

COOLING_SYSTEM Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
COOLING_SYSTEMS  Identifying  One To Zero or More          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

COOLING_SYSTEM Check Constraints 
Check Constraint Name  CheckConstraint 

COOLING_SYSTEM Bound Attachments 
Name  Current Value 

COOLING_SYSTEM User-Defined Mappings 
Model  Name  Description 

COOLING_SYSTEM Data Movement Rules 
Name  Type  Rule Text/Value