Diskette Specifications

The data you submit is combined in a database that allows employers to find companies with the lowest rates for their class code.  The diskette is the easiest way to get the information to us for processing.  Follow these instructions;  it will be easier than you thought!  

A few tips to remember as you create your diskette:

• Label your diskette.  Include your NAIC number, company name, date, and a contact person (with a phone number). 
• Fill out the Diskette Submission Authorization Form.   Make sure you scan the diskette for viruses, and verify that all the information is correct.  Filing erroneous data within a diskette or filing a diskette with a virus is prohibited and shall be deemed filing materially false report or statement under Section 374.215.2, RSMo.
• Make sure you only have two files on your diskette.  They must be named CLASS.TXT and CMPYINFO.TXT.
• It is ok to combine multiple companies on the same diskette.   Just start the next company's information on the next available line after the first company.

CLASS.TXT

This file has four items in it, neatly arranged in columns. 

NAIC:

This is your NAIC-assigned group and company number. The first four digits are your group code and the last five your specific company code. There are no special characters for this field.

CLASS:

This must be a valid NCCI class code. The first field must not be blank. The field must be right-justified.

RATE:

This is your rate for the class code. Your entry must be numeric and contain two (2) decimal places. The decimal point must be included in the field. Any zero entry must be "0.00".

AIND:

This indicates that a class code rate is not established, but is set by the company. The only valid value for this field is "A" to indicate that this class is "a-rated", otherwise the field must be blank. If the class is "a-rated", the RATE field must be zero (0.00).

The Easy Way:

• Open your spreadsheet program and create a new spreadsheet.
• Put your NAIC number in the first column.  Make sure to label it as "text" and not as a number.
• Put your class codes in the second column.  Label these as "text", too, and align it on the right.
• Put your rate in the third column.  These should be labeled as numbers, not text, and have two decimal places.
• If any of the classes are "A-rated", put an "A" in the fourth column.
• Save the spreadsheet as a ".prn" file.  Name the file "class.txt" (be sure to use the quote marks if you  are using Windows 95, Windows 98, or Windows NT).  You are done.

If you look at the file in a text editor, it should look something like this::

---------+---------+---------+
012345678  0005  5.41
012345678  0008  4.20
012345678  7151  0.00A

CMPYINFO.TXT

This file is actually a lot simpler than the other one.  For one thing, it is only one line long.  

Delimiters:

These must be commas (,) inserted at the indicated column.

NAIC Number:

This is your NAIC-assigned group and company number. The first four digits are the group code and the last five are your specific company code. You must enter nine numerals in this field. If you have no group code, the first four digits are "0000".

Company Name:

The name of the specific company filing rate class codes.

Contact Name:

Person to be contacted regarding inquiries from employers about obtaining insurance.

Address:

Use the second address field for box numbers or other address information.

Phone:

Contact person's phone number, including area code and extensions.

Schedule Rating:

Is scheduled rating available? Valid entries are "Y" and "N".

Underwriting Threshold:

This the smallest policy your company would normally consider writing. The default value is $1,000.

Underwriting Guidelines:

Optional field. You may enter any general underwriting rules or restrictions you wish any potential inquirers to know.

You may use any valid alphanumeric characters, but NO special characters or punctuation in these fields.

The Easy Way:

• Open up that spreadsheet again. 
• Fill out each field in a separate cell in Row 1. 
• Save the spreadsheet as a ".csv" file in Excel or as ".txt" if you don't have ".csv" as an option.  Name the file "cmpyinfo.txt" (be sure to use the quote marks if you  are using Windows 95, Windows 98, or Windows NT).  You are done.

If you look at the file in a text editor, it should look something like this::

---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--
012345678,A-OK Insurance Company ,John Smith , 123 Main St,PO Box 1234, St Louis, MO,63101,(314)555-1212 ,y,2500,Retail Stores only

Note: Your fields can be shorter that the field lengths listed below, as long as your fields are separated by a comma. There should be no commas anywhere in the fields.