| FOUNDATION_DETAIL |
| EntityType | Dependent |
| Logical Entity Name | FOUNDATION_DETAIL |
| Default Table Name | DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/IMPROVEMENT/STRUCTURE/FOUNDATIONS/FOUNDATION/FOUNDATION_DETAIL |
| Definition | |
| Note |
| FOUNDATION_DETAIL 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. |
| 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. |
| FoundationConditionDescription | MISMOString | VARCHAR(0) | NO | A free-form text field describing the condition of the foundation in general |
| FoundationDeficienciesType | FoundationDeficienciesEnum | VARCHAR(0) | YES | Indicates a type of condition of the foundation which is described by Foundation Condition Comment. |
| FoundationDeficienciesTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe the foundation condition if Other is selected as the Foundation Condition Type. |
| FoundationDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to describe in detail the foundation as identified by the Foundation Type. |
| FoundationExistsIndicator | MISMOIndicator | BIT | NO | Indicates that there is a foundation |
| FoundationMaterialType | FoundationMaterialEnum | VARCHAR(0) | YES | Specifies the type of material used in the foundation |
| FoundationMaterialTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to collect additional information when Other is selected for Foundation Material Type. |
| FoundationType | FoundationEnum | VARCHAR(0) | YES | Describes the construction style of the foundation of the structure. |
| FoundationTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe the foundation type if Other is selected as the Foundation 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. |
| FOUNDATION_DETAIL Keys |
| Key Name | Key Type | Keys |
| FOUNDATION_DETAIL Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| FOUNDATION | Identifying | One to Zero or One | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FOUNDATION_DETAIL Check Constraints |
| Check Constraint Name | CheckConstraint |
| FOUNDATION_DETAIL Bound Attachments |
| Name | Current Value |
| FOUNDATION_DETAIL User-Defined Mappings |
| Model | Name | Description |
| FOUNDATION_DETAIL Data Movement Rules |
| Name | Type | Rule Text/Value |