| BasementCeilingMaterialDescription |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementCeilingMaterialDescription |
| Logical Rolename | |
| ColumnName | BasementCeilingMaterialDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | Describes the materials used to finish the basement ceiling |
| Note |
| BasementCeilingMaterialDescription Logical Attribute Properties |
| Logical Attribute Name | BasementCeilingMaterialDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| BasementCeilingMaterialDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementCeilingMaterialDescription Bound Attachments |
| Name | Current Value |
| BasementCeilingMaterialDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementCeilingMaterialDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementCeilingMaterialDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementCeilingMaterialDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementCeilingMaterialDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementExitType |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementExitType |
| Logical Rolename | |
| ColumnName | BasementExitType |
| RoleName | |
| Domain | BasementExitEnum |
| Definition | Specifies the type of exit for a basement. |
| Note |
| BasementExitType Logical Attribute Properties |
| Logical Attribute Name | BasementExitType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| BasementExitType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementExitType Reference Value (Bound to Domain) |
| Name | ValidationRule37 |
| Description | |
| Type | By List |
| Value | Value Description |
| InteriorStairs | InteriorStairs |
| Walkout | Walkout |
| Walkup | Walkup |
| BasementExitType Bound Attachments |
| Name | Current Value |
| BasementExitType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementExitType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementExitType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementExitType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementExitType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishDescription |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementFinishDescription |
| Logical Rolename | |
| ColumnName | BasementFinishDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field describing the finish of the basement |
| Note |
| BasementFinishDescription Logical Attribute Properties |
| Logical Attribute Name | BasementFinishDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| BasementFinishDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementFinishDescription Bound Attachments |
| Name | Current Value |
| BasementFinishDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementFinishDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedIndicator |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementFinishedIndicator |
| Logical Rolename | |
| ColumnName | BasementFinishedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the basement is finished |
| Note |
| BasementFinishedIndicator Logical Attribute Properties |
| Logical Attribute Name | BasementFinishedIndicator |
| Datatype | BIT |
| Nullable | NO |
| BasementFinishedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementFinishedIndicator Bound Attachments |
| Name | Current Value |
| BasementFinishedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementFinishedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedPercent |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementFinishedPercent |
| Logical Rolename | |
| ColumnName | BasementFinishedPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage of the basement that is considered finished. |
| Note |
| BasementFinishedPercent Logical Attribute Properties |
| Logical Attribute Name | BasementFinishedPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BasementFinishedPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementFinishedPercent Bound Attachments |
| Name | Current Value |
| BasementFinishedPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementFinishedPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFinishedPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFirstFloorAreaPercent |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementFirstFloorAreaPercent |
| Logical Rolename | |
| ColumnName | BasementFirstFloorAreaPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Specifies the percent of the first floor which the basement overlaps. |
| Note |
| BasementFirstFloorAreaPercent Logical Attribute Properties |
| Logical Attribute Name | BasementFirstFloorAreaPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BasementFirstFloorAreaPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementFirstFloorAreaPercent Bound Attachments |
| Name | Current Value |
| BasementFirstFloorAreaPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementFirstFloorAreaPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFirstFloorAreaPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFirstFloorAreaPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFirstFloorAreaPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFloorMaterialDescription |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementFloorMaterialDescription |
| Logical Rolename | |
| ColumnName | BasementFloorMaterialDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | Describes the materials used to finish the basement floor |
| Note |
| BasementFloorMaterialDescription Logical Attribute Properties |
| Logical Attribute Name | BasementFloorMaterialDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| BasementFloorMaterialDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementFloorMaterialDescription Bound Attachments |
| Name | Current Value |
| BasementFloorMaterialDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementFloorMaterialDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFloorMaterialDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFloorMaterialDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementFloorMaterialDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementWallMaterialDescription |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | BasementWallMaterialDescription |
| Logical Rolename | |
| ColumnName | BasementWallMaterialDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | Describes the materials used to finish the basement walls. |
| Note |
| BasementWallMaterialDescription Logical Attribute Properties |
| Logical Attribute Name | BasementWallMaterialDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| BasementWallMaterialDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BasementWallMaterialDescription Bound Attachments |
| Name | Current Value |
| BasementWallMaterialDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BasementWallMaterialDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementWallMaterialDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementWallMaterialDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BasementWallMaterialDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ComponentAdjustmentAmount |
| Base Entity | BASEMENT_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 | BASEMENT_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 | BASEMENT_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 |
| QualityRatingDescription |
| Base Entity | BASEMENT_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 | BASEMENT_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 |
| SquareFeetNumber |
| Base Entity | BASEMENT_DETAIL |
| Attribute Name | SquareFeetNumber |
| Logical Rolename | |
| ColumnName | SquareFeetNumber |
| RoleName | |
| Domain | MISMONumeric |
| Definition | Identifies the total area measured in square feet. |
| Note |
| SquareFeetNumber Logical Attribute Properties |
| Logical Attribute Name | SquareFeetNumber |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| SquareFeetNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SquareFeetNumber Bound Attachments |
| Name | Current Value |
| SquareFeetNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SquareFeetNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SquareFeetNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SquareFeetNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SquareFeetNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |