| CumulativeDaysOnMarketCount |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | CumulativeDaysOnMarketCount |
| Logical Rolename | |
| ColumnName | CumulativeDaysOnMarketCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The total number of days a property is on the market unsold - inclusive of all listing status change dates, from the original listing date to time the listing is selected for the valuation report. |
| Note |
| CumulativeDaysOnMarketCount Logical Attribute Properties |
| Logical Attribute Name | CumulativeDaysOnMarketCount |
| Datatype | INTEGER |
| Nullable | NO |
| CumulativeDaysOnMarketCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CumulativeDaysOnMarketCount Bound Attachments |
| Name | Current Value |
| CumulativeDaysOnMarketCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CumulativeDaysOnMarketCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CumulativeDaysOnMarketCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CumulativeDaysOnMarketCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CumulativeDaysOnMarketCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber |
| Base Entity | LISTING_INFORMATION |
| 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 |
| CurrentListPriceAmount |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | CurrentListPriceAmount |
| Logical Rolename | |
| ColumnName | CurrentListPriceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Current list price (e.g. of the property). |
| Note |
| CurrentListPriceAmount Logical Attribute Properties |
| Logical Attribute Name | CurrentListPriceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| CurrentListPriceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CurrentListPriceAmount Bound Attachments |
| Name | Current Value |
| CurrentListPriceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CurrentListPriceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentListPriceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentListPriceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentListPriceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentlyListedIndicator |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | CurrentlyListedIndicator |
| Logical Rolename | |
| ColumnName | CurrentlyListedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the property is currently listed for sale in MLS. |
| Note |
| CurrentlyListedIndicator Logical Attribute Properties |
| Logical Attribute Name | CurrentlyListedIndicator |
| Datatype | BIT |
| Nullable | NO |
| CurrentlyListedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CurrentlyListedIndicator Bound Attachments |
| Name | Current Value |
| CurrentlyListedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CurrentlyListedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentlyListedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentlyListedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentlyListedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DaysOnMarketCount |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | DaysOnMarketCount |
| Logical Rolename | |
| ColumnName | DaysOnMarketCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The total number of days on the property has been on the market from the last material status date to the time listing selected for the valuation. |
| Note |
| DaysOnMarketCount Logical Attribute Properties |
| Logical Attribute Name | DaysOnMarketCount |
| Datatype | INTEGER |
| Nullable | NO |
| DaysOnMarketCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DaysOnMarketCount Bound Attachments |
| Name | Current Value |
| DaysOnMarketCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DaysOnMarketCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DaysOnMarketCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DaysOnMarketCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DaysOnMarketCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FinalListPriceAmount |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | FinalListPriceAmount |
| Logical Rolename | |
| ColumnName | FinalListPriceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The final list price of the property. |
| Note |
| FinalListPriceAmount Logical Attribute Properties |
| Logical Attribute Name | FinalListPriceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FinalListPriceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FinalListPriceAmount Bound Attachments |
| Name | Current Value |
| FinalListPriceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FinalListPriceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FinalListPriceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FinalListPriceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FinalListPriceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastListPriceRevisionDate |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | LastListPriceRevisionDate |
| Logical Rolename | |
| ColumnName | LastListPriceRevisionDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The most recent date when the property list price was revised. |
| Note |
| LastListPriceRevisionDate Logical Attribute Properties |
| Logical Attribute Name | LastListPriceRevisionDate |
| Datatype | DATE |
| Nullable | NO |
| LastListPriceRevisionDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LastListPriceRevisionDate Bound Attachments |
| Name | Current Value |
| LastListPriceRevisionDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LastListPriceRevisionDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastListPriceRevisionDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastListPriceRevisionDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastListPriceRevisionDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearDescription |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | ListedWithinPreviousYearDescription |
| Logical Rolename | |
| ColumnName | ListedWithinPreviousYearDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text describing the offering prices, dates, and data sources of the previous twelve (12) months of listing |
| Note |
| ListedWithinPreviousYearDescription Logical Attribute Properties |
| Logical Attribute Name | ListedWithinPreviousYearDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ListedWithinPreviousYearDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ListedWithinPreviousYearDescription Bound Attachments |
| Name | Current Value |
| ListedWithinPreviousYearDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ListedWithinPreviousYearDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearIndicator |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | ListedWithinPreviousYearIndicator |
| Logical Rolename | |
| ColumnName | ListedWithinPreviousYearIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the property has been listed within the previous twelve (12) months |
| Note |
| ListedWithinPreviousYearIndicator Logical Attribute Properties |
| Logical Attribute Name | ListedWithinPreviousYearIndicator |
| Datatype | BIT |
| Nullable | NO |
| ListedWithinPreviousYearIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ListedWithinPreviousYearIndicator Bound Attachments |
| Name | Current Value |
| ListedWithinPreviousYearIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ListedWithinPreviousYearIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListedWithinPreviousYearIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusType |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | ListingStatusType |
| Logical Rolename | |
| ColumnName | ListingStatusType |
| RoleName | |
| Domain | ListingStatusEnum |
| Definition | The status of the listing at the time entered to the valuation report. |
| Note |
| ListingStatusType Logical Attribute Properties |
| Logical Attribute Name | ListingStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ListingStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ListingStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule251 |
| Description | |
| Type | By List |
| Value | Value Description |
| Active | Active |
| ContingentSale | ContingentSale |
| Expired | Expired |
| Other | Other |
| PendingSale | PendingSale |
| Sold | Sold |
| Withdrawn | Withdrawn |
| ListingStatusType Bound Attachments |
| Name | Current Value |
| ListingStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ListingStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusTypeOtherDescription |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | ListingStatusTypeOtherDescription |
| Logical Rolename | |
| ColumnName | ListingStatusTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additioal information when Other is selected for the ListingStatusType. |
| Note |
| ListingStatusTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | ListingStatusTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ListingStatusTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ListingStatusTypeOtherDescription Bound Attachments |
| Name | Current Value |
| ListingStatusTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ListingStatusTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ListingStatusTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MLSNumberIdentifier |
| Base Entity | LISTING_INFORMATION |
| 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 |
| OriginalListPriceAmount |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | OriginalListPriceAmount |
| Logical Rolename | |
| ColumnName | OriginalListPriceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The original list price of the property. |
| Note |
| OriginalListPriceAmount Logical Attribute Properties |
| Logical Attribute Name | OriginalListPriceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| OriginalListPriceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OriginalListPriceAmount Bound Attachments |
| Name | Current Value |
| OriginalListPriceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OriginalListPriceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalListPriceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalListPriceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalListPriceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyForecastSalePriceAmount |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | PropertyForecastSalePriceAmount |
| Logical Rolename | |
| ColumnName | PropertyForecastSalePriceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar value of the forecast sales price of the subject property. |
| Note |
| PropertyForecastSalePriceAmount Logical Attribute Properties |
| Logical Attribute Name | PropertyForecastSalePriceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PropertyForecastSalePriceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyForecastSalePriceAmount Bound Attachments |
| Name | Current Value |
| PropertyForecastSalePriceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyForecastSalePriceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyForecastSalePriceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyForecastSalePriceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyForecastSalePriceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyTypicalMarketingDaysDurationType |
| Base Entity | LISTING_INFORMATION |
| Attribute Name | PropertyTypicalMarketingDaysDurationType |
| Logical Rolename | |
| ColumnName | PropertyTypicalMarketingDaysDurationType |
| RoleName | |
| Domain | PropertyTypicalMarketingDaysDurationEnum |
| Definition | Specifies the estimated marketing duration in terms of days for the subject property before it is sold. The use of days to indicate the marketing duration is specific to the Employee Relocation Appraisal Forms. |
| Note |
| PropertyTypicalMarketingDaysDurationType Logical Attribute Properties |
| Logical Attribute Name | PropertyTypicalMarketingDaysDurationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PropertyTypicalMarketingDaysDurationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyTypicalMarketingDaysDurationType Reference Value (Bound to Domain) |
| Name | ValidationRule398 |
| Description | |
| Type | By List |
| Value | Value Description |
| 30To120Days | 30To120Days |
| Over120Days | Over120Days |
| Under30Days | Under30Days |
| PropertyTypicalMarketingDaysDurationType Bound Attachments |
| Name | Current Value |
| PropertyTypicalMarketingDaysDurationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyTypicalMarketingDaysDurationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyTypicalMarketingDaysDurationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyTypicalMarketingDaysDurationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyTypicalMarketingDaysDurationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |