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 |