LivingUnitCount |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | LivingUnitCount |
Logical Rolename | |
ColumnName | LivingUnitCount |
RoleName | |
Domain | MISMOCount |
Definition | Number of separate living units (i.e. in a structure such as an apartment or duplex). |
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 |
SequenceNumber |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
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 |
RentControlDescription |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | RentControlDescription |
Logical Rolename | |
ColumnName | RentControlDescription |
RoleName | |
Domain | MISMOString |
Definition | Description of the existing or proposed rent controls for a property. |
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 | COMPARISON_TO_NEIGHBORHOOD |
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 |
StoriesCount |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | StoriesCount |
Logical Rolename | |
ColumnName | StoriesCount |
RoleName | |
Domain | MISMOCount |
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 |
StoriesCount Logical Attribute Properties |
Logical Attribute Name | StoriesCount |
Datatype | INTEGER |
Nullable | NO |
StoriesCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StoriesCount Bound Attachments |
Name | Current Value |
StoriesCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StoriesCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StoriesCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StoriesCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StoriesCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureType |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | StructureFeatureType |
Logical Rolename | |
ColumnName | StructureFeatureType |
RoleName | |
Domain | StructureFeatureEnum |
Definition | Specifies an aspect of the structure that is typical to its neighborhood. |
Note |
StructureFeatureType Logical Attribute Properties |
Logical Attribute Name | StructureFeatureType |
Datatype | VARCHAR(0) |
Nullable | YES |
StructureFeatureType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureFeatureType Reference Value (Bound to Domain) |
Name | ValidationRule462 |
Description | |
Type | By List |
Value | Value Description |
Age | Age |
Appeal | Appeal |
Design | Design |
GrossLivingArea | GrossLivingArea |
LotShapeAndTopography | LotShapeAndTopography |
LotSize | LotSize |
MaterialAndConstruction | MaterialAndConstruction |
Other | Other |
Overall | Overall |
Utilities | Utilities |
View | View |
StructureFeatureType Bound Attachments |
Name | Current Value |
StructureFeatureType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureFeatureType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureTypeOtherDescription |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | StructureFeatureTypeOtherDescription |
Logical Rolename | |
ColumnName | StructureFeatureTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe a structure feature if Other is selected as the Structure Feature Type. |
Note |
StructureFeatureTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | StructureFeatureTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
StructureFeatureTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureFeatureTypeOtherDescription Bound Attachments |
Name | Current Value |
StructureFeatureTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureFeatureTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureFeatureTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodAtypicalDescription |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | StructureTypicalToNeighborhoodAtypicalDescription |
Logical Rolename | |
ColumnName | StructureTypicalToNeighborhoodAtypicalDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field describing how the structure differs from the typical neighborhood structure |
Note |
StructureTypicalToNeighborhoodAtypicalDescription Logical Attribute Properties |
Logical Attribute Name | StructureTypicalToNeighborhoodAtypicalDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
StructureTypicalToNeighborhoodAtypicalDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureTypicalToNeighborhoodAtypicalDescription Bound Attachments |
Name | Current Value |
StructureTypicalToNeighborhoodAtypicalDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureTypicalToNeighborhoodAtypicalDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodAtypicalDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodAtypicalDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodAtypicalDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodExistsIndicator |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | StructureTypicalToNeighborhoodExistsIndicator |
Logical Rolename | |
ColumnName | StructureTypicalToNeighborhoodExistsIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the aspect specified by Structure Typical To Neighborhood is present in the structure |
Note |
StructureTypicalToNeighborhoodExistsIndicator Logical Attribute Properties |
Logical Attribute Name | StructureTypicalToNeighborhoodExistsIndicator |
Datatype | BIT |
Nullable | NO |
StructureTypicalToNeighborhoodExistsIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureTypicalToNeighborhoodExistsIndicator Bound Attachments |
Name | Current Value |
StructureTypicalToNeighborhoodExistsIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureTypicalToNeighborhoodExistsIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodExistsIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodExistsIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureTypicalToNeighborhoodExistsIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentDescription |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | TypicalApartmentDescription |
Logical Rolename | |
ColumnName | TypicalApartmentDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe the typical comparable buildings in the property neighborhood. |
Note |
TypicalApartmentDescription Logical Attribute Properties |
Logical Attribute Name | TypicalApartmentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
TypicalApartmentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TypicalApartmentDescription Bound Attachments |
Name | Current Value |
TypicalApartmentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TypicalApartmentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentEstimatedVacancyPercent |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | TypicalApartmentEstimatedVacancyPercent |
Logical Rolename | |
ColumnName | TypicalApartmentEstimatedVacancyPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The estimated vacancy percentage for a typical two-to-four family building the property neighborhood. |
Note |
TypicalApartmentEstimatedVacancyPercent Logical Attribute Properties |
Logical Attribute Name | TypicalApartmentEstimatedVacancyPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
TypicalApartmentEstimatedVacancyPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TypicalApartmentEstimatedVacancyPercent Bound Attachments |
Name | Current Value |
TypicalApartmentEstimatedVacancyPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TypicalApartmentEstimatedVacancyPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentEstimatedVacancyPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentEstimatedVacancyPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentEstimatedVacancyPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentHighPriceAmount |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | TypicalApartmentRentHighPriceAmount |
Logical Rolename | |
ColumnName | TypicalApartmentRentHighPriceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The high end of the range of typical market rents in the neighborhood. |
Note |
TypicalApartmentRentHighPriceAmount Logical Attribute Properties |
Logical Attribute Name | TypicalApartmentRentHighPriceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
TypicalApartmentRentHighPriceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TypicalApartmentRentHighPriceAmount Bound Attachments |
Name | Current Value |
TypicalApartmentRentHighPriceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TypicalApartmentRentHighPriceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentHighPriceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentHighPriceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentHighPriceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentLowPriceAmount |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | TypicalApartmentRentLowPriceAmount |
Logical Rolename | |
ColumnName | TypicalApartmentRentLowPriceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The low end of the range of typical market rents in the neighborhood. |
Note |
TypicalApartmentRentLowPriceAmount Logical Attribute Properties |
Logical Attribute Name | TypicalApartmentRentLowPriceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
TypicalApartmentRentLowPriceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TypicalApartmentRentLowPriceAmount Bound Attachments |
Name | Current Value |
TypicalApartmentRentLowPriceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TypicalApartmentRentLowPriceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentLowPriceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentLowPriceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentLowPriceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentTrendType |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | TypicalApartmentRentTrendType |
Logical Rolename | |
ColumnName | TypicalApartmentRentTrendType |
RoleName | |
Domain | TypicalApartmentRentTrendEnum |
Definition | Specifies the current trend in rent prices for the typical apartment in the neighborhood. |
Note |
TypicalApartmentRentTrendType Logical Attribute Properties |
Logical Attribute Name | TypicalApartmentRentTrendType |
Datatype | VARCHAR(0) |
Nullable | YES |
TypicalApartmentRentTrendType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TypicalApartmentRentTrendType Reference Value (Bound to Domain) |
Name | ValidationRule311 |
Description | |
Type | By List |
Value | Value Description |
Decreasing | Decreasing |
Increasing | Increasing |
Stable | Stable |
TypicalApartmentRentTrendType Bound Attachments |
Name | Current Value |
TypicalApartmentRentTrendType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TypicalApartmentRentTrendType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentTrendType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentTrendType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentRentTrendType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentVacancyTrendType |
Base Entity | COMPARISON_TO_NEIGHBORHOOD |
Attribute Name | TypicalApartmentVacancyTrendType |
Logical Rolename | |
ColumnName | TypicalApartmentVacancyTrendType |
RoleName | |
Domain | TypicalApartmentVacancyTrendEnum |
Definition | Specifies the current trend in vacancy rates for the typical apartment in the neighborhood. |
Note |
TypicalApartmentVacancyTrendType Logical Attribute Properties |
Logical Attribute Name | TypicalApartmentVacancyTrendType |
Datatype | VARCHAR(0) |
Nullable | YES |
TypicalApartmentVacancyTrendType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TypicalApartmentVacancyTrendType Reference Value (Bound to Domain) |
Name | ValidationRule311 |
Description | |
Type | By List |
Value | Value Description |
Decreasing | Decreasing |
Increasing | Increasing |
Stable | Stable |
TypicalApartmentVacancyTrendType Bound Attachments |
Name | Current Value |
TypicalApartmentVacancyTrendType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TypicalApartmentVacancyTrendType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentVacancyTrendType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentVacancyTrendType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TypicalApartmentVacancyTrendType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |