AccessoryUnitCount |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | AccessoryUnitCount |
Logical Rolename | |
ColumnName | AccessoryUnitCount |
RoleName | |
Domain | MISMOCount |
Definition | A free-form text field used to describe the item of the structure being rated if Other is selected as the Structure Analysis Rating Item Type. |
Note |
AccessoryUnitCount Logical Attribute Properties |
Logical Attribute Name | AccessoryUnitCount |
Datatype | INTEGER |
Nullable | NO |
AccessoryUnitCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AccessoryUnitCount Bound Attachments |
Name | Current Value |
AccessoryUnitCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AccessoryUnitCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AccessoryUnitCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AccessoryUnitCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AccessoryUnitCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdditionsDescription |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | AdditionsDescription |
Logical Rolename | |
ColumnName | AdditionsDescription |
RoleName | |
Domain | MISMOString |
Definition | Describes the number of accessory units associated with the structure |
Note |
AdditionsDescription Logical Attribute Properties |
Logical Attribute Name | AdditionsDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
AdditionsDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AdditionsDescription Bound Attachments |
Name | Current Value |
AdditionsDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AdditionsDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdditionsDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AdditionsDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AdditionsDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AgeYearsCount |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | AgeYearsCount |
Logical Rolename | |
ColumnName | AgeYearsCount |
RoleName | |
Domain | MISMOCount |
Definition | A free-form text field describing the additions made to the structure |
Note |
AgeYearsCount Logical Attribute Properties |
Logical Attribute Name | AgeYearsCount |
Datatype | INTEGER |
Nullable | NO |
AgeYearsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AgeYearsCount Bound Attachments |
Name | Current Value |
AgeYearsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AgeYearsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AgeYearsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AgeYearsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AgeYearsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AtticExistsIndicator |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | AtticExistsIndicator |
Logical Rolename | |
ColumnName | AtticExistsIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | The chronological age measured in years. (i.e. the age of a structure) |
Note |
AtticExistsIndicator Logical Attribute Properties |
Logical Attribute Name | AtticExistsIndicator |
Datatype | BIT |
Nullable | NO |
AtticExistsIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AtticExistsIndicator Bound Attachments |
Name | Current Value |
AtticExistsIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AtticExistsIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AtticExistsIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AtticExistsIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AtticExistsIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BuildingCount |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | BuildingCount |
Logical Rolename | |
ColumnName | BuildingCount |
RoleName | |
Domain | MISMOCount |
Definition | Indicates that the structure has an attic. |
Note |
BuildingCount Logical Attribute Properties |
Logical Attribute Name | BuildingCount |
Datatype | INTEGER |
Nullable | NO |
BuildingCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BuildingCount Bound Attachments |
Name | Current Value |
BuildingCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BuildingCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BuildingCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BuildingCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BuildingCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CharacteristicsAffectMarketabilityDescription |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | CharacteristicsAffectMarketabilityDescription |
Logical Rolename | |
ColumnName | CharacteristicsAffectMarketabilityDescription |
RoleName | |
Domain | MISMOString |
Definition | The number of separate buildings that compose the structure. This is generally one, but may be multiple buildings for detached duplexes that comprise a 2-4 unit. |
Note |
CharacteristicsAffectMarketabilityDescription Logical Attribute Properties |
Logical Attribute Name | CharacteristicsAffectMarketabilityDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
CharacteristicsAffectMarketabilityDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CharacteristicsAffectMarketabilityDescription Bound Attachments |
Name | Current Value |
CharacteristicsAffectMarketabilityDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CharacteristicsAffectMarketabilityDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CharacteristicsAffectMarketabilityDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CharacteristicsAffectMarketabilityDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CharacteristicsAffectMarketabilityDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ElevatorCount |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | ElevatorCount |
Logical Rolename | |
ColumnName | ElevatorCount |
RoleName | |
Domain | MISMOCount |
Definition | A free-form text field describing the characteristics that affect marketability |
Note |
ElevatorCount Logical Attribute Properties |
Logical Attribute Name | ElevatorCount |
Datatype | INTEGER |
Nullable | NO |
ElevatorCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ElevatorCount Bound Attachments |
Name | Current Value |
ElevatorCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ElevatorCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ElevatorCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ElevatorCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ElevatorCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossBuildingAreaSquareFeetNumber |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | GrossBuildingAreaSquareFeetNumber |
Logical Rolename | |
ColumnName | GrossBuildingAreaSquareFeetNumber |
RoleName | |
Domain | MISMONumeric |
Definition | Number of elevators. |
Note |
GrossBuildingAreaSquareFeetNumber Logical Attribute Properties |
Logical Attribute Name | GrossBuildingAreaSquareFeetNumber |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
GrossBuildingAreaSquareFeetNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GrossBuildingAreaSquareFeetNumber Bound Attachments |
Name | Current Value |
GrossBuildingAreaSquareFeetNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GrossBuildingAreaSquareFeetNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossBuildingAreaSquareFeetNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossBuildingAreaSquareFeetNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossBuildingAreaSquareFeetNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetDataSourceDescription |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | GrossLivingAreaSquareFeetDataSourceDescription |
Logical Rolename | |
ColumnName | GrossLivingAreaSquareFeetDataSourceDescription |
RoleName | |
Domain | MISMOString |
Definition | The total area of the structure not limited to living areas |
Note |
GrossLivingAreaSquareFeetDataSourceDescription Logical Attribute Properties |
Logical Attribute Name | GrossLivingAreaSquareFeetDataSourceDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
GrossLivingAreaSquareFeetDataSourceDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GrossLivingAreaSquareFeetDataSourceDescription Bound Attachments |
Name | Current Value |
GrossLivingAreaSquareFeetDataSourceDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GrossLivingAreaSquareFeetDataSourceDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetDataSourceDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetDataSourceDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetDataSourceDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LivingUnitCount |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | LivingUnitCount |
Logical Rolename | |
ColumnName | LivingUnitCount |
RoleName | |
Domain | MISMOCount |
Definition | A free-from text field describing where the value of Gross Living Area Square Feet Count came from. |
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 |
RentControlDescription |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | RentControlDescription |
Logical Rolename | |
ColumnName | RentControlDescription |
RoleName | |
Domain | MISMOString |
Definition | Number of separate living units (i.e. in a structure such as an apartment or duplex). |
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 | STRUCTURE_DETAIL |
Attribute Name | RentControlStatusType |
Logical Rolename | |
ColumnName | RentControlStatusType |
RoleName | |
Domain | RentControlStatusEnum |
Definition | Description of the existing or proposed rent controls for a property. |
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 |
StoriesNumber |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | StoriesNumber |
Logical Rolename | |
ColumnName | StoriesNumber |
RoleName | |
Domain | MISMONumeric |
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 |
StoriesNumber Logical Attribute Properties |
Logical Attribute Name | StoriesNumber |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
StoriesNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StoriesNumber Bound Attachments |
Name | Current Value |
StoriesNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StoriesNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StoriesNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StoriesNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StoriesNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConditionDescription |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | StructureConditionDescription |
Logical Rolename | |
ColumnName | StructureConditionDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe the general condition of the structure. |
Note |
StructureConditionDescription Logical Attribute Properties |
Logical Attribute Name | StructureConditionDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
StructureConditionDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureConditionDescription Bound Attachments |
Name | Current Value |
StructureConditionDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureConditionDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConditionDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConditionDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConditionDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConstructionStatusDescription |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | StructureConstructionStatusDescription |
Logical Rolename | |
ColumnName | StructureConstructionStatusDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form field used to hold additional comments concerning the current status of the construction of the structure. |
Note |
StructureConstructionStatusDescription Logical Attribute Properties |
Logical Attribute Name | StructureConstructionStatusDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
StructureConstructionStatusDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureConstructionStatusDescription Bound Attachments |
Name | Current Value |
StructureConstructionStatusDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureConstructionStatusDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConstructionStatusDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConstructionStatusDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureConstructionStatusDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureNeverOccupiedIndicator |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | StructureNeverOccupiedIndicator |
Logical Rolename | |
ColumnName | StructureNeverOccupiedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the structure has never been occupied since it was completed. |
Note |
StructureNeverOccupiedIndicator Logical Attribute Properties |
Logical Attribute Name | StructureNeverOccupiedIndicator |
Datatype | BIT |
Nullable | NO |
StructureNeverOccupiedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureNeverOccupiedIndicator Bound Attachments |
Name | Current Value |
StructureNeverOccupiedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureNeverOccupiedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureNeverOccupiedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureNeverOccupiedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureNeverOccupiedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureSingleFamilyResidenceIndicator |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | StructureSingleFamilyResidenceIndicator |
Logical Rolename | |
ColumnName | StructureSingleFamilyResidenceIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the structure is a single-family residence. |
Note |
StructureSingleFamilyResidenceIndicator Logical Attribute Properties |
Logical Attribute Name | StructureSingleFamilyResidenceIndicator |
Datatype | BIT |
Nullable | NO |
StructureSingleFamilyResidenceIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureSingleFamilyResidenceIndicator Bound Attachments |
Name | Current Value |
StructureSingleFamilyResidenceIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureSingleFamilyResidenceIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureSingleFamilyResidenceIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureSingleFamilyResidenceIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureSingleFamilyResidenceIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateDescription |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | StructureStateDescription |
Logical Rolename | |
ColumnName | StructureStateDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe the existence or proposed construction of a structure. |
Note |
StructureStateDescription Logical Attribute Properties |
Logical Attribute Name | StructureStateDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
StructureStateDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureStateDescription Bound Attachments |
Name | Current Value |
StructureStateDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureStateDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateType |
Base Entity | STRUCTURE_DETAIL |
Attribute Name | StructureStateType |
Logical Rolename | |
ColumnName | StructureStateType |
RoleName | |
Domain | StructureStateEnum |
Definition | Indicates whether the construction of the structure is complete. |
Note |
StructureStateType Logical Attribute Properties |
Logical Attribute Name | StructureStateType |
Datatype | VARCHAR(0) |
Nullable | YES |
StructureStateType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructureStateType Reference Value (Bound to Domain) |
Name | ValidationRule463 |
Description | |
Type | By List |
Value | Value Description |
Complete | Complete |
Incomplete | Incomplete |
NotStarted | NotStarted |
StructureStateType Bound Attachments |
Name | Current Value |
StructureStateType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructureStateType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructureStateType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |