| 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 |