EDI 262 Real Estate Information Report

Functional Group ME

X12F Finance Subcommittee

This Draft Standard for Trial Use contains the format and establishes the data contents of the Real Estate Information Report Transaction Set (262) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set can be used for the transfer and reporting of real estate information among real estate industry participants.

Heading

1. 010 · ST · Transaction Set Header · Max 1 · Mandatory

   To indicate the start of a transaction set and to assign a control number

2. 020 · BGN · Beginning Segment · Max 1 · Mandatory

   To indicate the beginning of a transaction set

3. 025 · TRN · Trace · Max 1 · Optional

   To uniquely identify a transaction to an application

4. 1000 Loop Optional Repeat 5

   1. 030 · NM1 · Individual or Organizational Name · Max 1 · Mandatory

      To supply the full name of an individual or organizational entity

      The NM1 Loop is used to identify the real estate information provider, recipient, and bill-to information.

   2. 040 · N2 · Additional Name Information · Max 1 · Optional

      To specify additional names or those longer than 35 characters in length

   3. 050 · N3 · Address Information · Max 2 · Optional

      To specify the location of the named party

   4. 060 · N4 · Geographic Location · Max 1 · Optional

      To specify the geographic place of the named party

   5. 070 · PER · Administrative Communications Contact · Max 1 · Optional

      To identify a person or office to whom administrative communications should be directed

   6. 080 · REF · Reference Identification · Max >1 · Optional

      To specify identifying information

      The REF records the real estate information provider's ID and other reference information such as geographic coordinates.

Detail

