| OFF_SITE_IMPROVEMENT |
| EntityType | Dependent |
| Logical Entity Name | OFF_SITE_IMPROVEMENT |
| Default Table Name | DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/SITE/OFF_SITE_IMPROVEMENTS/OFF_SITE_IMPROVEMENT |
| Definition | |
| Note |
| OFF_SITE_IMPROVEMENT Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| 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. |
| ConditionRatingType | ConditionRatingEnum | VARCHAR(0) | YES | A rating of the quality of the identified component. |
| OffSiteImprovementDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe in detail the off site improvement specified by the Off Site Improvement Type. |
| OffSiteImprovementOwnershipType | OffSiteImprovementOwnershipEnum | VARCHAR(0) | YES | Specifies the ownership or responsibility type of an off site improvement feature such as a public or private road |
| OffSiteImprovementsUtilityNotTypicalDescription | MISMOString | VARCHAR(0) | NO | Describes how the utilities for the off site improvements differ from what is typical for the market area. |
| OffSiteImprovementsUtilityTypicalIndicator | MISMOIndicator | BIT | NO | Indicates that the utilities for the off site improvements are typical for the market area. |
| OffSiteImprovementType | OffSiteImprovementEnum | VARCHAR(0) | YES | Used to specify a particular off site improvement feature of the property |
| OffSiteImprovementTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe the off site improvement if Other is selected as the Property Off Site Improvements Features Type. |
| OFF_SITE_IMPROVEMENT Keys |
| Key Name | Key Type | Keys |
| OFF_SITE_IMPROVEMENT Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| OFF_SITE_IMPROVEMENTS | Identifying | One To Zero or More | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| OFF_SITE_IMPROVEMENT Check Constraints |
| Check Constraint Name | CheckConstraint |
| OFF_SITE_IMPROVEMENT Bound Attachments |
| Name | Current Value |
| OFF_SITE_IMPROVEMENT User-Defined Mappings |
| Model | Name | Description |
| OFF_SITE_IMPROVEMENT Data Movement Rules |
| Name | Type | Rule Text/Value |