ComparableAdjustmentAmount 
Base Entity  COMPARABLE_ADJUSTMENT 
Attribute Name  ComparableAdjustmentAmount 
Logical Rolename   
ColumnName  ComparableAdjustmentAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount of the adjustment applied to the price for the property feature identified by the Comparable Adjustment Type. 
Note 
 

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

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

ComparableAdjustmentAmount Bound Attachments 
Name  Current Value 

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

ComparableAdjustmentAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SequenceNumber 
Base Entity  COMPARABLE_ADJUSTMENT 
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 


ComparableAdjustmentDescription 
Base Entity  COMPARABLE_ADJUSTMENT 
Attribute Name  ComparableAdjustmentDescription 
Logical Rolename   
ColumnName  ComparableAdjustmentDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to further describe a property feature which is identified in the Comparable Adjustment Type. 
Note 
 

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

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

ComparableAdjustmentDescription Bound Attachments 
Name  Current Value 

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

ComparableAdjustmentDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ComparableAdjustmentType 
Base Entity  COMPARABLE_ADJUSTMENT 
Attribute Name  ComparableAdjustmentType 
Logical Rolename   
ColumnName  ComparableAdjustmentType 
RoleName   
Domain  ComparableAdjustmentEnum 
Definition  Specifies the type of price adjustment that is made when when comparing to sales and listings to value a property. Each type corresponds to a feature of the property. E.g. Condition, age, view, etc.  
Note 
 

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

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

ComparableAdjustmentType Reference Value (Bound to Domain) 
Name  ValidationRule57 
Description   
Type  By List 
Value  Value Description 
Additions  Additions 
AdjustedMonthlyRent  AdjustedMonthlyRent 
Age  Age 
BasementArea  BasementArea 
BasementFinish  BasementFinish 
CarStorage  CarStorage 
CommonElements  CommonElements 
Condition  Condition 
DateOfSale  DateOfSale 
DesignAppeal  DesignAppeal 
DesignStyle  DesignStyle 
EffectiveAge  EffectiveAge 
EnergyEfficient  EnergyEfficient 
FencePool  FencePool 
FinancingConcessions  FinancingConcessions 
Fireplaces  Fireplaces 
FloorLocation  FloorLocation 
Forecasting  Forecasting 
FunctionalUtility  FunctionalUtility 
Furnishings  Furnishings 
GarageCarport  GarageCarport 
GrossBuildingArea  GrossBuildingArea 
GrossLivingArea  GrossLivingArea 
HeatingCooling  HeatingCooling 
InteriorAppeal  InteriorAppeal 
Location  Location 
Make  Make 
MaintenanceFees  MaintenanceFees 
MarketChange  MarketChange 
MonthlyFacilityFee  MonthlyFacilityFee 
NeighborhoodAppeal  NeighborhoodAppeal 
Other  Other 
Parking  Parking 
PorchDeck  PorchDeck 
ProjectAmenities  ProjectAmenities 
ProjectSize  ProjectSize 
PropertyRights  PropertyRights 
ProjectSecurity  ProjectSecurity 
Quality  Quality 
RecreationFacilities  RecreationFacilities 
RemodelBath  RemodelBath 
RemodelKitchen  RemodelKitchen 
RentConcessions  RentConcessions 
RoomsBelowGrade  RoomsBelowGrade 
SalesConcessions  SalesConcessions 
SecurityFeatures  SecurityFeatures 
SignificantFeatures  SignificantFeatures 
SiteAppeal  SiteAppeal 
SiteArea  SiteArea 
SiteValue  SiteValue 
TipOut  TipOut 
Utilities  Utilities 
View  View 

ComparableAdjustmentType Bound Attachments 
Name  Current Value 

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

ComparableAdjustmentType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ComparableAdjustmentTypeOtherDescription 
Base Entity  COMPARABLE_ADJUSTMENT 
Attribute Name  ComparableAdjustmentTypeOtherDescription 
Logical Rolename   
ColumnName  ComparableAdjustmentTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to capture additional information when other is selected for Comparable Price Adjustment Type. 
Note 
 

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

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

ComparableAdjustmentTypeOtherDescription Bound Attachments 
Name  Current Value 

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

ComparableAdjustmentTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ComparableAdjustmentTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description