Appointment Termination File Upload Format

eAppoint requires that uploaded documents containing appointment terminations 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,TERMINATION_REASON_CD,TERMINATION_DT,STATE_OR_COUNTY_CD,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.

TERMINATION_REASON_CD

The reason for the appointment termination.

Required field that is indicated by one of the following codes:

“AVFS” =  ALLEGED VIOLATION OF FLORIDA STATUTES

“D” = DECEASED

“MOFL” =  MOVED OUT OF FLORIDA

“NLRC” = NO LONGER REPRESENTS THE COMPANY

TERMINATION_DT

The appointment termination date.

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

STATE_OR_COUNTY_CD

This field indicates whether the appointment is a state or county appointment.

Required field that is indicated by one of the following codes:

”S” = State

”C” = County

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 terminating all county appointments.

After the file header, you will need to provide specific details for each appointment termination. A dataset for each appointment termination must be created by specifying each appointment termination 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 termination 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 termination data sets separated by a line break:

A123456,111223333,0220,MOFL,01/01/2003,C,01
A333333,222334444,0220,NLRC,01/01/2003,S,

Please remember that terminating a Licensee's .State Appointment for an Appointing Entity will also cancel any associated County Appointments.