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