Edit Software

NISS provides multiple tools to help our member companies prepare and analyze their data.  Currently, the edit software is available for use with the following lines:  

Automobile Edit Software
The NISS Auto Edit Software is a resource designed to allow member companies to edit their submissions at the desktop level and to view a separate distribution of their data, prior to submission to NISS. This software has been developed as an Access database, and is delivered in Microsoft® Access 2000 format. It is currently available for the 2017 Automobile Call. The most recent version of the software, as well as documentation, can be downloaded below.

View 2017 Automobile Edit Software Documentation
Download 2017 Automobile Edit Software (v2017.31
) & Documentation (Zip File)

Homeowners Edit Software
The NISS Homeowners Edit Software is another resource similarly designed to allow member companies to edit their submissions at the desktop level and to view a separate distribution of their data, prior to submission to NISS. As with the Auto edit software, this software is delivered in Microsoft® Access 2000 format. It is currently available for the 2017 Homeowners Call. The software, as well as documentation, can be downloaded below.

View 2017 Homeowners Edit Software Documentation
Download 2017 Homeowners Edit Software (v2017.12
) & Documentation (Zip File)

North Carolina Quarterly Automobile (AQR) Edit Software
The NISS North Carolina Quarterly Automobile (AQR) Edit Software function is similar to the Auto and Homeowners edit software packages, allowing member companies to edit quarterly submissions at the desktop level and to view a separate distribution of their data, prior to submission to NISS. It is currently available for the 2017 quarterly Calls.  The current software, as well as documentation, can be downloaded below.

View 2017 AQR Edit Software Documentation 
Download 2017 AQR Edit Software (v2017.2) & Documentation (Zip File)

Quarterly Automobile Insurance Plan (ARP) Edit Software
The NISS Quarterly Automobile Insurance Plan (ARP) Edit Software functions like the other edit software packages, allowing member companies to edit quarterly ARP submissions.  A wide array of reports are available to help identify any coding issues as well as to examine the data from a reasonableness standpoint.  The software, along with its documentation, can be downloaded below.

View 2017 ARP Edit Software Documentation
Download 2017 ARP Edit Software (v2017.12) & Documentation (Zip File)

Commercial Lines Statistical Plan (CLSP) Edit Software
The NISS Commercial Lines (CLSP) Edit Software functions like the other edit software packages.  It allows member companies to edit their CLSP submissions.You have the opportunity to run reports by module and efficiencies are built in to process only the modules included in your data.  As with the other lines, a wide array of reports are available to help identify any coding issues as well as to examine the data from a reasonableness standpoint.  The software, as well as documentation, can be downloaded below.

View 2017 CLSP Edit Software Documentation
Download 2017 CLSP Edit Software (v2017.3) & Documentation (Zip File)

General Liability (GL) Edit Software
The NISS General Liability Edit Software also functions like the other edit software packages. It includes edits General Liability, Personal Liability and Medical Professional Liability experience submitted in the General Liability Call.  As with the other lines, a wide array of reports are available to help identify any coding issues as well as to examine the data from a reasonableness standpoint. The software, as well as documentation, can be downloaded below.

View 2017 GL Edit Software Documentation
Download 2017 GL Edit Software (v2017.12) & Documentation (Zip File)

Lines Other Than Auto Edit Software 
The Lines Other Than Auto packages which encompass Burglary & Theft, Farmowners, Fidelity, Surety & Forgery and Inland Marine Calls.  An edit software package is available for each of these lines separately.  However, because there are similarities among the lines where the edit software is concerned, a single documentation file covers all 4 lines and can be downloaded immediately below.

As with the other lines the edit software includes the capability to run a variety of reports to help identify any coding or reasonableness issues.

View 2017 Lines Other Than Auto Edit Software Documentation

Download 2017 Burglary & Theft Edit Software (v2017.1) (Zip File)
Download 2017 Farmowners Edit Software (v2017.1) (Zip File)
Download 2017 Fidelity & Surety Edit Software (v2017.1) (Zip File)
Download 2017 Inland Marine Edit Software (v2017.11) (Zip File)

Each software package may be updated periodically for edit table changes and such.  The current version number available for download is listed.

Edit Tables

NISS provides multiple tools to help our member companies prepare and analyze their data.

Edit Tables are another one of the tools a company can use to promote data quality. Documentation is provided for each of the Edit Tables, outlining the record layout and specifications.

NISS Edit Tables can be used to validate certain data elements prior to submission of the NISS Calls. If the Tables are used early enough in the company's processing system, data errors can be detected and corrected at the source.  The tables and related documentation for the 2017 Call Year can be found below. 

AQR
North Carolina Quarterly Automobile Call

