AmenityCount 
Base Entity  AMENITY 
Attribute Name  AmenityCount 
Logical Rolename   
ColumnName  AmenityCount 
RoleName   
Domain  MISMOCount 
Definition  The number of the amenities specified by Amenity Type that are present in the property. For example two fireplaces. 
Note 
 

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

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

AmenityCount Bound Attachments 
Name  Current Value 

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

AmenityCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SequenceNumber 
Base Entity  AMENITY 
Attribute Name  SequenceNumber 
Logical Rolename   
ColumnName  SequenceNumber 
RoleName   
Domain  XSD:Integer 
Definition  An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. 
Note 
 

SequenceNumber Logical Attribute Properties 
Logical Attribute Name  SequenceNumber 
Datatype  INTEGER 
Nullable  YES 

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

SequenceNumber Bound Attachments 
Name  Current Value 

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

SequenceNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AmenityDescription 
Base Entity  AMENITY 
Attribute Name  AmenityDescription 
Logical Rolename   
ColumnName  AmenityDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to describe, in detail, the amenity specified by Amenity Type. 
Note 
 

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

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

AmenityDescription Bound Attachments 
Name  Current Value 

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

AmenityDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AmenityType 
Base Entity  AMENITY 
Attribute Name  AmenityType 
Logical Rolename   
ColumnName  AmenityType 
RoleName   
Domain  AmenityEnum 
Definition  Specifies a particular amenity found in the structure or in the subject property which is further described by Amenity Description.  
Note 
 

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

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

AmenityType Reference Value (Bound to Domain) 
Name  ValidationRule14 
Description   
Type  By List 
Value  Value Description 
Balcony  Balcony 
Deck  Deck 
Fence  Fence 
Fireplace  Fireplace 
Intercom  Intercom 
JettedTub  JettedTub 
Other  Other 
Patio  Patio 
Pool  Pool 
Porch  Porch 
SecuritySystem  SecuritySystem 
Spa  Spa 
WoodStove  WoodStove 

AmenityType Bound Attachments 
Name  Current Value 

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

AmenityType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AmenityTypeOtherDescription 
Base Entity  AMENITY 
Attribute Name  AmenityTypeOtherDescription 
Logical Rolename   
ColumnName  AmenityTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to describe the amenity if Other is selected as the Amenity Type. 
Note 
 

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

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

AmenityTypeOtherDescription Bound Attachments 
Name  Current Value 

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

AmenityTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AmenityTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ComponentAdjustmentAmount 
Base Entity  AMENITY 
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 


ComponentClassificationType 
Base Entity  AMENITY 
Attribute Name  ComponentClassificationType 
Logical Rolename   
ColumnName  ComponentClassificationType 
RoleName   
Domain  ComponentClassificationEnum 
Definition  Specifies whether the component is considered real or personal property.  
Note 
 

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

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

ComponentClassificationType Reference Value (Bound to Domain) 
Name  ValidationRule62 
Description   
Type  By List 
Value  Value Description 
PersonalProperty  PersonalProperty 
RealProperty  RealProperty 

ComponentClassificationType Bound Attachments 
Name  Current Value 

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

ComponentClassificationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComponentClassificationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComponentClassificationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ComponentClassificationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConditionRatingDescription 
Base Entity  AMENITY 
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  AMENITY 
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 


MaterialDescription 
Base Entity  AMENITY 
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  AMENITY 
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  AMENITY 
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  AMENITY 
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