RETS Naming Conventions 

 

 

 

 

The “RETS Field Mapping” document referenced in this document is available at www.ntreis.net  under “Technical Support / NTREIS RETS”.

11.a)  Names in RETS

The RETS Metadata is based on the SQL Tables that underlie the Tempo MLS Database and the names used in RETS can be tied back to the fields in the Tempo SQL Tables.

 

A field in RETS has 5 different names.  See the “RETS Field Mapping” document for examples of the names.  This document is available at www.ntreis.net  under “Technical Support / NTREIS RETS”.

LongName

This is the most user friendly name.

ShortName

These names can be somewhat cryptic.

StandardName

Many fields lack a standard name.

SystemName

These names very closely tie into the actual schema name on the MLS Tables. 

DBName

Even more cryptic than the ShortName.

It is your choice as to the name you work with in RETS, but you will find the long name in most cases is the easiest to work with, especially with the MarketLinx RETS Connector client. 

Many fields in the NTREIS RETS implementation do not have a StandardName.

 

Depending on your application, the SystemName may be best for you to use.  However, some of the System Names are not clear as to their meaning or how they are used.  To assist with this, NTREIS is providing a list of fields on the “IDXData” and “nonIDX” worksheets on the “RETS Field Mapping” document that contains this information:

Metadata_Class

RETS Metadata Class

SystemName

These names very closely tie into the actual schema name on the MLS Tables. 

StandardName

Many fields lack a standard name.

LongName

This is the most user friendly name.

DBName

Even more cryptic than the ShortName.

The DBName is based on internal processes used by the MLS Vendor and is subject to frequent changes.  It should not be used in any capacity.

The MLS Vendor recommends using the SystemName as it is the only reliable name to use for tracking system changes. It is unique and does not ever change 

ShortName

These names can be somewhat cryptic.

TempoTable

The Tempo Table that contains this field.

Tempo Schema Name

The name of the field in the Tempo Table.

InputLabel

The label for this field on the Input Screen when adding a listing

FieldType

This does not exist in either the RETS Metadata or the TEMPO MLS Tables.  It was provided by NTREIS to help our RETS users identify the type of field.  See the “Field Type” discussion below.

Definition

This is the informal definition/description of the field. 

Comments

Used as necessary to clarify information about the field.

If you are new to the NTREIS MLS System, you may find it useful to look at the Listing Input Sheets to see the fields and the data that can be entered.  You can find the Listing Input Sheets at http://www.ntreis.net/resources/forms.asp under “Forms Available for Download”.  This is a very easy way to view the different values that can be entered in into certain fields.

11.b) Field Types on “RETS Field Mapping” document

While the MLS SQL Data Schema formally defines each field and this is reflected in the RETS metadata, NTREIS Staff uses an informal field type on the “RETS Field Mapping” document that is often useful in understanding the data that can be entered in a field.  It can be a handy quick reference guide as you are getting started with NTREIS and RETS:

Field Type

Description

Field

This type is used for fields such as streetname, mappage, listprice, etc and almost any information, within the limits of the schema, can be entered in these fields.

 

Feature

This can contain a list of data with multiple entries.  An example is the ‘Kitchen Equipment’ feature group whose entries could include microwave, wine cooler, ice maker, gas cooktop, + others. 

 

FieldLargeText

This type includes ‘Property Description’, ‘Driving Directions’, ‘Interoffice Remark’s and usually identifies fields that are larger than 30 characters.

 

Table

These fields are table driven.  An example would be ‘Property Type’, which the user is limited to choosing RES, MUL, COM, LND, or LSE.

 

TableYN

These are fields that accept either no value or ‘Y’ or ‘N’. 

 

Again the field type is not to be found in the SQL Schema or Metadata.  It is a field used only on the “RETS Field Mapping” document.

 

 

 

Updated: 9/15/2010