AccessoryUnitCount 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  AccessoryUnitCount 
Logical Rolename   
ColumnName  AccessoryUnitCount 
RoleName   
Domain  MISMOCount 
Definition  A free-form text field used to describe the item of the structure being rated if Other is selected as the Structure Analysis Rating Item Type. 
Note 
 

AccessoryUnitCount Logical Attribute Properties 
Logical Attribute Name  AccessoryUnitCount 
Datatype  INTEGER 
Nullable  NO 

AccessoryUnitCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AccessoryUnitCount Bound Attachments 
Name  Current Value 

AccessoryUnitCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AccessoryUnitCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AccessoryUnitCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AccessoryUnitCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AccessoryUnitCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AdditionsDescription 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  AdditionsDescription 
Logical Rolename   
ColumnName  AdditionsDescription 
RoleName   
Domain  MISMOString 
Definition  Describes the number of accessory units associated with the structure 
Note 
 

AdditionsDescription Logical Attribute Properties 
Logical Attribute Name  AdditionsDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

AdditionsDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AdditionsDescription Bound Attachments 
Name  Current Value 

AdditionsDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AdditionsDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AdditionsDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AdditionsDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AdditionsDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AgeYearsCount 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  AgeYearsCount 
Logical Rolename   
ColumnName  AgeYearsCount 
RoleName   
Domain  MISMOCount 
Definition  A free-form text field describing the additions made to the structure 
Note 
 

AgeYearsCount Logical Attribute Properties 
Logical Attribute Name  AgeYearsCount 
Datatype  INTEGER 
Nullable  NO 

AgeYearsCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AgeYearsCount Bound Attachments 
Name  Current Value 

AgeYearsCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AgeYearsCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AgeYearsCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AgeYearsCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AgeYearsCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AtticExistsIndicator 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  AtticExistsIndicator 
Logical Rolename   
ColumnName  AtticExistsIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  The chronological age measured in years. (i.e. the age of a structure) 
Note 
 

AtticExistsIndicator Logical Attribute Properties 
Logical Attribute Name  AtticExistsIndicator 
Datatype  BIT 
Nullable  NO 

AtticExistsIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AtticExistsIndicator Bound Attachments 
Name  Current Value 

AtticExistsIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AtticExistsIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AtticExistsIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AtticExistsIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AtticExistsIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BuildingCount 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  BuildingCount 
Logical Rolename   
ColumnName  BuildingCount 
RoleName   
Domain  MISMOCount 
Definition  Indicates that the structure has an attic. 
Note 
 

BuildingCount Logical Attribute Properties 
Logical Attribute Name  BuildingCount 
Datatype  INTEGER 
Nullable  NO 

BuildingCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BuildingCount Bound Attachments 
Name  Current Value 

BuildingCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BuildingCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BuildingCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BuildingCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BuildingCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CharacteristicsAffectMarketabilityDescription 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  CharacteristicsAffectMarketabilityDescription 
Logical Rolename   
ColumnName  CharacteristicsAffectMarketabilityDescription 
RoleName   
Domain  MISMOString 
Definition  The number of separate buildings that compose the structure. This is generally one, but may be multiple buildings for detached duplexes that comprise a 2-4 unit. 
Note 
 

CharacteristicsAffectMarketabilityDescription Logical Attribute Properties 
Logical Attribute Name  CharacteristicsAffectMarketabilityDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

CharacteristicsAffectMarketabilityDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CharacteristicsAffectMarketabilityDescription Bound Attachments 
Name  Current Value 

CharacteristicsAffectMarketabilityDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CharacteristicsAffectMarketabilityDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CharacteristicsAffectMarketabilityDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CharacteristicsAffectMarketabilityDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CharacteristicsAffectMarketabilityDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ElevatorCount 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  ElevatorCount 
Logical Rolename   
ColumnName  ElevatorCount 
RoleName   
Domain  MISMOCount 
Definition  A free-form text field describing the characteristics that affect marketability 
Note 
 

ElevatorCount Logical Attribute Properties 
Logical Attribute Name  ElevatorCount 
Datatype  INTEGER 
Nullable  NO 

ElevatorCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ElevatorCount Bound Attachments 
Name  Current Value 

ElevatorCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ElevatorCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ElevatorCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ElevatorCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ElevatorCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


GrossBuildingAreaSquareFeetNumber 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  GrossBuildingAreaSquareFeetNumber 
Logical Rolename   
ColumnName  GrossBuildingAreaSquareFeetNumber 
RoleName   
Domain  MISMONumeric 
Definition  Number of elevators. 
Note 
 

GrossBuildingAreaSquareFeetNumber Logical Attribute Properties 
Logical Attribute Name  GrossBuildingAreaSquareFeetNumber 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

GrossBuildingAreaSquareFeetNumber Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

GrossBuildingAreaSquareFeetNumber Bound Attachments 
Name  Current Value 

GrossBuildingAreaSquareFeetNumber User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

GrossBuildingAreaSquareFeetNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

GrossBuildingAreaSquareFeetNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

GrossBuildingAreaSquareFeetNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

GrossBuildingAreaSquareFeetNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


GrossLivingAreaSquareFeetDataSourceDescription 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  GrossLivingAreaSquareFeetDataSourceDescription 
Logical Rolename   
ColumnName  GrossLivingAreaSquareFeetDataSourceDescription 
RoleName   
Domain  MISMOString 
Definition  The total area of the structure not limited to living areas 
Note 
 

GrossLivingAreaSquareFeetDataSourceDescription Logical Attribute Properties 
Logical Attribute Name  GrossLivingAreaSquareFeetDataSourceDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

GrossLivingAreaSquareFeetDataSourceDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

GrossLivingAreaSquareFeetDataSourceDescription Bound Attachments 
Name  Current Value 

GrossLivingAreaSquareFeetDataSourceDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

GrossLivingAreaSquareFeetDataSourceDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

GrossLivingAreaSquareFeetDataSourceDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

GrossLivingAreaSquareFeetDataSourceDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

GrossLivingAreaSquareFeetDataSourceDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LivingUnitCount 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  LivingUnitCount 
Logical Rolename   
ColumnName  LivingUnitCount 
RoleName   
Domain  MISMOCount 
Definition  A free-from text field describing where the value of Gross Living Area Square Feet Count came from. 
Note 
 

LivingUnitCount Logical Attribute Properties 
Logical Attribute Name  LivingUnitCount 
Datatype  INTEGER 
Nullable  NO 

LivingUnitCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LivingUnitCount Bound Attachments 
Name  Current Value 

LivingUnitCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LivingUnitCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LivingUnitCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LivingUnitCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LivingUnitCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RentControlDescription 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  RentControlDescription 
Logical Rolename   
ColumnName  RentControlDescription 
RoleName   
Domain  MISMOString 
Definition  Number of separate living units (i.e. in a structure such as an apartment or duplex). 
Note 
 

RentControlDescription Logical Attribute Properties 
Logical Attribute Name  RentControlDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

RentControlDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RentControlDescription Bound Attachments 
Name  Current Value 

RentControlDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RentControlDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RentControlDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RentControlDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RentControlDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RentControlStatusType 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  RentControlStatusType 
Logical Rolename   
ColumnName  RentControlStatusType 
RoleName   
Domain  RentControlStatusEnum 
Definition  Description of the existing or proposed rent controls for a property. 
Note 
 

RentControlStatusType Logical Attribute Properties 
Logical Attribute Name  RentControlStatusType 
Datatype  VARCHAR(0) 
Nullable  YES 

RentControlStatusType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RentControlStatusType Reference Value (Bound to Domain) 
Name  ValidationRule431 
Description   
Type  By List 
Value  Value Description 
Likely  Rent Control is likely in the future. 
No  No 
Yes  Yes 

RentControlStatusType Bound Attachments 
Name  Current Value 

RentControlStatusType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RentControlStatusType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RentControlStatusType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RentControlStatusType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RentControlStatusType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StoriesNumber 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  StoriesNumber 
Logical Rolename   
ColumnName  StoriesNumber 
RoleName   
Domain  MISMONumeric 
Definition  Specifies the number of habitable levels above grade in a structure such as in a 2 story house, a cape cod with 1.5 stories or a 2 story condominium unit in a multi-level building. 
Note 
 

