Jump to Submenu

Jump to Main Menu

Jump to Content






list request service faq

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.

 

Code Key

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

 

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