[Skip all navigation]

Missouri State Government | DIFP Home | Insurance Home | Search | Site Map | Jobs | Help | Contact us
DIFP logo Matt Blunt, Governor
Linda Bohrer, Acting Director

 

Insurance Home » Industry » Filings » Statistics

Text Specifications for reporting Zip Code data
per Regulation 20 CSR 600-3.100

  1. Label your diskette.  Include your NAIC number, company name and contact person (with a phone number).
  2. Fill out the Appendix B form, include with diskette.
  3. Make sure to scan the diskette for viruses. 
  4. Multiple companies can be submitted on the same diskette.
  5. Any negative values should have the negative sign before the value.

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 Count 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