Adding Fields to Specific Loss Cost Database

The specific loss cost database currently has two tables. The addresses database provides the address for each risk as well as some underwriting information including the key to the fire defense provide. Within the next few months we will be adding a zip code field to the database, followed by fields for the Latitude Longitude and altitude.

More Changes in the Public Protection Database

Currently we are cleaning up some of the entries in the database deleting some entries that we believe are no longer needed. In addition we are reviewing all the "see" reference to make sure that they are still correct and making the corrections when needed.

In an effort to use abbreviations in s consistent manner, some of the names will change as we apply a common style is the Name field.

Finally, in the order to avoid confusion between "Subscription" district in other state and fire defense providers in Idaho. We are changing our fire department type from "S" for subscription to "A" for Association. In Idaho those organizations who provide fire defense service but are not public entities must respond to all fire within established boundaries and meet all of the same minimum criteria used for tax supported entities.

These changes will appear only in the web searches by provider name. These mass changes w ill only appear with the publication of the next edition of the manual, and for those entities that are modified via Monthly Updates for the remainder of this year.

Specific Loss Cost Database PCode Field

This morning the production Specific Loss Cost Database has been updated by changing the data in the PCode field to represent the same data in the gradID field in the Public Protection Database.

Data in the GradID field that has less than three digits is represented in the PCODE by adding "0's" to the left of the digit to make the data three characters.

Example: 1 to 001
23 to 023

Database Projects

Bureau Staff is working on some incremental changes in two of our key databases. The first phase of this project is to change the one of the fields in the Specific Loss Cost Database.

This database has a field to identify the fire defense provider for each risk. The field is named "PCODE" and is a three character text. These codes are being changed to match the gradID code used in both the "Public Protection Classification Database" and the "Protection Class Calculator"

Although the Public Protection Classification Database GradID field is a numerical field the changes in the in the Specific Loss Cost Database will only be in the data.

Watch this space for news on other upcoming changes.