Important Date Fields

• All classes contain the MODIFIED field which is a date and time the record as last changed.  For new listings, this date and time is when the listing was added to MLS.  It also changes when media is added, edited, or modified.
• 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 MODIFIED field on the MEDIA class is updated when the media is added or modified.  When media is added, edited, or modified, it changes the MODIFIED field on the property classes.
• The STATUSCHANGEDATE is the date and time a status is changed on a listing.  Listing with 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.

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 program.  Under certain circumstances, the CLOSEDDATE and STATUSCHANGEDATE are not always the same.  NTREIS suggests for Sold or Leased properties to use the CLOSEDDATE. 

Updated: 2/12/2009