Status
          A=Active
          I=Inactive

Type
            C=Company
            B=Branch
            Q=Qualifying Broker
            A=Associate Broker
            S=Salesperson
            T=Temporary Salesperson
            Y=CE Instructor
            Z=Prelicense/Postlicense Instructor

Type for Exam List
            B=Broker
            S=Salesperson

Instructions

1. Download your list to your choice of directory.

2. After you have successfully downloaded,  you should set up your database, spreadsheet or document.

3. After setting up your database, spreadsheet or document, you must import the text file (*.txt) into it. Most imports utilize an import Wizard that will guide you through this process. The key information for this import process is that the file is comma delimited.

4. Read below to obtain information about the field types contained in each list.

Company / Personnel List
This is an ASCII text file that is comma delimited. The fields included are as follows:

• County Number

• Company License Number

• License Number

• Type

• Company Name

• Company Extra Name

• Last Name

• First Name

• Address

• City

• State

• Zip

• Company Phone

• Email

 Licensee List  Active, Inactive, or Both
This is an ASCII text file that is comma delimited. The fields included are as follows:

• County Number

• Status

• Type

• License Number

• License Number Extension

• Last Name

• First Name

• Name Suffix

• Address

• City

• State

• Zip

• Email

Exam List
This is an ASCII text file that is comma delimited. The fields included are as follows:

• Test Date

• First Name

• Last Name

• Address

• City

• State

• Zip

• Email

• Type

• Result

Approved School List
This is an ASCII text file that is comma delimited. The fields included are as follows:

• County Number

• License Number

• School Name

• School Extra Name

• Address

• City

• State

• Zip

• Phone

• Email

Approved Instructor List
This is an ASCII text file that is comma delimited. The fields included are as follows:

• County Number

• Status

• Type

• License Number

• License Number Extension

• Last Name

• First Name

• Name Suffix

• Address

• City

• State

• Zip

• Email