Insurance Home » Industry » Filings » Statistics
Text Specifications for reporting Zip Code data
per Regulation 20 CSR 600-3.100
- 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 MDI's website for the list of valid zip codes. - Policy Type: Refer to Missouri Regulation 20 CSR 600-3.100, Table A – Policy Type Code. Copy available on MDI's website at http://www.insurance.mo.gov/industry/filings/stats/statreprt.htm
- 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
| 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
