| ComponentAdjustmentAmount |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | ComponentAdjustmentAmount |
| Logical Rolename | |
| ColumnName | ComponentAdjustmentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount (either positive or negative) adjustment being made for a specific component of the property. |
| Note |
| ComponentAdjustmentAmount Logical Attribute Properties |
| Logical Attribute Name | ComponentAdjustmentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| ComponentAdjustmentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ComponentAdjustmentAmount Bound Attachments |
| Name | Current Value |
| ComponentAdjustmentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ComponentAdjustmentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ComponentAdjustmentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ComponentAdjustmentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ComponentAdjustmentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | ConditionRatingDescription |
| Logical Rolename | |
| ColumnName | ConditionRatingDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to describe in detail the condition rating of the identified component. |
| Note |
| ConditionRatingDescription Logical Attribute Properties |
| Logical Attribute Name | ConditionRatingDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ConditionRatingDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConditionRatingDescription Bound Attachments |
| Name | Current Value |
| ConditionRatingDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConditionRatingDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingType |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | ConditionRatingType |
| Logical Rolename | |
| ColumnName | ConditionRatingType |
| RoleName | |
| Domain | ConditionRatingEnum |
| Definition | A rating of the quality of the identified component. |
| Note |
| ConditionRatingType Logical Attribute Properties |
| Logical Attribute Name | ConditionRatingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ConditionRatingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConditionRatingType Reference Value (Bound to Domain) |
| Name | ValidationRule63 |
| Description | |
| Type | By List |
| Value | Value Description |
| Average | Average |
| Excellent | Excellent |
| Fair | Fair |
| Good | Good |
| Poor | Poor |
| ConditionRatingType Bound Attachments |
| Name | Current Value |
| ConditionRatingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConditionRatingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConditionRatingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationConditionDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationConditionDescription |
| Logical Rolename | |
| ColumnName | FoundationConditionDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field describing the condition of the foundation in general |
| Note |
| FoundationConditionDescription Logical Attribute Properties |
| Logical Attribute Name | FoundationConditionDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FoundationConditionDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationConditionDescription Bound Attachments |
| Name | Current Value |
| FoundationConditionDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationConditionDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationConditionDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationConditionDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationConditionDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesType |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationDeficienciesType |
| Logical Rolename | |
| ColumnName | FoundationDeficienciesType |
| RoleName | |
| Domain | FoundationDeficienciesEnum |
| Definition | Indicates a type of condition of the foundation which is described by Foundation Condition Comment. |
| Note |
| FoundationDeficienciesType Logical Attribute Properties |
| Logical Attribute Name | FoundationDeficienciesType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FoundationDeficienciesType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationDeficienciesType Reference Value (Bound to Domain) |
| Name | ValidationRule179 |
| Description | |
| Type | By List |
| Value | Value Description |
| Dampness | Dampness |
| Infestation | Infestation |
| Other | Other |
| Settlement | Settlement |
| FoundationDeficienciesType Bound Attachments |
| Name | Current Value |
| FoundationDeficienciesType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationDeficienciesType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesTypeOtherDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationDeficienciesTypeOtherDescription |
| Logical Rolename | |
| ColumnName | FoundationDeficienciesTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe the foundation condition if Other is selected as the Foundation Condition Type. |
| Note |
| FoundationDeficienciesTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | FoundationDeficienciesTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FoundationDeficienciesTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationDeficienciesTypeOtherDescription Bound Attachments |
| Name | Current Value |
| FoundationDeficienciesTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationDeficienciesTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDeficienciesTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationDescription |
| Logical Rolename | |
| ColumnName | FoundationDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to describe in detail the foundation as identified by the Foundation Type. |
| Note |
| FoundationDescription Logical Attribute Properties |
| Logical Attribute Name | FoundationDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FoundationDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationDescription Bound Attachments |
| Name | Current Value |
| FoundationDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationExistsIndicator |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationExistsIndicator |
| Logical Rolename | |
| ColumnName | FoundationExistsIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that there is a foundation |
| Note |
| FoundationExistsIndicator Logical Attribute Properties |
| Logical Attribute Name | FoundationExistsIndicator |
| Datatype | BIT |
| Nullable | NO |
| FoundationExistsIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationExistsIndicator Bound Attachments |
| Name | Current Value |
| FoundationExistsIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationExistsIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationExistsIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationExistsIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationExistsIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialType |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationMaterialType |
| Logical Rolename | |
| ColumnName | FoundationMaterialType |
| RoleName | |
| Domain | FoundationMaterialEnum |
| Definition | Specifies the type of material used in the foundation |
| Note |
| FoundationMaterialType Logical Attribute Properties |
| Logical Attribute Name | FoundationMaterialType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FoundationMaterialType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationMaterialType Reference Value (Bound to Domain) |
| Name | ValidationRule182 |
| Description | |
| Type | By List |
| Value | Value Description |
| BlockAndPier | BlockAndPier |
| ConcreteRunners | ConcreteRunners |
| Other | Other |
| PouredConcrete | PouredConcrete |
| FoundationMaterialType Bound Attachments |
| Name | Current Value |
| FoundationMaterialType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationMaterialType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialTypeOtherDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationMaterialTypeOtherDescription |
| Logical Rolename | |
| ColumnName | FoundationMaterialTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Foundation Material Type. |
| Note |
| FoundationMaterialTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | FoundationMaterialTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FoundationMaterialTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationMaterialTypeOtherDescription Bound Attachments |
| Name | Current Value |
| FoundationMaterialTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationMaterialTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationMaterialTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationType |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationType |
| Logical Rolename | |
| ColumnName | FoundationType |
| RoleName | |
| Domain | FoundationEnum |
| Definition | Describes the construction style of the foundation of the structure. |
| Note |
| FoundationType Logical Attribute Properties |
| Logical Attribute Name | FoundationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FoundationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationType Reference Value (Bound to Domain) |
| Name | ValidationRule180 |
| Description | |
| Type | By List |
| Value | Value Description |
| Basement | Basement |
| Crawlspace | Crawlspace |
| Other | Other |
| PartialBasement | PartialBasement |
| Slab | Slab |
| FoundationType Bound Attachments |
| Name | Current Value |
| FoundationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationTypeOtherDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | FoundationTypeOtherDescription |
| Logical Rolename | |
| ColumnName | FoundationTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe the foundation type if Other is selected as the Foundation Type. |
| Note |
| FoundationTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | FoundationTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FoundationTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FoundationTypeOtherDescription Bound Attachments |
| Name | Current Value |
| FoundationTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FoundationTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FoundationTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaterialDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | MaterialDescription |
| Logical Rolename | |
| ColumnName | MaterialDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to describe in detail the material used in the identified component. |
| Note |
| MaterialDescription Logical Attribute Properties |
| Logical Attribute Name | MaterialDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| MaterialDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MaterialDescription Bound Attachments |
| Name | Current Value |
| MaterialDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MaterialDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaterialDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaterialDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MaterialDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingDescription |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | QualityRatingDescription |
| Logical Rolename | |
| ColumnName | QualityRatingDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to describe in detail the quality rating of the identified component. |
| Note |
| QualityRatingDescription Logical Attribute Properties |
| Logical Attribute Name | QualityRatingDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| QualityRatingDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| QualityRatingDescription Bound Attachments |
| Name | Current Value |
| QualityRatingDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| QualityRatingDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingType |
| Base Entity | FOUNDATION_DETAIL |
| Attribute Name | QualityRatingType |
| Logical Rolename | |
| ColumnName | QualityRatingType |
| RoleName | |
| Domain | QualityRatingEnum |
| Definition | A rating of the quality of the identified component type. |
| Note |
| QualityRatingType Logical Attribute Properties |
| Logical Attribute Name | QualityRatingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| QualityRatingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| QualityRatingType Reference Value (Bound to Domain) |
| Name | ValidationRule63 |
| Description | |
| Type | By List |
| Value | Value Description |
| Average | Average |
| Excellent | Excellent |
| Fair | Fair |
| Good | Good |
| Poor | Poor |
| QualityRatingType Bound Attachments |
| Name | Current Value |
| QualityRatingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| QualityRatingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QualityRatingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |