• Label your diskette.  Include your NAIC number, company name and contact person (with a phone number).
  • Fill out the Appendix B form, include with diskette.
  • Make sure to scan the diskette for viruses. 
  • Multiple companies can be submitted on the same diskette.
  • Any negative values should have the negative sign before the value.
  • NAIC Group Number:  This is your NAIC - assigned group number.  If you have no group code, the first four digits are "0000".
  • NAIC Company Number:  This is your NAIC - assigned company number. 
  • Year:  Four-digit year being reported.
  • Zip Code:  Garaging Location - Property Location
    Review DIFP's list of valid zip codes.
  • Policy Type:  Refer to Missouri Regulation 20 CSR 600-3.100, Table A - Policy Type Code
  • Exposure/Loss Type:  Refer to Missouri Regulation 20 CSR 600-3.100, Table B - Exposure or Loss Type Code.
  • Data Type (Upper Case):
    • AE = Automobile Exposure
    • AL = Automobile Losses
    • PE = Homeowners/Dwelling Fire Exposures
    • PL = Homeowners/Dwelling Fire Losses
    • ME = Mobilehome Exposure
    • ML = Mobilehome Losses
    • FE = Farmowners Exposure
    • FL = Farmowners Losses
    • EE = Earthquake Exposures
    • EL = Earthquake Losses
Data fields for zipcode data
Field Name Columns Field Length Field Type
NAIC Group Code 1-4 4 Numeric
NAIC Company Code 5-9 5 Numeric
Year 10-13 4 Numeric
Zip Code 14-18 5 Numeric
Policy Type 19 1 Alpha
Exposure/Loss Type 20 1 Numeric
RANGE 1 - Exposure/Loss Count 21-29 9 Numeric
RANGE 1 - Written Premium/Loss Amount 30-38 9 Numeric
RANGE 2 - Exposure/Loss Count 39-47 9 Numeric
RANGE 2 - Written Premium/Loss Amount 48-56 9 Numeric
RANGE 3 - Exposure/Loss Count 57-65 9 Numeric
RANGE 3 - Written Premium/Loss Amount 66-74 9 Numeric
RANGE 4 - Exposure/Loss Count 75-83 9 Numeric
RANGE 4 - Written Premium/Loss Amount 84-92 9 Numeric
RANGE 5 - Exposure/Loss Count 93-101 9 Numeric
RANGE 5 - Written Premium/Loss Amount 102-110 9 Numeric
Data Type 111-112 2 Alpha

Sample records:

         10        20        30        40        50        60        70        80        90        100       110
---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--
000011111200465101A1        0        0      999    99999        0        0        0        0      999    99999AE
000011111200465101A1      999    99999      -99    -9999        0        0        0        0      999    99999AL