Editing Rates
From SchemeServe Wiki
There are 2 methods within SchemeServe that can be used for Rating your insurance Schemes.
All Rates are controled by the Question Names that you create in the Questions Editor when setting up your Scheme.
Rated Questions must be set up as Category "Calculation" so that rates can be applied - this also makes them appear on the Matrix page. If the item is a Sum Insured and not an Indemnity Limit the 'This is Coverage box' should be ticked.
"Standard Rating" with the Questions Editor
Standard rating is normally used when the Scheme has a simple rating structure with a single set rate applying to an item which does not vary depending on additional criteria.
To set the Rate in the Question, open the Questions Editor and then the Question Set for the Scheme. Locate the Question that you want to work on and click the Edit icon. On the Main tab you can set an initial default value, you may want to use this to suggest a value that should be selected.
To set the Rate click on the Rates tab, you can now enter either a Rate % which will be applied to the Sum Insured to calculate the premium or you can set an In Full amount to be applied.
All Rates that are set in either the Questions Editor or the Conditional Matrix can be altered in the individual Case Matrix after a quote is received - they are all only default values and can be modified as required.
"Special Rating" with the Conditional Matrix
There will of course be Schemes and individual Questions that require much more complex rating to be applied - in these cases the Rate is best left blank in the Question - SchemeServe incorporates an extremely powerful Conditional Rating Matrix which will enable you to create very complex rating tables and to create additional formulas which can calculate values and premiums based on the Answers to other Questions.
The Rating Table is created as a standard comma separated value file (.csv)and is then imported into the SchemeServe database. Please note that you will require a Matrix for each insurer on each scheme.
These may be identical if the same rating is applied for all insurers in which case the same file can be imported to each insurer. If they vary either slightly or significantly its normally easiest to take a copy of the base one and then make the necessary alterations to that rather than creating a whole new import file.
To import a Conditional Rating Matrix that you have created (these can only be imported by SchemeServe Administrators) click on the main Admin Tab and then Rates and Fees.
Select the Scheme and Insurer and then Browse for the file that you want to import. Once this has been located click on the Upload button to import the file.
If you want to check the file you have imported or the Matrix that currently applies click on the Download Conditional Matrix icon.
If you want to make alterations to the Matrix update the .csv file that is downloaded, Save the changes and then Upload the new version as detailed above - the new rating will be available immediately.
The two tables below show examples of the types of Conditions and Actions that can be used in the Conditional Matrix.
Each function that you wish to carry out will have a Condition to identify the type of of action that you wish to carry out and an Action to specify what you want to do with the result.
This will often be an 'Answer' or 'Cover' type entry where you want to find the values that have been given or selected from a Drop Down List to a given Question and then apply a Rate to that Answer
So, for example if you have a Question to determine a Public Liability Indemnity Limit required and you want to set different premiums for each, £2,000,000 limit £250 and £5,000,000 limit £500 the entry in the matrix would be structured as below;
The Condition - Cover:PublicLiabilityIndLimit in Column A Row 1 (where PublicLiabilityIndLimit is the Question Name)
Column A Rows 2 and 3 would be the Indemnity limits available 2000000,5000000
The Action - SetFee in Column B Row 1
Column B rows 2 and 3 would be the premiums to be applied 250 and 500
A Conditional Matrix may contain many rows and many columns, there will sometimes be two or more Actions arising from the same Condition where the result of the Question is used to set a number of rates or replies to other questions.
SchemeServe identifies the end of one Condition from another by a short line of hash markers, this can be any length so long as more than one but something like ########################## will be quite adequate.
Conditions Table
| Answer | Answer:QuestionName | Answer to a Question in the Question set |
| Cover | Cover:QuestionName | As 'Answer' but for Calculation Questions |
| Rate | Rate:QuestionName | Current Rate for the Question |
| Result | Result:QuestionName | Current Result for the Question - Cover x Rate / 100 |
| Formula | Formula:arithmetic with QuestionName placeholders | Enables detailed formulas to be written with standard spreadsheet functions e.g "Formula:[StockSI] + Contents + [SpecificContents] / 100". The returned value could then be checked in a table to set a Rate |
| RecordType | RecordType (no other parameters) | Determines record types First Premium, Adjustment or Renewal |
| CLR | CLR:YearsToGoBack | Calculate the Claims Loss Ratio for specified number previous years |
| YearDiff | YearDiff:QuestionA/QuestionB | Calculate the number of whole years between Date Question A and date Question B |
| MonthDiff | MonthDiff:QuestionA/QuestionB | Calculate the number of whole months between Date Question A and date Question B |
| DayDiff | DayDiff:QuestionA/QuestionB | Calculate the number of whole days between Date Question A and date Question B |
| BrokerPostcodeArea | BrokerPostcodeArea:File Lookup Name | Check the Broker Post Code in a specified File Look Up and return the Look Up value |
| ClientPostcodeArea | ClientPostcodeArea:File Lookup Name | Check the Broker Post Code in a specified File Look Up and return the Look Up value |
| AnswerPostcodeArea | AnswerPostcodeArea:QuestionName/Lookup Name | Check the Answer Post Code from a Question in a specified File Look Up and return the Look Up Value |
| AnswerLookup | AnswerLookup:QuestionName/Lookup Name | Check the Answer from a Question in a specified File Look Up and return the Look Up Value |
| TableRowCount | TableRowCount:QuestionName | Adds up the number of rows in the table question |
| TableRowLookup | TableRowLookup:QuestionName/Column Index/Lookup Name | For all values in a specified table column check the specified File Look Up and return the Look Up Value |
Actions Table
| SetFee | SetFee:QuestionName DATA=Amount | Set a fixed charge on the specified Calculation question |
| SetRate | Setrate:QuestionName | Set a Rate on the specified Calculation Question |
| SetCover | SetCover:QuestionName DATA=Amount | Set the cover on the specified Calculation Question |
| IncludeEndorsement | IncludeEndorsement DATA=CSV Identifier | Include the specified Endorsement(s) from the Endorsement Library |
| RemoveEndorsement | RemoveEndorsement DATA=CSV Identifier | Remove the specified Endorsement(s) |
| SetExcess | SetExcess:ExcessName DATA = Amount | Set a Claim excess for the specified amount |
| SetMinNet | SetMinimumNet DATA = Amount | Set the minimum overall Net Premium |
| SetRiskGroupMinNet | SetRiskGroupMinimumNet:RISKGROUP_ID DATA= Amount | Set the minimum Net Premium for the specified Risk Group |
