New Appointments File Upload Format

eAppoint requires that uploaded documents containing new appointments follow a specific format. Be sure to save your document as a comma-delimited text file, as eAppoint will only accept and process comma-delimited text files. Your file is required to have a specific file header that identifies the data fields and their required order. The file header must be the following (on a single line):

LICENSE_NUM,SSN_FEIN,TYCL,SUPERVISOR_LICENSE_NUM,APPOINTMENT_DT,BUSINESS_LOCATION_COUNTY,APPOINTMENT_COUNTY

It may be easiest and most time efficient to cut and paste the above text into the first line of your document.

Definitions for each field are provided in the following table:

Field

Definition

Rules

LICENSE_NUM

The licensee’s Florida identification number.

Required field.

SSN_FEIN

The licensee’s FEIN or SSN.

Required field.

TYCL

The appointment TYCL.

Required field.

SUPERVISOR_LICENSE_NUM

The supervising licensee’s Florida identification number.

Only required for TYCLs that require a supervising licensee.

APPOINTMENT_DT

The appointment date.

Required field (must be in MM/DD/YYYY format).

BUSINESS_LOCATION_COUNTY

The Florida county location of the licensee’s business.

Required for residents.

APPOINTMENT_COUNTY

The county code if a county appointment.

If state appointment, leave blank. Required for county appointments. The word, ALL, may be used for the county code if the licensee is to be appointed in all of the Florida counties.

After the file header, you will need to provide specific details for each appointment. A dataset for each appointment must be created by specifying each appointment field in the proper order, separating each item by using a comma. A line break at the end of each dataset will separate one dataset from the next. If an appointment field is not required, you will still need to use the appropriate number of commas as a space holder. Below is an example of two appointment data sets separated by a line break:

A123456,111223333,0220,A223456,01/01/2003,,01
A333333,222334444,0220,A223456,01/01/2003,,01

If your file includes a state appointment and county appointment(s) for the same individual licensee and TYCL, then the state appointment dataset must precede the county appointment datasets.