LISTING_INFORMATION Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
CumulativeDaysOnMarketCount	MISMOCount	INTEGER	NO	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.
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
CurrentListPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	Current list price (e.g. of the property).
CurrentlyListedIndicator	MISMOIndicator	BIT	NO	Indicates that the property is currently listed for sale in MLS.
DaysOnMarketCount	MISMOCount	INTEGER	NO	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.
FinalListPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The final list price of the property.
LastListPriceRevisionDate	MISMODate	DATE	NO	The most recent date when the property list price was revised.
ListedWithinPreviousYearDescription	MISMOString	VARCHAR(0)	NO	A free-form text describing the offering prices, dates, and data sources of the previous twelve (12) months of listing
ListedWithinPreviousYearIndicator	MISMOIndicator	BIT	NO	Indicates that the property has been listed within the previous twelve (12) months
ListingStatusType	ListingStatusEnum	VARCHAR(0)	YES	The status of the listing at the time entered to the valuation report.
ListingStatusTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additioal information when Other is selected for the ListingStatusType.
MLSNumberIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Identifies the record number in the local MLS from which the listing was obtained.
OriginalListPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The original list price of the property.
PropertyForecastSalePriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar value of the forecast sales price of the subject property.
PropertyTypicalMarketingDaysDurationType	PropertyTypicalMarketingDaysDurationEnum	VARCHAR(0)	YES	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.

LISTING_INFORMATION Keys

Key Name

Key Type

Keys

LISTING_INFORMATION Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
LISTING_INFORMATIONS	Identifying	One To Zero or More					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

LISTING_INFORMATION Check Constraints

Check Constraint Name

CheckConstraint

LISTING_INFORMATION Bound Attachments

Name	Current Value

LISTING_INFORMATION User-Defined Mappings

Model

Name

Description

LISTING_INFORMATION Data Movement Rules

Name

Type

Rule Text/Value