AdjustedSalesPriceAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | AdjustedSalesPriceAmount |
Logical Rolename | |
ColumnName | AdjustedSalesPriceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The sales price of a property after it has been adjusted during the application of the Sales Comparison approach for property valuation. |
Note |
AdjustedSalesPriceAmount Logical Attribute Properties |
Logical Attribute Name | AdjustedSalesPriceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
AdjustedSalesPriceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AdjustedSalesPriceAmount Bound Attachments |
Name | Current Value |
AdjustedSalesPriceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AdjustedSalesPriceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPriceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPriceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPriceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerBedroomAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | AdjustedSalesPricePerBedroomAmount |
Logical Rolename | |
ColumnName | AdjustedSalesPricePerBedroomAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of a bedroom determined by dividing the adjusted sales price by the number of bedrooms in a property. This field is specific to appraisal forms. (CALCULATED RESULTS FIELD) |
Note |
AdjustedSalesPricePerBedroomAmount Logical Attribute Properties |
Logical Attribute Name | AdjustedSalesPricePerBedroomAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
AdjustedSalesPricePerBedroomAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AdjustedSalesPricePerBedroomAmount Bound Attachments |
Name | Current Value |
AdjustedSalesPricePerBedroomAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AdjustedSalesPricePerBedroomAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerBedroomAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerBedroomAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerBedroomAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerRoomAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | AdjustedSalesPricePerRoomAmount |
Logical Rolename | |
ColumnName | AdjustedSalesPricePerRoomAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of a room determined by dividing the adjusted sales price by the number of rooms in a property. This field is specific to appraisal forms. (CALCULATED RESULTS FIELD). |
Note |
AdjustedSalesPricePerRoomAmount Logical Attribute Properties |
Logical Attribute Name | AdjustedSalesPricePerRoomAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
AdjustedSalesPricePerRoomAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AdjustedSalesPricePerRoomAmount Bound Attachments |
Name | Current Value |
AdjustedSalesPricePerRoomAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AdjustedSalesPricePerRoomAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerRoomAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerRoomAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerRoomAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerUnitAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | AdjustedSalesPricePerUnitAmount |
Logical Rolename | |
ColumnName | AdjustedSalesPricePerUnitAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of a living unit determined by dividing the adjusted sales price by the number of living units in a multi-unit property. This field is specific to appraisal forms. (CALCULATED RESULTS FIELD) |
Note |
AdjustedSalesPricePerUnitAmount Logical Attribute Properties |
Logical Attribute Name | AdjustedSalesPricePerUnitAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
AdjustedSalesPricePerUnitAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AdjustedSalesPricePerUnitAmount Bound Attachments |
Name | Current Value |
AdjustedSalesPricePerUnitAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AdjustedSalesPricePerUnitAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerUnitAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerUnitAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdjustedSalesPricePerUnitAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ClosedSaleCommentDescription |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ClosedSaleCommentDescription |
Logical Rolename | |
ColumnName | ClosedSaleCommentDescription |
RoleName | |
Domain | MISMOString |
Definition | Text comments about the closed sale information. |
Note |
ClosedSaleCommentDescription Logical Attribute Properties |
Logical Attribute Name | ClosedSaleCommentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ClosedSaleCommentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ClosedSaleCommentDescription Bound Attachments |
Name | Current Value |
ClosedSaleCommentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ClosedSaleCommentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ClosedSaleCommentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ClosedSaleCommentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ClosedSaleCommentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableIdentifier |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ComparableIdentifier |
Logical Rolename | |
ColumnName | ComparableIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | Identifies the positional location on the appraisal form in which the comparable appears. |
Note |
ComparableIdentifier Logical Attribute Properties |
Logical Attribute Name | ComparableIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
ComparableIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ComparableIdentifier Bound Attachments |
Name | Current Value |
ComparableIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ComparableIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableListingCommentDescription |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ComparableListingCommentDescription |
Logical Rolename | |
ColumnName | ComparableListingCommentDescription |
RoleName | |
Domain | MISMOString |
Definition | Text comments about the listing information. |
Note |
ComparableListingCommentDescription Logical Attribute Properties |
Logical Attribute Name | ComparableListingCommentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ComparableListingCommentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ComparableListingCommentDescription Bound Attachments |
Name | Current Value |
ComparableListingCommentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ComparableListingCommentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableListingCommentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableListingCommentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableListingCommentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparablePropertyCommentDescription |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ComparablePropertyCommentDescription |
Logical Rolename | |
ColumnName | ComparablePropertyCommentDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe or comment on the comparable property used in the application of the Sales Comparison approach to property valuation. |
Note |
ComparablePropertyCommentDescription Logical Attribute Properties |
Logical Attribute Name | ComparablePropertyCommentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ComparablePropertyCommentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ComparablePropertyCommentDescription Bound Attachments |
Name | Current Value |
ComparablePropertyCommentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ComparablePropertyCommentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparablePropertyCommentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparablePropertyCommentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparablePropertyCommentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableSaleFurnishedIndicator |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ComparableSaleFurnishedIndicator |
Logical Rolename | |
ColumnName | ComparableSaleFurnishedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether the comparable property is furnished. |
Note |
ComparableSaleFurnishedIndicator Logical Attribute Properties |
Logical Attribute Name | ComparableSaleFurnishedIndicator |
Datatype | BIT |
Nullable | NO |
ComparableSaleFurnishedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ComparableSaleFurnishedIndicator Bound Attachments |
Name | Current Value |
ComparableSaleFurnishedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ComparableSaleFurnishedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableSaleFurnishedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableSaleFurnishedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableSaleFurnishedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableType |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ComparableType |
Logical Rolename | |
ColumnName | ComparableType |
RoleName | |
Domain | ComparableEnum |
Definition | Indicates the status of the property as either a competitive offering, comparable offering, comparable active listing, comparable expired listing or closed sale. |
Note |
ComparableType Logical Attribute Properties |
Logical Attribute Name | ComparableType |
Datatype | VARCHAR(0) |
Nullable | YES |
ComparableType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ComparableType Reference Value (Bound to Domain) |
Name | ValidationRule58 |
Description | |
Type | By List |
Value | Value Description |
ActiveListing | ActiveListing |
ClosedSale | ClosedSale |
CompetitiveOffering | CompetitiveOffering |
ExpiredListing | ExpiredListing |
Other | Other |
ComparableType Bound Attachments |
Name | Current Value |
ComparableType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ComparableType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableTypeOtherDescription |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ComparableTypeOtherDescription |
Logical Rolename | |
ColumnName | ComparableTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Comparable Type |
Note |
ComparableTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | ComparableTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ComparableTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ComparableTypeOtherDescription Bound Attachments |
Name | Current Value |
ComparableTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ComparableTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComparableTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CompetitiveListingsCommentDescription |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | CompetitiveListingsCommentDescription |
Logical Rolename | |
ColumnName | CompetitiveListingsCommentDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to describe and reconcile the competitive listings used. |
Note |
CompetitiveListingsCommentDescription Logical Attribute Properties |
Logical Attribute Name | CompetitiveListingsCommentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
CompetitiveListingsCommentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CompetitiveListingsCommentDescription Bound Attachments |
Name | Current Value |
CompetitiveListingsCommentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CompetitiveListingsCommentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CompetitiveListingsCommentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CompetitiveListingsCommentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CompetitiveListingsCommentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossMonthlyRentMultiplierPercent |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | GrossMonthlyRentMultiplierPercent |
Logical Rolename | |
ColumnName | GrossMonthlyRentMultiplierPercent |
RoleName | |
Domain | MISMOPercent |
Definition | Specifies the multiplier factor used in calculating the Gross Monthly Rent of a property. |
Note |
GrossMonthlyRentMultiplierPercent Logical Attribute Properties |
Logical Attribute Name | GrossMonthlyRentMultiplierPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
GrossMonthlyRentMultiplierPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GrossMonthlyRentMultiplierPercent Bound Attachments |
Name | Current Value |
GrossMonthlyRentMultiplierPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GrossMonthlyRentMultiplierPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossMonthlyRentMultiplierPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossMonthlyRentMultiplierPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossMonthlyRentMultiplierPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MLSNumberIdentifier |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | MLSNumberIdentifier |
Logical Rolename | |
ColumnName | MLSNumberIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | Identifies the record number in the local MLS from which the listing was obtained. |
Note |
MLSNumberIdentifier Logical Attribute Properties |
Logical Attribute Name | MLSNumberIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
MLSNumberIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MLSNumberIdentifier Bound Attachments |
Name | Current Value |
MLSNumberIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MLSNumberIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MLSNumberIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MLSNumberIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MLSNumberIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | MonthlyRentAmount |
Logical Rolename | |
ColumnName | MonthlyRentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount paid by the borrower or coborrower for the rental of a residence property. This information is normally provided during interview with the borrower or obtained from a loan application, and is sometimes verified with the residence property landl |
Note |
MonthlyRentAmount Logical Attribute Properties |
Logical Attribute Name | MonthlyRentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MonthlyRentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MonthlyRentAmount Bound Attachments |
Name | Current Value |
MonthlyRentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MonthlyRentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PricePerSquareFootAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | PricePerSquareFootAmount |
Logical Rolename | |
ColumnName | PricePerSquareFootAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The price in terms of dollars per square foot. This is a ratio between a price and an area, but it is a monetary value rather than a factor or rate. (i.e. sales price per gross living area of a property) |
Note |
PricePerSquareFootAmount Logical Attribute Properties |
Logical Attribute Name | PricePerSquareFootAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PricePerSquareFootAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PricePerSquareFootAmount Bound Attachments |
Name | Current Value |
PricePerSquareFootAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PricePerSquareFootAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PricePerSquareFootAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PricePerSquareFootAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PricePerSquareFootAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ProximityToSubjectDescription |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | ProximityToSubjectDescription |
Logical Rolename | |
ColumnName | ProximityToSubjectDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe the proximity of a comparable property to the subject property. |
Note |
ProximityToSubjectDescription Logical Attribute Properties |
Logical Attribute Name | ProximityToSubjectDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ProximityToSubjectDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ProximityToSubjectDescription Bound Attachments |
Name | Current Value |
ProximityToSubjectDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ProximityToSubjectDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ProximityToSubjectDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ProximityToSubjectDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ProximityToSubjectDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentControlStatusType |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | RentControlStatusType |
Logical Rolename | |
ColumnName | RentControlStatusType |
RoleName | |
Domain | RentControlStatusEnum |
Definition | Specifies the existence or likelihood of rent controls such as controls on businesses and apartment complexes. |
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 |
SalePriceTotalAdjustmentAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalePriceTotalAdjustmentAmount |
Logical Rolename | |
ColumnName | SalePriceTotalAdjustmentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of the total adjustments made to a comparable property sales price during the application of the Sales Comparison approach to determine the market value of the subject property. (CALCULATED RESULTS FIELD) |
Note |
SalePriceTotalAdjustmentAmount Logical Attribute Properties |
Logical Attribute Name | SalePriceTotalAdjustmentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalePriceTotalAdjustmentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalePriceTotalAdjustmentAmount Bound Attachments |
Name | Current Value |
SalePriceTotalAdjustmentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalePriceTotalAdjustmentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalePriceTotalAdjustmentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalePriceTotalAdjustmentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalePriceTotalAdjustmentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalePriceTotalAdjustmentNetPercent |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalePriceTotalAdjustmentNetPercent |
Logical Rolename | |
ColumnName | SalePriceTotalAdjustmentNetPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage of the net sales price adjustments to the sales price of a property during the application of the sales comparison approach to property valuation. (CALCULATED RESULTS FIELD) |
Note |
SalePriceTotalAdjustmentNetPercent Logical Attribute Properties |
Logical Attribute Name | SalePriceTotalAdjustmentNetPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalePriceTotalAdjustmentNetPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalePriceTotalAdjustmentNetPercent Bound Attachments |
Name | Current Value |
SalePriceTotalAdjustmentNetPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalePriceTotalAdjustmentNetPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalePriceTotalAdjustmentNetPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalePriceTotalAdjustmentNetPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalePriceTotalAdjustmentNetPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerBedroomAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPricePerBedroomAmount |
Logical Rolename | |
ColumnName | SalesPricePerBedroomAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of a bedroom of the property determined by dividing the sales price by the total number of bedrooms in the property. (CALCULATED RESULTS FIELD) |
Note |
SalesPricePerBedroomAmount Logical Attribute Properties |
Logical Attribute Name | SalesPricePerBedroomAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPricePerBedroomAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPricePerBedroomAmount Bound Attachments |
Name | Current Value |
SalesPricePerBedroomAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPricePerBedroomAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerBedroomAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerBedroomAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerBedroomAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossBuildingAreaAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPricePerGrossBuildingAreaAmount |
Logical Rolename | |
ColumnName | SalesPricePerGrossBuildingAreaAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The sales price in terms of dollars per square foot of the gross building area. This is a ratio between the sales price and an area, but it is a monetary value rather than a factor or rate. (CALCULATED RESULTS FIELD) |
Note |
SalesPricePerGrossBuildingAreaAmount Logical Attribute Properties |
Logical Attribute Name | SalesPricePerGrossBuildingAreaAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPricePerGrossBuildingAreaAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPricePerGrossBuildingAreaAmount Bound Attachments |
Name | Current Value |
SalesPricePerGrossBuildingAreaAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPricePerGrossBuildingAreaAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossBuildingAreaAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossBuildingAreaAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossBuildingAreaAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossLivingAreaAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPricePerGrossLivingAreaAmount |
Logical Rolename | |
ColumnName | SalesPricePerGrossLivingAreaAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The sales price in terms of dollars per square foot of gross living area. This is a ratio between the sales price and an area, but it is a monetary value rather than a factor or rate. (CALCULATED RESULTS FIELD) |
Note |
SalesPricePerGrossLivingAreaAmount Logical Attribute Properties |
Logical Attribute Name | SalesPricePerGrossLivingAreaAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPricePerGrossLivingAreaAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPricePerGrossLivingAreaAmount Bound Attachments |
Name | Current Value |
SalesPricePerGrossLivingAreaAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPricePerGrossLivingAreaAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossLivingAreaAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossLivingAreaAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerGrossLivingAreaAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerOwnershipShareAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPricePerOwnershipShareAmount |
Logical Rolename | |
ColumnName | SalesPricePerOwnershipShareAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of one share of the property determined by dividing the sales price by the total number of property ownership shares. (CALCULATED RESULTS FIELD) |
Note |
SalesPricePerOwnershipShareAmount Logical Attribute Properties |
Logical Attribute Name | SalesPricePerOwnershipShareAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPricePerOwnershipShareAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPricePerOwnershipShareAmount Bound Attachments |
Name | Current Value |
SalesPricePerOwnershipShareAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPricePerOwnershipShareAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerOwnershipShareAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerOwnershipShareAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerOwnershipShareAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerRoomAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPricePerRoomAmount |
Logical Rolename | |
ColumnName | SalesPricePerRoomAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of one room of the property determined by dividing the sales price by the total number of rooms in the property. (CALCULATED RESULTS FIELD) |
Note |
SalesPricePerRoomAmount Logical Attribute Properties |
Logical Attribute Name | SalesPricePerRoomAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPricePerRoomAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPricePerRoomAmount Bound Attachments |
Name | Current Value |
SalesPricePerRoomAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPricePerRoomAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerRoomAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerRoomAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerRoomAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerUnitAmount |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPricePerUnitAmount |
Logical Rolename | |
ColumnName | SalesPricePerUnitAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar value of a living unit in a multi-unit property determined by dividing the sales price by the total number of units within the property. (CALCULATED RESULTS FIELD) |
Note |
SalesPricePerUnitAmount Logical Attribute Properties |
Logical Attribute Name | SalesPricePerUnitAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPricePerUnitAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPricePerUnitAmount Bound Attachments |
Name | Current Value |
SalesPricePerUnitAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPricePerUnitAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerUnitAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerUnitAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPricePerUnitAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceToListPriceRatePercent |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPriceToListPriceRatePercent |
Logical Rolename | |
ColumnName | SalesPriceToListPriceRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | Specifies the ratio of the property sales price to its list price. |
Note |
SalesPriceToListPriceRatePercent Logical Attribute Properties |
Logical Attribute Name | SalesPriceToListPriceRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPriceToListPriceRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPriceToListPriceRatePercent Bound Attachments |
Name | Current Value |
SalesPriceToListPriceRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPriceToListPriceRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceToListPriceRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceToListPriceRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceToListPriceRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceTotalAdjustmentGrossPercent |
Base Entity | COMPARABLE_DETAIL |
Attribute Name | SalesPriceTotalAdjustmentGrossPercent |
Logical Rolename | |
ColumnName | SalesPriceTotalAdjustmentGrossPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage of the gross sales price adjustments (i.e. sum of the absolute adjustment values) to the sales price of a property during the application of the sales comparison approach for property valuation. (CALCULATED RESULTS FIELD) |
Note |
SalesPriceTotalAdjustmentGrossPercent Logical Attribute Properties |
Logical Attribute Name | SalesPriceTotalAdjustmentGrossPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
SalesPriceTotalAdjustmentGrossPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SalesPriceTotalAdjustmentGrossPercent Bound Attachments |
Name | Current Value |
SalesPriceTotalAdjustmentGrossPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SalesPriceTotalAdjustmentGrossPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceTotalAdjustmentGrossPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceTotalAdjustmentGrossPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SalesPriceTotalAdjustmentGrossPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |