EXTERIOR_FEATURE |
EntityType | Dependent |
Logical Entity Name | EXTERIOR_FEATURE |
Default Table Name | DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/IMPROVEMENT/STRUCTURE/EXTERIOR_FEATURES/EXTERIOR_FEATURE |
Definition | |
Note |
EXTERIOR_FEATURE 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. |
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. |
ExteriorFeatureDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe the exterior feature. |
ExteriorFeatureType | ExteriorFeatureEnum | VARCHAR(0) | YES | Specifies one exterior feature of the property. |
ExteriorFeatureTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to specify the exterior feature if Other is selected as the Exterior Feature Type. |
MaterialDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to describe in detail the material used in the identified component. |
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. |
EXTERIOR_FEATURE Keys |
Key Name | Key Type | Keys |
EXTERIOR_FEATURE Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
EXTERIOR_FEATURES | Identifying | One To Zero or More | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
EXTERIOR_FEATURE Check Constraints |
Check Constraint Name | CheckConstraint |
EXTERIOR_FEATURE Bound Attachments |
Name | Current Value |
EXTERIOR_FEATURE User-Defined Mappings |
Model | Name | Description |
EXTERIOR_FEATURE Data Movement Rules |
Name | Type | Rule Text/Value |