View Documentation
View sample AQR Edit Table
Download Current AQR Edit Tables


ARP
Quarterly Assigned Risk Automobile Call

View Documentation
View sample ARP Edit Table
Download Current ARP Edit Tables

AUTO
Annual Voluntary Automobile Call

View Documentation
View sample AUTO Edit Table
Download Current AUTO Edit Tables

CLSP
Annual Commercial Lines Call

View Documentation
View sample CLSP Edit Table
Download Current CLSP Edit Tables

HO
Annual Homeowners Call (includes Dwelling Policies)

View Documentation
View sample HO Edit Table
Download Current HO Edit Tables

Helpful Data Reporting Tips

NISS provides multiple tools to help our member companies prepare and analyze their data.  Another tool is our "Helpful Data Reporting Tips" document that lists items to watch out for when preparing any Data Call. 

In particular, it addresses common issues regarding premiums and losses reported as well as claim counts and exposures, where applicable.  Additionally, tips are provided regarding the reporting of excess losses for General Liability, Medical Professional Liability and the various Auto Calls (Voluntary Auto, North Carolina Auto and Assigned Risk).  Finally, some useful tips are listed for the Auto and Homeowners Calls specifically.

    
    Click here to view a printer friendly version of the Helpful Data Reporting Tips.

 

Territory Listings By ZIP Code

NISS provides multiple tools to help our member companies prepare and analyze their data.

These listings provide valid Territory Code assignments for each ZIP code recognized as effective by the United States Postal Service for statistical reporting purposes.  Specifically, the Automobile Statistical Plan listings provide the State code (and 2-digit State abbreviation), ZIP Code, Territory code, whether the territory code applies to Private Passenger or Commercial risks or both, County, City, Effective Date and Obsolete Date of the ZIP Code.  The Homeowners Statistical Plan and Fire and Allied Lines module from the Commercial Lines Statistical Plan do not include the Private Passenger versus Commercial distinctions. 

Note that the dates are in "yyyymmdd" format; a date of '99999999' indicates the ZIP Code is still in effect. NISS utilizes ZIP Codes and related territories for obsolete dates back 5 full calendar years for losses.  However, exceptions to the 5-year rule are New York Automobile and all Assigned Risk losses, for which 7 full calendar years are used.  In all cases, however, ZIP Codes that are obsolete prior to the calendar year premiums reported in a Call Year are not considered valid. 

You can view these numerical listings of territory codes in pdf format, or download the Excel files for the added capability to sort and filter by the various columns.  The Automobile codes for Voluntary, Assigned Risks and North Carolina Quarterly are broken into separate files.  Due to the file size, we have made the files available in a compressed format. We suggest you download the .zip files to your computer and view the information there, rather than opening the file directly in your browser. Opening it from our web site may take some time, due to the file size.

Please note: the North Carolina Quarterly Automobile files include the most recent Private Passenger Auto territories effective 10/1/2015 for use with 4th quarter premiums and going forward.  Please reference previous lists for the old territories to be used with loss experience prior to 10/1/2015. 

Automobile Statistical Plans (All States) 

View ZIP Codes (pdf)

Download
ZIP Codes (xls)

Download
ZIP Codes (zip)

Voluntary Automobile 1217.pdf

Voluntary Automobile 1217.xls Voluntary Automobile 1217.zip
Assigned Risk Automobile 1217.pdf Assigned Risk Automobile 1217.xls Assigned Risk Automobile 1217.zip
North Carolina Quarterly Automobile 1217.pdf North Carolina Quarterly Automobile 1217.xls North Carolina Quarterly Automobile 1217.zip

Homeowners Statistical Plan 

View Zip Codes (pdf)

Download
ZIP Codes (xls)

Download
ZIP Codes (zip)

Homeowners, Mobilehome & Dwelling 1217.pdf Homeowners, Mobilehome & Dwelling 1217.xls Homeowners, Mobilehome & Dwelling 1217.zip

Fire and Allied Lines (Commercial Lines Module)

View Zip Codes (pdf)

Download
ZIP Codes (xls)

Download
ZIP Codes (zip)

Fire & Allied Lines 1217.pdf Fire & Allied Lines 1217.xls Fire & Allied Lines 1217.zip

Please Note: The Zip/Territory listings are updated every 2 months, in conjunction with updates received from the United States Postal Service (USPS). File names include a month and year to represent the most current update. For instance, the file name "Homeowners, Mobilehome & Dwelling 1217.xls" indicates the USPS updated the file in December, 2017.

Also please note that if NISS announces regulatory changes to territories, you will want to be sure to use your old territory codes on losses occurring prior to any changes.  However, these ZIP/territory lists will only contain the most current codes.