Export Format for Insurers
Note: the version 3.1 Insurer .slx format is not allowed for use until 1/1/2007, at which point is is required.
Files submitted using the version 3.1 format prior to 1/1/2007 will be rejected, and files submitted using the version 3.0 or earlier format
after 12/31/2006 will be rejected.
INTRODUCTION
This document is intended to describe the format for submissions to the
Florida Surplus Lines Service Office. This format is intended to be as flexible as
possible while still allowing for maximum data integrity.
A sample Insurer FSLSO Export File (SLX) is also available.
DIFFERENCES FROM VERSION 2.0
The changes from the v2.0 to v3.0 .slx Insurer format are:
- Surplus Lines Agents and Agencies must come from the lists of valid entities (see below)
- Email fields are now required in the [Insurer] and [Contact] sections
- Phone extension is available in the [Contact] section
- ONE of three entities may now be associated with each set of policies. These are Agency, Agent, or Broker
- Policy Effective Date AND Policy Expiration Date are now required in the [Policy] section
The changes from the v3.0 to v3.1 .slx Insurer format are:
- The addition of the required "License" field in any [Agency] sections
- Current version number of 3.1 MUST be listed in the [FSLSO] section.
ENTITY LINKS
GENERAL RULES
- The data is to be presented for import in a format which is similar to a Microsoft
Windows' INI file.
- This file must be an ASCII text file. Binary, EBCIDIC or other format files will be
rejected.
- This file may be given any Windows' 9x/NT compatible file name. This name must
end in '.SLX'.
- The submission file will be processed from top to bottom.
- Fields must be in the listed order within a section. Section headers are
distinguished by the use of brackets [ ].
- All field names must be followed by an equal sign (=). All characters between
the equal sign and the end-of-line character will be considered data.
- Data should NOT be in fixed-length format (right-justified).
- Optional Fields with no data should be removed completely. Do not put the
Field Name and equal sign followed immediately by a return.
- EOS (end of section) is indicated by the beginning of a new section or EOF
(end of file). If, at EOS, any data is invalid or any required data is missing,
the entire section will be considered invalid. An [Agency] section without at least
one [Policy] will be considered invalid. Likewise, a [Policy] section without at least
one [Transaction] section will also be considered invalid.
- All submission files generated not using the FSLSO Insurer Software
must be submitted via the FSLSO FTP Submit software. The submission file
may be sent to FSLSO using one of two methods:
- The submission file may be transferred to the FSLSO FTP site using the
FTP Submit Software tool.
- Using the FSLSO FTP Submit Software, the submission file may
be exported to a 3.5"HD (1.44MB) diskette, which has been formatted to be compatible with
the Windows' operating system. Each diskette must contain one and only one .zip file.
Please use unused, pre-formatted diskettes.
REJECTION OF A SUBMISSION
The submission will be rejected if...
- ...the [Contact] section is invalid. The entire submission will be rejected and
you may NOT be notified!
- ...the first section is not the [FSLSO] section.
- ...if [Agency], [Agent], [Broker], [Policy] or [Transaction] section appears before any of the following,
or there are more than one of any of the following:
- [FSLSO] section
- [Insurer] section
- [Contact] section
We will do our best to notify you of the rejection, based on
Contact information provided.
THE FSLSO SECTION
The [FSLSO] section must be the first in the export file. There may be only one
[FSLSO] section per file. It contains information which indicates how this file is to
be processed by the FSLSO data import system. It must contain the following fields:
| Field Name |
Description |
Value |
| Version |
The specification version to which this file complies; files complying to the
specifications outlined in this document should indicate a value of 3.10 |
3.10 |
| Type |
The type of data being submitted. For submissions of Surplus Lines Insurer transactions, this field must be the word Insurer |
Insurer |
| Quarter |
The quarter for which data is being submitted. Should be 1, 2, 3, 4, or A;
A is used by Alien companies submitting data for an entire year |
1 character |
| Year |
The 4-digit year for which data is being submitted |
4 digits |
No other fields are required for version 3.x compliance.
THE INSURER SECTION
The [Insurer] section must be the second section of the file. It contains the
following Insurer related fields:
| Field Name |
Description |
Data Length/Type |
| FEIN |
The Insurer's FEIN number. Alien companies should use their NAIC number |
9 characters |
| Name |
The name of the company |
75 characters |
| Address1 |
The company's mailing address |
50 characters |
| Address2* |
The company's mailing address |
50 characters |
| City |
The company's city |
20 characters |
| State |
The company's state or province |
30 characters |
| Country* |
The company's country (can be omitted if U.S.) |
30 characters |
| Zip |
The company's ZIP or Postal Code |
20 characters |
| Phone |
The company's phone number. Alien companies should include the country code |
15 digits |
| Fax |
The company's facsimile number. Alien companies should include the country code |
15 digits |
| Email |
A general email address for the insurer |
75 characters |
* Optional.
THE CONTACT SECTION
The [Contact] section lists information about the person who did or will do
the ACTUAL submission of this file. It must be the third section in the file.
It contains the following Contact related fields:
| Field Name |
Description |
Data Length/Type |
| First Name |
The contact's first name |
20 characters |
| MI* |
The contact's middle initial |
1 characters |
| Last Name |
The contact's last name |
20 characters |
| Suffix* |
The contact's name suffix (Jr., III, Ph.D., etc.) |
5 characters |
| Address1 |
The contact's mailing address |
50 characters |
| Address2* |
The contact's mailing address |
50 characters |
| City |
The contact's city |
20 characters |
| State |
The contact's state |
2 characters |
| Zip |
The contact's ZIP code |
5-9 digits |
| Phone |
The contact's phone number (including area code) |
10 digits |
| Ext* |
The contact's phone extension |
5 digits |
| Fax |
The contact's fax number (including area code) |
10 digits |
| Email |
The contact's email address |
75 characters
required |
* Optional.
THE ENTITY SECTION(S)
There must be either an [Agency], [Agent] or [Broker] section for each entity with whom the Insurer is
reporting Florida business. Each separate entity should be followed by all of the
[Policy] section(s) which apply to that entity. The first [Agency]/[Agent]/[Broker] section must be
the fourth section in the file.
If the
[Agency] section is used, it should contain the following fields:
| Field Name |
Description |
Data Length/Type |
| FEIN |
The agency's FEIN |
9 digits |
| License |
The agency's License |
7 characters |
| Name |
The name of the agency |
75 characters |
| Address1 |
The agency's mailing address |
50 characters |
| Address2* |
The agency's mailing address |
50 characters |
| City |
The agency's city |
20 characters |
| State |
The agency's state or province |
30 characters |
| Country* |
The agency's country (can be omitted if U.S.) |
30 character |
| Zip |
The agency's ZIP or Postal Code |
20 character |
| Fax* |
The agency's fax number (including area code) |
10 digits |
| Email* |
The agency's email address |
75 characters |
* Optional.
If the [Agent] section is used, it should contain the following fields:
| Field Name |
Description |
Data Length/Type |
| License |
The surplus lines agent's license number |
7 characters |
| First Name |
The first name of the surplus lines agent |
20 characters |
| Last Name |
The last name of the surplus lines agent |
20 characters |
| Suffix* |
The suffix (Jr., Sr., etc) of the surplus lines agent |
5 characters |
| Address1* |
The surplus lines agent's address1 |
50 characters |
| Address2* |
The surplus lines agent's address2 |
50 characters |
| City* |
The surplus lines agent's city |
20 characters |
| State* |
The surplus lines agent's state or province |
30 characters |
| Zip* |
The surplus lines agent's ZIP Code |
20 character |
| Mail Address1* |
The surplus lines agent's mailing address1 |
50 characters |
| Mail Address2* |
The surplus lines agent's mailing address1 |
50 characters |
| Mail Address City* |
The surplus lines agent's city |
20 characters |
| Mail Address State* |
The surplus lines agent's state or province |
30 characters |
| Mail Address Zip* |
The surplus lines agent's ZIP Code |
20 character |
| Phone* |
The surplus lines agent's phone number |
10 digits |
| Ext* |
The surplus lines agent's phone extension |
5 digits |
| Fax* |
The surplus lines agent's fax number (including area code) |
10 digits |
| Email* |
The surplus lines agent's email address |
75 characters |
* Optional.
If the [Broker] section is used, it should contain the following fields:
| Field Name |
Description |
Data Length/Type |
| Name |
The full name of broker |
75 characters |
| Phone |
The broker's phone number (including area code) |
10 digits |
| Ext* |
The broker's phone extension |
5 digits |
| Address1* |
The broker's address1 |
50 characters |
| Address2* |
The broker's mailing address |
50 characters |
| City* |
The broker's city |
20 characters |
| State* |
The broker's state |
30 characters |
| Zip* |
The broker's ZIP Code |
20 character |
| Fax* |
The broker's fax number (including area code) |
10 digits |
| Email |
The broker's email address |
75 characters |
* Optional.
THE POLICY SECTION(S)
There must be one or more
[Policy] section(s) for EACH policy being submitted.
[Policy] sections should follow the appropriate
[Agency] section. Each policy
section should have the following fields:
| Field Name |
Description |
Data Length/Type |
| Policy Number |
The policy number. |
50 characters |
| Effective Date |
The effective date of the policy |
MM/DD/YYYY |
| Expiration Date |
The expiration date of the policy |
MM/DD/YYYY |
| Company‡ |
The name of the insured (if it is a company). |
75 characters |
| First Name‡ |
The first name of the insured. |
20 characters |
| MI*‡ |
The middle initial of the insured. |
1 characters |
| Last Name‡ |
The last name of the insured. |
20 characters |
| Suffix*‡ |
The name suffix of the insured (Jr., III, Ph.D., etc.). |
5 characters |
* Optional.
‡ If the insured is a company, omit First Name, MI, Last Name and Suffix.
If the insured is an individual, omit Company.
THE TRANSACTION SECTION(S)
This section lists a single transaction for a given policy. There must be one
or more
[Transaction] section(s) following each Policy section.
Each Transaction
will be assumed to apply to the previously listed Policy. Each Transaction section
should contain the following fields:
| Field Name |
Description |
Data Length/Type |
| Effective Date |
The effective date of the transaction. |
MM/DD/YYYY |
| Premium |
The amount charged/returned to the insured. |
-999999999.99-999999999.99 |