Importing policy data

Importing zone data

PolicyCenter supports bulk data import by using database staging tables for zone data only. PolicyCenter does not support staging table import of policies, accounts, or other business or administrative data. Use the standard Guidewire APIs to import non-zone data. Implement segmentation strategies to improve loading performance if necessary.

A staging table provides an intermediate data location between a comma-separated values (CSV) file and the operational zone table in the database. You set up the CSV file to contain the data columns that you need. Guidewire provides tools to load the CSV data into the staging table. You use other Guidewire tools to check the integrity and consistency of the data in the staging table. Correcting errors in the staging table data reduces operational down time caused by rolling back failed data imports. You complete the import process by loading the data into the operational tables. This final step uses bulk SQL Insert and Select statements that operate on the entire zone table to ensure high performance.

PolicyCenter uses zone data for the following features.

• Assignment by location
• Address auto-fill
• Setting regional holidays

Zone data information changes frequently. As population changes in an area, location boundaries change and new locations appear. You need to load updated zone data into PolicyCenter regularly.