|
eAppoint requires that uploaded documents containing new and/or termination 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):
ACTION_TYPE,AE_NUM,LICENSE_NUM,SSN_FEIN,TYCL,SUPERVISOR_LICENSE_NUM,EFFECTIVE_DT,BUSINESS_LOCATION_COUNTY,APPOINTMENT_COUNTY,TERMINATION_REASON_CD,STATE_OR_COUNTY_CD
|
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
|
Required/Optional For
|
Rules
|
|
ACTION_TYPE
|
This field indicates whether the
row is a new or termination.
|
Required field for both Action Types (New and Termination Appointments)..
|
Indicate thee type of action that you intent to do with the appointment on the
specific row, thus:
"N" = New or Reinstate Appointment.
"T" = Termination Appointment.
|
|
AE_NUM
|
The Appointing Entity Number.
|
Required field for both Action Types (New and Termination Appointments)..
|
Required field.
|
|
LICENSE_NUM
|
The licensee’s Florida identification number.
|
Required field for both Action Types (New and Termination Appointments).
|
Required field.
|
|
SSN_FEIN
|
The last five digits of the licensee’s FEIN or SSN.
|
Required field for both Action Types (New and Termination Appointments).
|
Required field.
|
|
TYCL
|
The appointment TYCL.
|
Required field for both Action Types (New and Termination Appointment).
|
Required field.
|
|
SUPERVISOR_LICENSE_NUM
|
The supervising licensee’s Florida identification number.
|
Required field for New Appointments.
|
Only required for TYCLs that require a supervising licensee.
|
|
EFFECTIVE_DT
|
The appointment or termination effective date.
|
Required field for botn Action Types (New and Termination Appointments).
|
Must be in MM/DD/YYYY format.
|
|
BUSINESS_LOCATION_COUNTY
|
The Florida county location of the licensee’s business.
|
Optional field for New Appointments.
|
Required for residents.
|
|
APPOINTMENT_COUNTY
|
The county code if a county appointment.
|
Optional field for
both (New and Termination Appointments).
|
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 OR Terminated in all of the
Florida counties.
|
|
TERMINATION_REASON_CD
|
The reason for the appointment termination.
|
Required field for Termination Appointments.
|
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
|
|
STATE_OR_COUNTY_CD
|
This field indicates whether the appointment is a state or county appointment.
|
Required field for Termination Appointments.
|
This field is indicated by one of the following codes:
”S” = State
”C
” = County
|
After the file header, you will need to provide specific details for each appointment or termination.
A dataset for each appointment or termination 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 or 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 and three terminations data sets separated by a
line break:
N,1111,A123456,23333,0220,,01/01/2003,01,,,
T,3333,A777777,29999,0214,,01/01/2003,01,,MOFL,S
T,1111,A555555,23333,0214,,01/01/2003,01,,MOFL,S
N,2222,A333333,34444,0920,,01/01/2003,,01,,
T,4444,A989898,35444,0814,,01/01/2003,,01,NLRC,C
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.
Please remember that terminating a Licensee's State Appointment for an Appointing Entity will also cancel any associated County Appointments.
|
