Back to Home

This page is for those people who would like to integrate with CCR.  

The mechanism is extremely simple and in-fact CCR is a fully self contained executable.  There are no API's to memorize or dll's to call.

Your app just needs to shell out to CCR with the following Command "drive:\CCR\CCR.exe parameter".  The parameter "parameter" is either a valid Qtno which was obtain through a prior quote process or the name of a text file that has been written to the Folder containing CCR.exe.  This text file can be any name but it must contain the following:

First name if applicable
Last name or corporate name
DBA
Mailing Address
City
Zip
Policy Xdate in the following format mm/dd/yyyy

These entries are in an ascii Text file and each field is delimited by a CR/LF pair.  

When you exit CCR all the data you ever wanted concerning the risk is found on the drive where the CCR save quotes are saved in the CCR folder "Drive:\ccr\quotes".  This folder will contain 50 files (actually 25 file pairs) .  The Data base architecture is pretty straight forward.

A Customer (ICU.dat) can have more than one policy

A policy (IPO.dat ALONG WITH IAA OR IBA OR IWA AND OR IUA) can have many

Locations (IAI OR IBI OR IWI) which can have more than one building structure (IAJ OR IBJ) or liability exposure (ICC OR IWC) 

The primary key of all the files (ICU) is Qtno (The quote number)  Each policy relates to a customer through the Custno field.

There are other files tied to your risk such as Garaging locations (IAG.dat) and of course a list of vehicles (IAU.dat), and Property options (IBO.dat)

Confused about the names - all files with an "IA" refer to Multi-peril policies, "IB" refers to BOP type policies, "IW" refers to Work Comp.  IUA refers to policy wide data on Garage and Auto coverages.

You may contact me for complete data dictionary.  At the present time the data files are stores as DBISAM version 3 files.  You can obtain a free copy of their dbsys utility to view the files from their website 

DO EDIT THE SAVED QUOTE FILES.  You may query the data files for your use.  The executable can be keyed by me to shut you out if you are not a good citizen.  Our mutual client would have the choice of either you or me at that point.

Other ISD's have used this API (if you want to call it that) quite successfully.  As you see, the grunt work is left to you.

One last thing, beyond what you normally expect to be string data, almost all of the data fields are represented as coverage amounts or if the amounts can only be certain defined amounts then, integer values into a lookup table, or Boolean.  The lookup table is lookup.dat and is located on the server drive if any or on the local drive at Drive:\ccr\rates.

The field names for the Lookup table are self explanatory and pretty much coincide to the name of the data field.

Back to Home

 

All products mentioned are registered trademarks or trademarks of their respective companies.
Copyright © 2006 John C. Bitzberger
Last modified: October 10, 2005