Insurer Batch Filing Format v5.0
Note: The version 5.0 Insurer .slx format is only allowed for use until 12/14/2009, at which
point filers will be required to use the version 5.15 format.
See
version 5.15 here.
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.
Batch files may only be submitted to the FSLSO using the FTP Submit tool.
A sample Insurer FSLSO Export File (SLX) is also available.
DIFFERENCES FROM VERSION 3.0
The changes from the v3.0 to v5.0 .slx Insurer format are:
- Insurance Company NAIC is required
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.
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 5.0 |
5.0 |
| 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 |
| NAIC |
The Insurer's NAIC number |
5 digits or 9 characters |
| FEIN |
The Insurer's FEIN |
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)
The preferred Entity by the FSLSO is the [Agent]. If no [Agent] is
available the [Agency] is the next desired Entity, followed by [Broker].
There must be either an [Agent], [Agency] 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 Entity section must be the fourth section in the file.
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
[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
[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
[Agent] 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 |