Text Specifications for Reporting Zip Code Data

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