Field Types 

 

 

 

 

While the MLS SQL Data Schema formally defines each field and this is reflected in the RETS metadata, NTREIS Staff has an informal field types 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 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 mainly by NTREIS Staff in working with the data. 

 

 

Updated: 2/19/2008