Lookup files allow you to store values such as agent commission percentages outside the rating file. This means commissions can be maintained in a spreadsheet-style lookup and updated without editing the rating logic.

The rating file will then retrieve the commission value from the lookup file and apply it to the agent cover field.

This method is recommended when:

• Different agents have different commission levels
• Commission structures may change frequently
• You want to manage commission tables separately from rating logic

Step 1 – Create the Lookup File

Create a lookup file containing your agent identifiers and commission values.

Example Lookup File:

Name: SS - Agent List:

Column Explanation:

The first column must contain the lookup key used by the rating file.

Step 2 – Reference the Lookup File in the Rating File

In the rating file, use the SetCoverFromLookup command to retrieve the commission.

Example Rating File Syntax:

Step 3 – Understanding the Syntax

Full Structure:

Parameter Breakdown:

Step 4 – How It Works

• The rating engine reads the AgentSSRef question.
• It searches the SS - Agent List lookup file.
• It finds the row where Agent Ref = AgentSSRef.
• It retrieves the value from Agency Deal Commission.
• The value is applied to AgentCommission as the commission cover.

Step 5 – Example Flow

 User selects agent/SchemeServe recognises broker user who got the quote. Using [Agent.Name] or [Agent.Id] in your rating file will allow you to populate your hidden AgentSSRef question:

SetCover:AgentSSRef
[Agent.Name]

Lookup file match

Result applied in rating

The agent commission field is now 15%. You can now:

1. Use this to set commission fields on your matrix tab
2. Build in the option for Underwriters to override commission
 

Best Practices

✔ Use a consistent naming convention for lookup files (e.g. scheme prefix).
✔ Keep lookup files simple and well documented.
✔ Ensure the lookup key matches the question value exactly.

Related Commands