1. 2000 Loop Mandatory Repeat >1

   1. 010 · LX · Assigned Number · Max 1 · Mandatory

      To reference a line number in a transaction set

      Each iteration of the LX loop is used to provide real estate information for the subject property.

   2. 015 · AM1 · Informational Values · Max >1 · Optional

      To specify a code and the amount or quantity or percentage associated with it

      The AM1 segment records the real estate information service type and report type.

   3. 016 · PWK · Paperwork · Max 5 · Optional

      To identify the type or transmission or both of paperwork or supporting information

      The PWK segment records the real estate information type and form information.

   4. 017 · SPI · Specification Identifier · Max >1 · Optional

      To provide a description of the included specification or technical data items

      The SPI identifies and provides category information for any associated binary files such as property photographs, plat maps and floor plans.

   5. 018 · CUR · Currency · Max 1 · Optional

      To specify the currency (dollars, pounds, francs, etc.) used in a transaction

      The CUR identifies the country currency used in the transaction. If the segment is not present then the default currency is U.S. Dollars.

   6. 2100 Loop Mandatory Repeat >1

      1. 028 · NX1 · Property or Entity Identification · Max 1 · Mandatory

         To define the attributes of a property or an entity

         The NX1 Loop identifies the property address of the subject property and comparable property sales comparison information.

      2. 030 · NX2 · Location ID Component · Max >1 · Mandatory

         To define types and values of a geographic location

      3. 050 · PDS · Property Description/Legal Description · Max >1 · Optional

         To provide specifics on property or legal description; this segment provides for a simple legal description such as lot, block and subdivision

         The PDS records legal property identifiers and data sources.

      4. 060 · PDE · Property Metes and Bounds Description · Max >1 · Optional

         To describe real estate property by boundary lines with their terminal points and angles; this segment defines legal boundaries of real estate property

      5. 065 · REA · Real Estate Property Information · Max 1 · Optional

         To provide a description of real estate or general property information

      6. 070 · QTY · Quantity · Max 25 · Optional

         To specify quantity information

         The QTY segment records the number of units, and amount of improvements finished above grade.

      7. 080 · REF · Reference Identification · Max 30 · Optional

         To specify identifying information

         The REF segment identifies the mortgage loan number, file number, Federal Housing Administration or Veterans Administration case number, map reference number, geographic coordinates, census tract, and site Federal Emergency Management Administration map information.

      8. 090 · DTP · Date or Time or Period · Max 6 · Optional

         To specify any or all of a date, a time, or a time period

         The DTP identifies the tax year for real estate taxes, map date, date of sale, reconciliation date, appraisal date and other real estate information dates.

      9. 100 · YNQ · Yes/No Question · Max 43 · Optional

         To identify and answer yes and no questions, including the date, time, and comments further qualifying the condition

         The YNQ segment indicates the occupancy, property rights, project type, sales or refinancing, neighborhood characteristics, project information for Planned Urban Developments, corner lot, zoning compliance, best use, Federal Emergency Management Administration special flood hazard area, reconciliation appraisal basis information.

      10. 105 · CRC · Conditions Indicator · Max 10 · Optional

          To supply information on conditions

      11. 110 · AMT · Monetary Amount · Max 10 · Optional

          To indicate the total monetary amount

          The AMT segment records loan charges and concessions, reconciliation of appraised value, indicated value by sales comparison, indicated value by income, and other real estate amount information.

      12. 120 · PCT · Percent Amounts · Max 8 · Optional

          To qualify percent amounts and supply percent amounts

          The PCT segment records the neighborhood present land use percentage.

      13. 125 · REC · Real Estate Condition · Max 1 · Optional

          To indicate the condition of real estate property and, if applicable, the actions needed to correct damage

      14. 2110 Loop Optional Repeat >1

          1. 126 · MEA · Measurements · Max 1 · Mandatory

             To specify physical measurements or counts, including dimensions, tolerances, variances, and weights (See Figures Appendix for example of use of C001)

          2. 127 · API · Activity or Process Information · Max 1 · Optional

             To provide information on activity or process

          3. 128 · NTE · Note/Special Instruction · Max 4 · Optional

             To transmit information in a free-form format, if necessary, for comment or special instruction

      15. 2120 Loop Optional Repeat >1

          1. 130 · III · Information · Max 1 · Mandatory

             To report information

             The III Loop is used to identify neighborhood boundaries and characteristics, marketability, market condition information, and the property's attributes.

          2. 140 · MSG · Message Text · Max 10 · Optional

             To provide a free-form format that allows the transmission of text information

      16. 2130 Loop Optional Repeat >1

          1. 142 · PEX · Property or Housing Expense · Max 1 · Mandatory

             To provide housing expense information

             The PEX Loop identifies the ongoing and recurring property expenses, real estate taxes and special assessments.

          2. 144 · DTP · Date or Time or Period · Max 1 · Optional

             To specify any or all of a date, a time, or a time period

             The DTP records any dates associated with the property expense.

          3. 146 · III · Information · Max >1 · Optional

             To report information

             The III records items included or covered by the expense or fee.

      17. 2140 Loop Optional Repeat >1

          1. 150 · LQ · Industry Code · Max 1 · Mandatory

             Code to transmit standard industry codes

             The LQ Loop is used to identify the number, type and location of components within the subject property (e.g. lot, building, rooms, garage) including dimensions and attributes.

          2. 160 · REF · Reference Identification · Max 1 · Optional

             To specify identifying information

          3. 170 · QTY · Quantity · Max 10 · Optional

             To specify quantity information

          4. 175 · MEA · Measurements · Max 10 · Optional

             To specify physical measurements or counts, including dimensions, tolerances, variances, and weights (See Figures Appendix for example of use of C001)

          5. 180 · AMT · Monetary Amount · Max 7 · Optional

             To indicate the total monetary amount

          6. 190 · MSG · Message Text · Max 3 · Optional

             To provide a free-form format that allows the transmission of text information

          7. 195 · DTP · Date or Time or Period · Max 2 · Optional

             To specify any or all of a date, a time, or a time period

          8. 197 · AIN · Income · Max 4 · Optional

             To provide type and amount of income obtained

          9. 198 · III · Information · Max >1 · Optional

             To report information

             The III records specific attributes or features of a property area.

      18. 2150 Loop Optional Repeat >1

          1. 200 · RET · Real Estate Transaction · Max 1 · Mandatory

             Provides information related to current or historical real estate transactions such as multiple listings, sales and loans

             The RET Loop records both current and historical property transactions such as listings, sales and rentals. Each iteration of the RET Loop represents one real estate transaction.

          2. 210 · REF · Reference Identification · Max >1 · Optional

             To specify identifying information

             The REF records transaction identifiers such as Multiple Listing Service.

          3. 220 · DTP · Date or Time or Period · Max >1 · Optional

             To specify any or all of a date, a time, or a time period

             The DTP records the real estate transaction dates such as listing date, sales date, expiration date, status dates, closing date, open house date, tour date.

          4. 230 · PTF · Property Transaction Financials · Max >1 · Optional

             To provide the financial information related to a real estate transaction such as list price, sales price, rent, commissions, fees, sales taxes and closing costs

             The PTF records all financial information associated with the real estate transaction such as list price, sales price, rent, commissions, transfer fees and closing costs. This segment is not used for ongoing property expenses.

          5. 240 · QTY · Quantity · Max >1 · Optional

             To specify quantity information

             The QTY records transaction quantity information such as days on market and book quantities ordered.

          6. 250 · III · Information · Max >1 · Optional

             To report information

             The III records transaction terms, remarks or miscellaneous information.

          7. 2151 Loop Optional Repeat >1

             1. 260 · NM1 · Individual or Organizational Name · Max 1 · Mandatory

                To supply the full name of an individual or organizational entity

                The NM1 Loop records information about each transaction participant (agents, brokers, owners, etc.).

             2. 270 · N2 · Additional Name Information · Max 1 · Optional

                To specify additional names or those longer than 35 characters in length

             3. 280 · N3 · Address Information · Max 2 · Optional

                To specify the location of the named party

             4. 290 · N4 · Geographic Location · Max 1 · Optional

                To specify the geographic place of the named party

             5. 300 · PER · Administrative Communications Contact · Max 1 · Optional

                To identify a person or office to whom administrative communications should be directed

             6. 310 · REF · Reference Identification · Max >1 · Optional

                To specify identifying information

                The REF records the participant's ID and geographic coordinates.

          8. 2152 Loop Optional Repeat >1

             1. 320 · LN2 · Existing Real Estate Loan Specific Data · Max 1 · Mandatory

                To provide specific information about a real estate loan

                The LN2 Loop records specific loan information. Each loop is used for a different loan.

             2. 330 · AMT · Monetary Amount · Max >1 · Optional

                To indicate the total monetary amount

                The AMT specifies the loan amounts such as principal, balance and payments.

             3. 340 · DTP · Date or Time or Period · Max >1 · Optional

                To specify any or all of a date, a time, or a time period

                The DTP records the loan dates.

   7. 2200 Loop Optional Repeat >1

      1. 350 · IN1 · Individual Identification · Max 1 · Mandatory

         To provide identification of an individual or entity

         The IN1 Loop is used to identify lender or client, real estate information company, appraiser, supervisory appraiser information, local schools, fire districts, etc.

      2. 360 · IN2 · Individual Name Structure Components · Max 10 · Mandatory

         To sequence individual name components for maximum specificity

      3. 370 · N3 · Address Information · Max 2 · Optional

         To specify the location of the named party

      4. 380 · N4 · Geographic Location · Max 1 · Optional

         To specify the geographic place of the named party

      5. 390 · PER · Administrative Communications Contact · Max 1 · Optional

         To identify a person or office to whom administrative communications should be directed

      6. 400 · DTP · Date or Time or Period · Max 2 · Optional

         To specify any or all of a date, a time, or a time period

      7. 405 · REF · Reference Identification · Max >1 · Optional

         To specify identifying information

      8. 2210 Loop Optional Repeat 10

         1. 410 · YNQ · Yes/No Question · Max 1 · Mandatory

            To identify and answer yes and no questions, including the date, time, and comments further qualifying the condition

            The YNQ Loop is used to record certifications and changes made to the definition of market value, statement of limiting conditions, and appraiser certification.

         2. 420 · REF · Reference Identification · Max 1 · Mandatory

            To specify identifying information

         3. 430 · DTP · Date or Time or Period · Max 2 · Optional

            To specify any or all of a date, a time, or a time period

         4. 2211 Loop Optional Repeat 50

            1. 440 · III · Information · Max 1 · Mandatory

               To report information

            2. 450 · MSG · Message Text · Max 10 · Optional

               To provide a free-form format that allows the transmission of text information

2. 460 · SE · Transaction Set Trailer · Max 1 · Mandatory

   To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)