StoriesNumber Logical Attribute Properties 
Logical Attribute Name  StoriesNumber 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

StoriesNumber Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StoriesNumber Bound Attachments 
Name  Current Value 

StoriesNumber User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StoriesNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StoriesNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StoriesNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StoriesNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StructureConditionDescription 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  StructureConditionDescription 
Logical Rolename   
ColumnName  StructureConditionDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to describe the general condition of the structure. 
Note 
 

StructureConditionDescription Logical Attribute Properties 
Logical Attribute Name  StructureConditionDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

StructureConditionDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StructureConditionDescription Bound Attachments 
Name  Current Value 

StructureConditionDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StructureConditionDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureConditionDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureConditionDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StructureConditionDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StructureConstructionStatusDescription 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  StructureConstructionStatusDescription 
Logical Rolename   
ColumnName  StructureConstructionStatusDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form field used to hold additional comments concerning the current status of the construction of the structure. 
Note 
 

StructureConstructionStatusDescription Logical Attribute Properties 
Logical Attribute Name  StructureConstructionStatusDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

StructureConstructionStatusDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StructureConstructionStatusDescription Bound Attachments 
Name  Current Value 

StructureConstructionStatusDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StructureConstructionStatusDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureConstructionStatusDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureConstructionStatusDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StructureConstructionStatusDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StructureNeverOccupiedIndicator 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  StructureNeverOccupiedIndicator 
Logical Rolename   
ColumnName  StructureNeverOccupiedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the structure has never been occupied since it was completed. 
Note 
 

StructureNeverOccupiedIndicator Logical Attribute Properties 
Logical Attribute Name  StructureNeverOccupiedIndicator 
Datatype  BIT 
Nullable  NO 

StructureNeverOccupiedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StructureNeverOccupiedIndicator Bound Attachments 
Name  Current Value 

StructureNeverOccupiedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StructureNeverOccupiedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureNeverOccupiedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureNeverOccupiedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StructureNeverOccupiedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StructureSingleFamilyResidenceIndicator 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  StructureSingleFamilyResidenceIndicator 
Logical Rolename   
ColumnName  StructureSingleFamilyResidenceIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the structure is a single-family residence. 
Note 
 

StructureSingleFamilyResidenceIndicator Logical Attribute Properties 
Logical Attribute Name  StructureSingleFamilyResidenceIndicator 
Datatype  BIT 
Nullable  NO 

StructureSingleFamilyResidenceIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StructureSingleFamilyResidenceIndicator Bound Attachments 
Name  Current Value 

StructureSingleFamilyResidenceIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StructureSingleFamilyResidenceIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureSingleFamilyResidenceIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureSingleFamilyResidenceIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StructureSingleFamilyResidenceIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StructureStateDescription 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  StructureStateDescription 
Logical Rolename   
ColumnName  StructureStateDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to describe the existence or proposed construction of a structure. 
Note 
 

StructureStateDescription Logical Attribute Properties 
Logical Attribute Name  StructureStateDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

StructureStateDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StructureStateDescription Bound Attachments 
Name  Current Value 

StructureStateDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StructureStateDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureStateDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureStateDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StructureStateDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StructureStateType 
Base Entity  STRUCTURE_DETAIL 
Attribute Name  StructureStateType 
Logical Rolename   
ColumnName  StructureStateType 
RoleName   
Domain  StructureStateEnum 
Definition  Indicates whether the construction of the structure is complete.  
Note 
 

StructureStateType Logical Attribute Properties 
Logical Attribute Name  StructureStateType 
Datatype  VARCHAR(0) 
Nullable  YES 

StructureStateType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StructureStateType Reference Value (Bound to Domain) 
Name  ValidationRule463 
Description   
Type  By List 
Value  Value Description 
Complete  Complete 
Incomplete  Incomplete 
NotStarted  NotStarted 

StructureStateType Bound Attachments 
Name  Current Value 

StructureStateType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StructureStateType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureStateType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructureStateType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StructureStateType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description