
Important Date Fields
- All classes contain the
MODIFIED field which is a date and time the record was last changed. For
new listings, this date and time is when the listing was added to MLS. It
changes when media is added, edited, or modified.Will not update when
display order is changed.
- The MODIFIED field on the MEDIA class is updated when
the media is added or modified (it is not updated when any media is
deleted). When media is added, edited, or modified, it changes the MODIFIED
field on the property classes.
- The PHOTODATE field in the property classes is updated
whenever any media is modified (pictures, attachements, etc), including
removal of records. Will not update if display order is changed. PhotoDate
will not equate to the Modified field (MEDIA class). Listings with a MLS
Number less than 10,000,000 may not have a PhotoDate. These are either
listings that pre-date the current MLS System, or were added with the
Abilene merger.
- The INPUTDATE field on theMEDIA class is populated a
media record is created.
- Some RETS Security Profiles may
include DAYSONMARKET and CDOM (Cumulative Days on Market). When these
fields are updated, the MODIFIED field is not updated.
- The STATUSCHANGEDATE is the date
and time a non-Active status is changed on a listing. Listings with an ACT,
CON, OPT, or KO status do not have a STATUSCHANGEDATE, but all other
statuses will have value for this field. This allows you to download all
records that Expired, went Pending, were Withdrawn or Cancelled or were sold
by entering one date in this field. The STATUSCHANGEDATE is not avaible
for the basic IDX data feed.
- The PHOTODATE updates whenever
any media is modified, added, or deleted. PHOTODATE will not update if
display order is changed.
NOTE:
Per the NTREIS Business Rules, the CLOSEDDATE for Sold or Leased properties
should always be the same as the STATUSCHANGEDATE. Both refer to the date the
property was sold and is not the date the status was changed in the system.
However, a flaw has been discovered in the MLS Code. Under certain
circumstances, the CLOSEDDATE and STATUSCHANGEDATE are not always the same.
NTREIS suggests for Sold or Leased properties to use the CLOSEDDATE.
Updated:
9/15/2010