9.18. Underwriters Estimates
The parameters under this tab are used to maintain the user defined items and calculations for the underwriter’s estimations of a business.
Estimation Item #
This is where the names of items that are used as Pricing and Adjusted or Projection Estimates are maintained.
Create Estimation Item #
- Open system parameter maintenance from SICS desktop.
- Select Underwriters Estimates tab.
- Click the edit button
- Click right-mouse button and select new in the menu.
- Give the estimation item a new name
- Optionally you can select the various check boxes
- Click the Save button
- Click the OK button
Field Descriptions - Create Estimation Item #
| Field | Description |
|---|---|
| Name: | Name of the estimation item Values: Text Maximum number of characters: 30 Mandatory: Yes Applicable for: P&C, Life |
| Calc. Order: | The numeric order in which the estimation items are calculated. Values: Any number from 1 to 999 Default: Same value as Display Order Validation: Each Estimation Item must have a unique value Mandatory: Yes Applicable for: P&C, SICS Life |
| Display Order: | The numeric order in which the estimation item should be presented on the pricing and adjusted tabs. Values: Number Default: Last used number + 1, given by the system <br_Validation:_ Output field only <br_Mandatory:_ Yes Applicable for: P&C, SICS Life |
| Code: | If check box “Can be used in Multi GAAP” is selected this field is enabled. Values: Text Maximum number of characters: 10 Mandatory: Yes, if check box “Can be used in Multi GAAP” is selected Relevant when: An estimation item should also be used in the Multi GAAP module Applicable for: P&C, SICS Life |
| ‘Is Hidden’ | Selected: For users who have the option ‘Do Not Display Hidden Estimation Items’ selected in User Preferences, this Estimation Item is not displayed in the Pricing/Adjusted Estimates on the Businesses Cleared: The Estimation Item is displayed in the Pricing/Adjusted Estimates for all users Relevant when: You want the Estimation Item to be hidden for some users Applicable for: P&C, SICS Life |
| ‘Highlight Text’ | Selected: The name of the Estimation Item is highlighted in the Pricing/Adjusted Estimates on the businesses Cleared: The name of the Estimation Item is displayed in normal font/colour in the Pricing/Adjusted Estimates on the businesses Relevant when: You want to highlight some Estimation Items to improve readability in the Pricing/Adjusted Estimates Applicable for: P&C, SICS Life |
| ‘Can be used in Multi GAAP’ | Selected: Calculation rule can be used in Multi GAAP module Cleared: Calculation rule cannot be used in Multi GAAP module Relevant when: An estimation item should also be used in the Multi GAAP module Applicable for: P&C, SICS Life |
| ‘Prevent copying of Pricing Estimate values to Adjusted Estimates’ | Selected: The Estimation Item, system calculated or manually entered on the Pricing Estimate, will not be copied to the corresponding Adjusted Estimate. The Estimation Item will be visible in the Adjusted Estimates, but the amount will be zero. Cleared: The calculated or manually entered amount on the Pricing Estimate will be copied to the corresponding Adjusted Estimate. Relevant when: You want to prevent the value on this Estimation Item to be copied from a Pricing Estimate to the corresponding Adjusted Estimate. Applicable for: P&C |
| ‘Is Percentage’ | Selected: The Estimation Item will not be displayed in the sum up of Pricing/Adjusted Estimates on a Multi Year Contract Cleared: The Estimation Item will be displayed in the sum up of Pricing/Adjusted Estimates on a Multi Year Contract Relevant when: The Estimation Item is a percentage and should therefore not be summed up to the overall period on a Multi Year Contract Applicable for: P&C |
| ‘Inhibit edit of Adjusted’ | Selected: The estimation item value cannot be manually edited on the adjusted tab. Cleared: The estimation item value can be manually edited on the adjusted tab. Relevant when: Value is system derived and you want to prevent users from changing the derived value. Applicable for: P&C |
| ‘Inhibit edit of Pricing’ | Selected: The estimation item value cannot be manually edited on the pricing tab. Cleared: The estimation item value can be manually edited on the pricing tab Relevant when: Value is system derived and you want to prevent users from changing the derived value. Applicable for: P&C |
Move Order of Estimation Item #
Used for changing the order of an estimation item. Moves the item one step up or down in the list and changes the order numbers accordingly.
- Click the Edit button
- Select estimation item to be moved
- Click ‘Move Up’ or ‘Move Down’ button
- Click OK
Calculation Rule #
Here you create the calculation needed in order to give the estimation item the intended functionality, e.g. take the EPI from premium limit condition for Estimation Item Premium income.
Create a Calculation Rule #
- Open system parameter maintenance from SICS desktop.
- Select Underwriters Estimates tab.
- Click the edit button
- Select Calculation Rule tab
- Click right-mouse button and select new in the menu.
- Give the calculation rule a name
- Insert any calculation rule from expandable search tree widget by double clicking on it or else insert from search widget by giving minimum three characters of any rule.
- Optionally enter a description in plain text to explain what the calculation rule is supposed to do
- Click the Save button
- Click the OK button
Field Description - Create a Calculation Rule #
| Field | Description |
|---|---|
| Name: | Name of the calculation rule Values: Text Maximum number of characters : 25 Mandatory: Yes Applicable for: P&C, SICS Life |
| Calculation: | Enter the calculation you want to have performed by selecting relevant choices on the available pop-up menus. Values: Variables, functions, operators and sub calculations. See Appendix in this chapter for details. Mandatory: Yes Applicable for: P&C, SICS Life |
| Debug: | Use this when you want to track down which values the variables and functions have during the execution of the calculation rule on the Underwriters Estimates condition of the business, e.g. when a prizing estimate is added or recalculated. Selected: Debug mode is on Cleared: Debug mode is off Relevant when: You have created a new calculation rule and want to make sure that correct values are used. Or when a calculation rule is not returning the expected result and you want to see where the error exists. Mandatory: No Applicable for: P&C, Life |
| Note! | The debug mode is not persistent nor does it affect other users working with the system. The debug mode applies only for your machine for the current cession. The debug mode can also be switched on or of from the display list on the calculation rule tab, using the right-mouse menu option Switch debug mode. A message is shown on the Underwriters Estimate condition when a calculation in debug mode is performed. The variables and features used in the calculation of a specific estimation item are displayed in order for you to be able to detect whether or not correct values are returned. If the values are correct and you want to turn of the debug mode for the remainder of the calculation process, click the NO button on the message. If you want to keep the debug mode, click the YES button instead. |
| Description: | Use this field to describe in plain text what sort of calculation the rule is going to perform. Values: Text Maximum number of characters: 256 Mandatory: No |
Period Estimation Rule #
Here you link your estimation item with your calculation rule. In addition you set the timeframe that this rule is valid for and for what type (s) of business that this rule should apply for, e.g. Non-Proportional Treaty business etc.
Create Period Estimation Rule #
- Select system parameter maintenance from the SICS desktop.
- Select Underwriters Estimates tab.
- Click the Edit button.
- Select Period Estimation Rule tab.
- Select New from the pop-menu.
- Select an estimation item in the drop-down list
- Select one of the available calculation rules in the drop-down list
- Enter a valid date range
- Double- click type of business in the classification display list
- Select the type(s) of business that you want this rule to apply to and click Save button
- Click the OK button.
Field Description - Create Period Estimation Rule #
| Field | Description |
|---|---|
| Period Estimate Name: | Used to define for which estimation item the period estimation rule should apply. Values: Estimation items Mandatory: Yes Applicable for: P&C, Life |
| Calculation rule: | Used to define for which calculation rule the period estimation rule should apply. Values: Calculation rules Mandatory: Yes Applicable for: P&C, Life |
| Projection Basis: | Used to define for which projection basis the period estimation rule should apply. Values: <None>, Yearly, Ultimate. Mandatory: Yes Applicable for: Life |
| Valid Date Range: | Used to define under which period the period estimation rule should apply. Mandatory: Yes Applicable for: P&C, Life |
| Type of Business: | Used to define for which types of business (es) the period estimation rule should apply. Values: Reference data Type of Business Mandatory: Yes Applicable for: P&C, Life |
Sub Calculations #
In some situations, when a calculation rule is very complex and large, it is a good idea to break it up in smaller pieces in a sub calculation. The sub calculation can then be called for and used in one or several calculation rules.
Create a sub calculation #
- Open system parameter maintenance from SICS desktop.
- Select Underwriters Estimates tab.
- Click the edit button
- Select sub calculations tab
- Click right- mouse button and select new in the menu.
- Give the Sub Calculation a name
- Enter an identifier
- Insert any calculation rule from expandable search tree widget by double clicking on it or else insert from search widget by giving minimum three characters of any rule.
- Optionally enter a description in plain text to explain what the calculation rule is supposed to do
- Click the Save button
- Click the OK button
Field Description - Sub Calculations #
| Field | Description |
|---|---|
| Name: | Name of the sub calculation Values: Text Maximum number of characters: 25 Mandatory: Yes Applicable for: P&C, Life |
| Identifier: | Identifier for the sub calculation Values: Maximum number of characters: 35 Validations: The identifier must start with a lower case letter and can contain only letters or digits (no spaces). Mandatory: Yes Applicable for: P&C, Life |
| Calculation: | Enter the calculation you want to have performed by selecting relevant choices on the available pop-up menus. Values: Variables, functions, operators. See Appendix section in this chapter for details. Mandatory: Yes Applicable for: P&C, Life |
| Debug: | Use this when you want to track down which values the variables and functions have during the execution of the calculation rule. Selected: Debug mode is on Cleared: Debug mode is off Relevant: When changes have been done to a calculation in order to check that correct values are called for. Applicable for: P&C, Life |
| Note! | The debug mode is not persistent nor does it affect other users working with the system. The debug mode applies only for your machine for the current cession. The debug mode can also be switched on or of from the display list on the sub calculation rule tab, using the pop-up menu option Switch debug mode. A message is shown on the Underwriters Estimate condition when a calculation in debug mode is performed. The variables and features used in the calculation of a specific estimation item are displayed in order for you to be able to detect whether or not the correct values are returned. If the values are correct and you want to turn of the debug mode for the remainder of the calculation process, click the NO button on the message. If you want to keep the debug mode, click the YES button instead. Description: Use this field to describe in plain text what sort of calculation that is being performed. Values: Text Maximum number of characters: 256 Mandatory: No Applicable for: P&C, Life |
Loss Development Patterns #
Loss Development Patterns are used to calculate e.g. IBNR’s according to pre-defined methods. In order to perform the calculations, Loss Development Patterns must be created and made available for the calculation rules.
General #
Automatic Update of Contracts and HL Event Groups
Selected: The system automatically updates contracts and Headline Loss Event Groups linked to the updated development curve in system parameters. This means that the development curves are stored in the system parameters and not on the contract/event group and that the curves can only be edited in the system parameter and not on the contracts.
Note: When turning this parameter on, existing patterns on all contracts must be re-selected to be included in the automatic update.
Cleared: No automatic updated of contracts/event groups when updates are made in system parameters.
Relevant when: You want to secure a correct an effective update of development curves on multiple contracts /event groups
Applicable for: P&C
Create Incurred Development Curve #
- Open System Parameter Maintenance from SICS desktop
- Select Underwriters Estimates and then Loss Development Pattern
- Select the Incurred Development Curve and click the Edit button
- Select_New_ from pop-up menu
- Enter Pattern Name
- Enter Number of Months
- Enter values for each month
- Click_Save_
- Click OK
Create Paid Development Curve #
- Open System Parameter Maintenance from SICS desktop
- Select Underwriters Estimates and then Loss Development Pattern
- Select the Paid Development Curve and click the Edit button
- Select_New_ from pop-up menu
- Enter Pattern Name
- Enter Number of Months
- Enter values for each month
- Click_Save_
- Click OK
Import Loss Development Patterns from Spreadsheet #
SICS supports mass update / creation of Loss Development Patterns based on a spreadsheet format. The spreadsheet can include multiple patterns, both paid and incurred curves
The columns in the input file must have the following labels:
- Loss Development Pattern Name
- Loss Development Pattern Type (i.e. ‘Paid’or ‘Incurred’)
- Number of Months
- Month 001, Month 002,….Month 999
Select to import new or update existing Incurred or Paid Loss Development curves from a spreadsheet
- Open System Parameter Maintenance / Underwriters Estimates / Loss Development Patterns
- Open Incurred or Paid Development Curve in edit mode
- From pop-up menu, select Import Values From Spreadsheet
- Press the Find button and locate wanted file to import, or select Generate Template to let the system create a spreadsheet with all columns already present. In the generated template, specify mandatory details and define the new values per month.
- Click the Process button to validate the file.
- If the system detects any issues a list of errors is presented. Resolve all errors prior to processing the file again.
- If the file fulfil all criteria, the system returns a message informing which patterns are processed successfully.
- Press OK on message
- Press Import
- Press OK
If the imported file includes existing curves, these are updated with any new values.
If imported file includes new curves, these are created.
| Field | Description |
|---|---|
| Name | Name of the Incurred or Paid Development Curve Values: Maximum number of characters: 120 Mandatory: Yes Applicable for: P&C |
| Number of Months: | Number of months for which the Development Curve is valid Values: Minimum value: 1 Maximum value:999 Number of decimals: 0 Mandatory: Yes Applicable for: P&C |
| Months: | One lineper month is made available as per Number of Months entered Values: Number of Decimals: 0 Validations: Months are not editable Mandatory: Yes Applicable for: P&C |
| Values: | Percentage to be used in calculation rules Values:Minimum value: 0 Maximum value: 999,9999999 Number of Decimals: 7 Validations:Value for last month must be 100,0000000 Mandatory:Yes _Applicable for:_P&C |
General #
| Field | Description |
|---|---|
| Include Child Sections in MG True Up and UW estimation calculation | Selected: When Multi GAAP Accounting Order and Multi GAAP Retrocession Order calculate Accruals on a section, actual bookings on the same section in addition to all child sections, cessions and declarations will be included in the calculation. The system will behave as if the actual bookings have been booked on the section with Period Estimates. New estimates and accruals will be booked on the section with ‘Period Estimates’. When existing Calculation Variables Incurred Loss Business Ledger, Incurred Loss Business Ledger IP Rates and Incurred Loss Business Ledger FC Rates are used in the calculation of an Estimated Item on a section, the system will retrieve bookings from the same section in addition to any bookings on child sections, cessions or declarations. Cleared: When the Multi GAAP Accounting Order and Multi GAAP Retrocession Order calculate Accruals, actual bookings from each section are deducted from the Period Estimate amounts on the same section. When Calculation Variables Incurred Loss Business Ledger, Incurred Loss Business Ledger IP Rates and Incurred Loss Business Ledger FC Rates are used in the calculation of an Estimation Item in Underwriters Estimates, only bookings made on the same section as the estimated section are retrieved. Relevant when: Your company wants to have Pricing / Adjusted Estimates and Period Estimates only in e.g. main section, but actual technical bookings may be made on both main section and sub sections. Applicable for: P&C, Cede, Life (only Multi GAAP Part) |
| Do not validate Acc. Period From Date when uploading bookings | Selected: When Pricing or Adjusted Estimates are to be calculated manually or via the Underwriters Estimation Calculation Order on the Underwriters Estimates conditions the system will retrieve booking details with an Entry Code included in the reference Entry Code Group if the first day in the Booking Year Period is equal to or prior to the As At Date on the Pricing/Adjusted Estimate. The system will ignore the Accounting Period From Date on the booking details. Cleared: When Pricing or Adjusted Estimates are to be calculated manually or via the Underwriters Estimation Calculation Order on the Underwriters Estimates conditions the system will retrieve booking details with an Entry Code included in the reference Entry Code Group if BOTH the first day in the Booking Year Period AND the Accounting Period From Date is equal to or prior to the As At Date on the Pricing/Adjusted Estimate. Relevant when: When the booking details to be basis for calculating the Pricing or Adjusted Estimates should be extracted based on the Booking Year and Period only, then this parameter should be selected. Applicable for: P&C, Cede |
| Prevent estimates and link to PoP without Reg Complete | Enabled only when Business/Conditions/Miscellaneous system parameter Require Complete Registration is active Selected: When the Registration Complete flag is NOT set on the business, it is not possible to: - Link an assumed business to a Portfolio Program - Create Pricing estimates by running the Underwriters Estimation Calculation Order (P&C and Cede only) - Create new Pricing or Adjusted Estimates on the business (P&C and Cede only) - Create new Projections on the business (Life only) - Create new Period Estimates on the business Note: When you renew an assumed business which is linked to a Portfolio Program, the link to Portfolio Program will only be copied to the new period if the Registration Complete flag is set in the renewal process. When you run the Underwriters Estimation Calculation Order and the Registration Complete flag is NOT set on one or several businesses selected by the Order, this will prevent the Order from creating Pricing Estimates also on businesses where this flag is selected. Cleared: The Registration Complete flag is not validated when linking business Portfolio Programs or when creating new estimates on the business. Relevant when: You want to make sure the Registration Complete flag is selected before you start the estimation process on the business. Applicable for: P&C, Cede, Life |
| Prevent Pricing Estimates Prior To Insured Period Start Date | Selected: When the Underwriters Estimation Calculation Order is run with option Create Pricing Estimates selected, the Order will only create Pricing Estimates on businesses with an Insured Period From Date equal to or prior to the As At Date on the Order. Cleared: When the Underwriters Estimation Calculation Order is run with option Create Pricing Estimates selected, the Order will create Pricing Estimates on all businesses matching the Order criteria, with no validation on Insured Period From Date. Relevant when: You want to make sure Pricing Estimates are not created with an As At Date prior to the Insured Period From date. Note: The parameter only affects creating Pricing Estimates using he Underwriters Estimation Calculation Order. It does not affect the creation of Adjusted Estimates, manually on the business or by using the Order. It also does not affect the creation of Pricing Estimates manually from the business. Applicable for: P&C, Cede |
| Pricing Estimates per Model Section | Selected: Pricing Estimates can be created per Model Sections. A Model Section in this respect is an object with a set of classifications. The estimates can be aggregated and viewed on a higher (less specific) set of classification level, called Line of Business. Only Pricing Estimates are created, i.e. no Adjusted Estimates. See the Pricing Estimates per Model Section chapter in the P&C User Guide for more information about this function. Cleared: Pricing and Adjusted Estimates are created as a total for each section, without any split per Model Section. Relevant when: You want to create and store Pricing Estimates per Model Section. Note! Pricing Estimates per Model Section cannot be booked by the Accrual on Inward booking order. They cannot be used as input to any calculations in Multi GAAP. Applicable for: P&C, Cede |
| Pricing Estimates only sections linked to PFP | Selected: When the Underwriters Estimation Calculation Order is run with option Create Pricing Estimates selected, the Order will only create Pricing Estimates on business sections linked to a Portfolio Program. Cleared: When the Underwriters Estimation Calculation Order is run with option Create Pricing Estimates selected, the Order will create Pricing Estimates on all sections on businesses matching the Order criteria. Relevant when: Multi GAAP Module is active and you want to make sure Underwriters Estimates are only created on business sections linked to a Portfolio Program. Applicable for: P&C, Cede |
| Update As At Date on Calc. Order from Desired Start Time | Selected: When the Underwriters Estimation Calculation Order is run as a scheduled job, the As At Date on the Order is set equal to the Desired Start Time on the Scheduled Job. This also means that the As At Date on the created Pricing and/or Adjusted Estimates will be equal to the Desired Start Time on the Scheduled Job Cleared: The As At Date on the Underwriters Estimation Calculation Order is NOT updated with the Desired Start Time when the Order is run as a Scheduled Job Relevant when: You want to use the same Order at different points in time and you want to change the As At Date via Job Scheduler. Applicable for: P&C, Cede |
| Model Section Classification: Mandatory- and In Use rules | Enabled only when above parameter Pricing Estimates per Model Section is active Here you can define which Classification Types that are In Use, Mandatory and part of Line of Business (LoB) aggregation for Model Sections. The following validations will be performed: 1. Classification Types which are defined to be Mandatory, or part of LoB aggregation will have to be defined to be In Use 2. All Classification Types which are part of Line of Business aggregation have to be part of the same parent/child structure. |
| Calc. Order: Allow creation Pricing Estimate on a child section when it has already been created on another child section | Selected: When the Underwriters Estimation Calculation Order is run with option Create Pricing Estimates selected, the system allows the creation of Pricing Estimates on a child section even if the Pricing Estimates has already been created on another child section. Cleared: When the Underwriters Estimation Calculation Order is run with option Create Pricing Estimates selected, the system does not create any Pricing estimates if there already exist Pricing Estimates on any of the sections. Relevant when: You want to use the Underwriters Estimation Calculation Order to create Pricing Estimates on all the sections for the contract. Applicable for: P&C, Cede |
Appendix #
Calculation Rule Variables #
For P&C:
| Variable Name | Code Name | Data Type | Description |
|---|---|---|---|
| Brokerage Amount | (%deductionBrokerageAmount) | Decimal | The sum of all amounts defined in the SICS deduction condition for deduction types with Deduction Type behaviour: Brokerage. |
| Brokerage Percent | (%deductionBrokeragePercentage) | Percent | The sum of all percents as defined in the SICS deduction condition for deduction types with Deduction Type behaviour: Brokerage. |
| Claim/Incurred Loss Business Ledger | (%incurredLossBusiness Ledger: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using the most recent day rate. System only returns booked figures with: First Day in Booking Year/ Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date |
| Claim/Incurred Loss Business Ledger FC Rates | (%incurredLossBusiness LedgerFCRates: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using exchange rate rules defined in Functional Currency 1 in Accounting/Currency System Parameters. System only returns booked figures with: First Day in Booking Year/Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date |
| Claim/Incurred Loss Business Ledger IP Daily Rates | (%incurredLoss-Business LedgerIPDailyRates: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using the Daily Rate valid at the business’ Insured Period Start Date. The System only returns booked figures with: First Day in Booking Year/ Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date |
| Claim/Incurred Loss Business Ledger IP Rates | (%incurredLossBusiness LedgerIPRates: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using Period End Rate of the of the last period before business’ Insured Period Start Date. System only returns booked figures with: First Day in Booking Year/Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date |
| Claim/Incurred per Event | %incurredPerEvent | Decimal | This variable will retrieve the Incurred Loss amount from the claim ledger on claims where the Risk/Event indicator has been set to Event. Includes all claim worksheet bookings, regardless of transfer flag. Applicable to Non-Prop businesses only. |
| Claim/Incurred per Risk | %incurredPerRisk | Decimal | This variable will retrieve the Incurred Loss amount from the claim ledger on claims where the Risk/Event indicator has been set to Risk. Includes all claim worksheet bookings, regardless of transfer flag. Applicable to Non-Prop businesses only. |
| Claim/Our Ground Up per Event | %ourGroundUpPerEvent | Decimal | This variable will retrieve the value from the Our Ground Up Loss field (Claim Figures tab) on claims where the Risk/Event indicator has been set to Event. Applicable to Proportional businesses only. |
| Claim/Our Ground Up per Risk | %ourGroundUpPerRisk | Decimal | This variable will retrieve the value from the Our Ground Up Loss field (Claim Figures tab) on claims where the Risk/Event indicator has been set to Risk. Applicable to Proportional businesses only. |
| Commission Amount | (%deductionCommissionAmount) | Decimal | This variable will show a sum of deduction types with deduction type behaviour: Commission, defined in the SICS deduction condition with calculation method Amount |
| Commission Percent | (%deductionCommissionPercentage) | Percent | This variable will show a sum of deduction types with deduction type behaviour: Commission, defined in the SICS deduction condition with calculation method Percent |
| Others Amount | (%deductionOthersAmount:) | Decimal | This variable will show a sum of deduction types with deduction type behaviour: Others, defined in the SICS deduction condition with calculation method Amount |
| Others Percent | (%deductionOthersPercentage) | Percent | This variable will show a sum of deduction types with deduction type behaviour: Others, defined in the SICS deduction condition with calculation method Percent |
| Adjusted Premium Our Share | %adjustedPremiumOurShare | Decimal | This variable will return the Adjusted Premium Our Share from the last Adjustment in the Prmeium Accounting window of the P/L conditions. Applicable to Non Proportional Treaties. |
| Adjusted Premium Our Share Per Curr | %adjustedPremiumOurSharePerCurr | Decimal | This variable returns the Adjusted Premium Our Share from the last Adjustment in the Premium Accounting window of the P/L conditions, for the same currency as the estimate currency. Applicable to Non Proportional Treaties |
| Adjusted SUPI | %adjustedSUPI | Decimal | This variable will return the Adjusted SUPI from the last Adjustment in the Premium Accounting window of the P/L conditions. Applicable to Non Proportional Treaties. |
| Adjusted SUPI Per Curr | %adjustedSUPIPerCurr | Decimal | This variable will return the Adjusted SUPI from the last Adjustment in the Premium Accounting window of the P/L conditions, for the same currency as the estimate currency. Applicable to Non Proportional Treaties |
| Estimated Premium Income (PI) | %premiumIncomeAmount | Decimal | User has to give manual input on the pricing tab on the underwriters estimate condition |
| Minimum Premium Amount Our Share | %minimumPremiumAmountOurShare | Decimal | This variable will show the Minimum Premium as entered in Deposit Premium Condition. Applicable for all Types of Business which have Minimum and Deposit Premium |
| Minimum Premium Amount Our Share Per Curr | %minimumPremiumAmountOurSharePerCurr | Decimal | This variable will return the Minimum Premium as entered in Deposit Premium Condition, for the same currency as the estimate currency. Applicable for all Types of Business which have Minimum and Deposit Premium |
| Deposit Premium Amount Our Share | %depositPremiumAmountOurShare | Decimal | This variable will show the Deposit Premium as entered in Deposit Premium Condition. Applicable for all Types of business which have Minimum and Deposit Premium |
| Deposit Premium Amount Our Share Per Curr | %depositPremiumAmountOurSharePerCurr | Decimal | This variable will return the Deposit Premium as entered in Deposit Premium Condition, for the same currency as the estimate currency. Applicable for all Types of Business which have Minimum and Deposit Premium |
| Premium Rate | %premiumRate | Percent | This variable will show the Premium Rate from Main tab of P/ L conditions. Applicable to Non Proportional Treaties. |
| Revised SUPI | %revisedSUPI | Decimal | This variable will show the Revised SUPI from the Main tab of the P/L conditions. Applicable to Non Proportional Treaties. |
| Management Expences % | %managementxpencesPercent | Percent | This variable will show Management Expenses % from Profit commission condition |
| Profit Commission | %profitCommissionPercentage | Number | The Profit Commission % from the PC-conditions. |
| Sliding Scale Max Profit Commission | %slidingScaleMaximumProfitCommissionPercentage | Percent | The Sliding Scale Max Profit Commission Percent from The Sliding Scale tab of the PC-conditions. |
| Sliding Scale Min Profit Commission | %slidingScaleMinimumProfitCommissionPercentage | Percent | The Sliding Scale Min Profit Commission Percent from The Sliding Scale tab of the PC-conditions. |
| Sliding Scale Max Result | %slidingScaleMaximumResultPercentage | Percent | The Sliding Scale Max Result Percent from The Sliding Scale tab of the PC-conditions. |
| Sliding Scale Min Profit Commission | %slidingScaleMinimumResultPercentage | Percent | The Sliding Scale Min Result Percent from The Sliding Scale tab of the PC-conditions. |
| No of Reinstatements | %noOfReinstatements | Number | The value from the Number Field in the Conditions tab of the R-conditions |
| Reinstatement Amount % | %reinstatementAmount | Decimal | The value from the Reinstatement Amount % field in the Conditions tab of the of the R-conditions |
| Reinstatement Time % | %reinstatementTime | Number | The value from the Reinstatement Time % field in the Conditions tab of the of the R-conditions |
| Loading Factor Dividend | %loadingFactorDividend | Decimal | Limit/Premium Condition Non-proportional with Premium type: sliding rate or sliding amount |
| Loading Factor Divisor | %loadingFactorDivisor | Percent | Limit/Premium Condition Non-proportional with Premium type: sliding rate or sliding amount |
| Maximum % | %slidingRateMaximumPercentage | Percent | Limit/Premium Condition Non-proportional with Premium type: sliding rate |
| Minimum % | %slidingRateMiniumPercentage | Percent | Limit/Premium Condition Non-proportional with Premium type: sliding rate |
| Provisional % | %slidingRateProvisionalPercentage | Decimal | Limit/Premium Condition Non-proportional with Premium type: sliding rate |
| SUPI Amount | %supi | Decimal | Limit/Premium Condition Non-proportional |
| Total Amount Booked/Gross | %grossTotalAmountBooked | Decimal | This variable is only valid for Non-Proportional business (it returns 0 for other types of business). It retrieves the value from ‘Total Amount Booked’ - ‘Gross’ field in Installment Tab. |
| Total Amount Booked/Net | %netTotalAmountBooked | Decimal | This variable is only valid for Non-Proportional business (it returns 0 for other types of business). It retrieves the value from ‘Total Amount Booked’ - ‘Net’ field in Installment Tab. |
| Total Amount Not Booked/Gross | %grossTotalAmountNotBooked | Decimal | This variable is only valid for Non-Proportional business (it returns 0 for other types of business). It retrieves the value from ‘Total Amount Not Booked’ - ‘Gross’ field in Installment Tab. |
| Total Amount Not Booked/Net | %netTotalAmountNotBooked | Decimal | This variable is only valid for Non-Proportional business (it returns 0 for other types of business). It retrieves the value from ‘Total Amount Not Booked’ - ‘Net’ field in Installment Tab. |
| Imported Values | %importedValue:‘DataTypeCode’ | Decimal | The variable will return the imported value for the relevant Data Type Code, Business Section and Currency. The values can be imported using the UW Estimates Supporting Figures Import in the Periodic Functions folder. Available Data Type Codes are defined in reference tables, reference type 01174 Underwriters Estimates Imported Value Data Type. |
| Current Share | %currentShare | Percent | The variable will show the Current Share of the business. Current share equals Signed Share if this exists, if not it equals Written Share. If neither Signed nor Written share exists, Current Share equals Offered Share. Applicable to all Types of Business. |
| Additional URL | %additionalULR | Percent | The value from the Additional ULR field on the estimate conditions on the attached Portfolio Program |
| Additional URL 2 | %additionalULR2 | Percent | The value from the Additional ULR 2 field on the estimate conditions on the attached Portfolio Program |
| Default Pricing URL | %defaultPricinglULR | Percent | The value from the Default Pricing ULR field on the estimate conditions on the attached Portfolio Program |
| Default Pricing URL2 | %defaultPricinglULR2 | Percent | The value from the Default Pricing ULR 2 field on the estimate conditions on the attached Portfolio Program |
| IBNR Method | %ibnrMethod | Alphanumeric | The reference code related to the reference name selected in the IBNR Method field on the attached Portfolio Program. |
| IBNR Method 2 | %ibnrMethod2 | Alphanumeric | The reference code related to the reference name selected in the IBNR Method 2 field on the attached Portfolio Program. |
| Loss Development Figure | %lossDevelopmentFigure | Percent | The value from the Incurred Development Curve table on the business in the month corresponding to the As of Date of the Pricing/Adjusted Estimate |
| Loss Development Figure 2 | %lossDevelopmentFigure2 | Percent | The value from the Incurred Development Curve 2 table on the business in the month corresponding to the As of Date of the Pricing/Adjusted Estimate |
| Loss Development Figure Per Last Account | %lossDevelopmentFigurePerLastAccount | Percent | The value from the Incurred Development Curve table on the business in the month corresponding to the As of Date of the last booked account in the Administration Conditions |
| Loss Development Figure Per Last Account 2 | %lossDevelopmentFigurePerLastAccount2 | Percent | The value from the Incurred Development Curve 2 table on the business in the month corresponding to the As of Date of the last booked account in the Administration Conditions |
| Loss Development Paid Figure | %lossDevelopmentPaidFigure | Percent | The value from the Paid Development Curve table on the business in the month corresponding to the As of Date of the Pricing/Adjusted Estimate |
| Loss Development Paid Figure 2 | %lossDevelopmentPaidFigure2 | Percent | The value from the Paid Development Curve 2 table on the business in the month corresponding to the As of Date of the Pricing/Adjusted Estimate |
| Loss Development Paid Figure Per Last Account | %lossDevelopmentPaidFigurePerLastAccount | Percent | The value from the Paid Development Curve table on the business in the month corresponding to the As of Date of the last booked account in the Administration Conditions |
| Loss Development Paid Figure Per Last Account 2 | %lossDevelopmentPaidFigurePerLastAccount2 | Percent | The value from the Paid Development Curve 2 table on the business in the month corresponding to the As of Date of the last booked account in the Administration Conditions |
- For LIFE:
| Variable Name | Code Name | Data Type | Description |
|---|---|---|---|
| Claim/Incurred Loss Business Ledger | (%incurredLossBusiness Ledger: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using the most recent day rate. System only returns booked figures with: First Day in Booking Year/ Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date. When Projection Basis = Yearly: The booked amounts are shown on the Projection Year equal to the Acc Year on the booking. Bookings with an Acc Year with no corresponding Projection Year are not shown |
| Claim/Incurred Loss Business Ledger FC Rates | (%incurredLossBusiness LedgerFCRates: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using exchange rate rules defined in Functional Currency 1 in Accounting/Currency System Parameters. System only returns booked figures with: First Day in Booking Year/Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date. When Projection Basis = Yearly: The booked amounts are shown on the Projection Year equal to the Acc Year on the booking. Bookings with an Acc Year with no corresponding Projection Year are not shown |
| Claim/Incurred Loss Business Ledger IP Daily Rates | (%incurredLoss-Business LedgerIPDailyRates: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using the Daily Rate valid at the business’ Insured Period Start Date. The System only returns booked figures with: First Day in Booking Year/ Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date. When Projection Basis = Yearly: The booked amounts are shown on the Projection Year equal to the Acc Year on the booking. Bookings with an Acc Year with no corresponding Projection Year are not shown |
| Claim/Incurred Loss Business Ledger IP Rates | (%incurredLossBusiness LedgerIPRates: ‘Entry Code Group’) | Decimal | This variable will show booked figures converted to estimation currency using Period End Rate of the of the last period before business’ Insured Period Start Date. System only returns booked figures with: First Day in Booking Year/Period AND Accounting Period From Date equal to or less than Estimate’s As Of Date. When Projection Basis = Yearly: The booked amounts are shown on the Projection Year equal to the Acc Year on the booking. Bookings with an Acc Year with no corresponding Projection Year are not shown |
| Interest on Deposit | %interestOnDepositPercent | Percent | Value based on the registration of interest rate from the DR-condition. |
| Deductions (Basic Multiple Extras %) | %deductionBasicMultipleExtrasCalculatedAsPercentage | Decimal | Deduction condition Multiple Extras Commission amount to be calculated as percent. |
| Deductions (Basic Multiple Extras permille) | %deductionBasicMultipleExtrasCalculatedAsPermille | Decimal | Deduction condition Multiple Extras Commission amount to be calculated as permille. |
| Deductions (Basic Multiple Extras %) | %deductionBasicMultipleExtrasInitialCommissionPercentage | Decimal | Deduction condition Initial Commission amount to be calculated as percent. |
| Deductions (Basic Multiple Extras permille) | %deductionBasicMultipleExtrasInitialCommissionPerMille | Decimal | Deduction condition Initial Commission amount to be calculated as permille. |
| Deductions (Basic Multiple Extras %) | %deductionBasicMultipleExtrasMaximumAnnualPercentage | Decimal | Deduction condition Maximum Annual Commission amount to be calculated as percent. |
| Deductions (Basic Multiple Extras permille) | %deductionBasicMultipleExtrasMaximumAnnualPermille | Decimal | Deduction condition Maximum Annual Commission amount to be calculated as permille. |
| Deductions (Basic Multiple Extras %) | %deductionBasicMultipleExtrasRenewalCommissionPercentage | Decimal | Deduction condition Renewal Commission amount to be calculated as percent. |
| Deductions (Basic Multiple Extras permille) | %deductionBasicMultipleExtrasRenewalCommissionPerMille | Decimal | Deduction condition Renewal Annual Commission amount to be calculated as permille. |
| Deductions (Basic Premium %) | %deductionBasicPremiumCalculatedAsPercentage | Decimal | Deduction condition Premium Commission amount to be calculated as percent. |
| Deductions (Basic Premium permille) | %deductionBasicPremiumCalculatedAsPermille | Decimal | Deduction condition Premium Commission amount to be calculated as permille. |
| Deductions (Basic Premium %) | %deductionBasicPremiumInitialCommissionPercentage | Decimal | Deduction condition Initial Commission amount to be calculated as percent. |
| Deductions (Basic Premium permille) | %deductionBasicPremiumInitialCommissionPerMille | Decimal | Deduction condition Initial Commission amount to be calculated as permille. |
| Deductions (Basic Premium %) | %deductionBasicPremiumMaximumAnnualPercentage | Decimal | Deduction condition Maximum Annual Commission amount to be calculated as percent. |
| Deductions (Basic Premium permille) | %deductionBasicPremiumMaximumAnnualPermille | Decimal | Deduction condition Maximum Annual Commission amount to be calculated as permille. |
| Deductions (Basic Premium %) | %deductionBasicPremiumRenewalCommissionPercentage | Decimal | Deduction condition Renewal Commission amount to be calculated as percent. |
| Deductions (Basic Premium permille) | %deductionBasicPremiumRenewalCommissionPerMille | Decimal | Deduction condition Renewal Annual Commission amount to be calculated as permille. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasInitialCommissionPercentage | Decimal | Deduction condition Initial Commission amount to be calculated as percent. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasInitialCommissionPerMille | Decimal | Deduction condition Initial Commission amount to be calculated as permille. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasCalculatedAsPercentage | Decimal | Deduction condition Flat or Per Mille Extras Commission amount to be calculated as percent. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasCalculatedAsPerMille | Decimal | Deduction condition Flat or Per Mille Extras Commission amount to be calculated as permille. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasMaximumAnnualPercentage | Decimal | Deduction condition Flat or Per Mille Extras Maximum Annual Commission amount to be calculated as percent. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasMaximumAnnualPerMille | Decimal | Deduction condition Flat or Per Mille Extras Maximum Annual Commission amount to be calculated as permille. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasRenewalCommissionPercentage | Decimal | Deduction condition Flat or Per Mille Extras Renewal Commission amount to be calculated as Percent. |
| Deductions (Basic Flat or Permille Extras %) | %deductionFlatOrPerMilleExtrasRenewalCommissionPerMille | Decimal | Deduction condition Flat or Per Mille Extras Renewal Commission amount to be calculated as Permille. |
| Imported Values | %importedValue:‘DataTypeCode’ | Decimal | The variable will return the imported value for the relevant Data Type Code, Business ID, Insured Period Start Date, Business Section Name, Projection Year, Currency and Value. The values can be imported using the UW Estimates Supporting Figures Import in the Periodic Functions folder. Available Data Type Codes are defined in reference tables, reference type 01174 Underwriters Estimates Imported Value Data Type. |
Premium related Variables #
For LIFE:
| Variable Name | Code Name | Data Type | Description |
|---|---|---|---|
| Deposit Premium Signed Share | %depositPremiumSignedShare | Decimal | Signed Share Deposit Premium amount entered on the Premium condition in the same currency as the estimation. |
| Deposit Premium Written Share | %depositPremiumWrittenShare | Decimal | Written Share Deposit Premium amount entered on the Premium condition in the same currency as the estimation. |
| Minimum Premium Signed Share | %minimumPremiumSignedShare | Decimal | Signed Share Minimum Premium amount entered on the Premium condition in the same currency as the estimation. |
| Minimum Premium Written Share | %minimumPremiumWrittenShare | Decimal | Written Share Minimum Premium amount entered on the Premium condition in the same currency as the estimation. |
Operators #
| Operator | Description |
|---|---|
+ |
Plus |
- |
Minus |
* |
Multiply |
/ |
Divide |
= |
Equal to |
~= |
Not equal to |
> |
Larger than |
< |
Smaller than |
>= |
Larger than or equal to |
<= |
Smaller than or equal to |
( |
Start bracket |
) |
End bracket |
| ` | ` |
&? |
And (Can be used in IF_THEN_ELSE functions) |
Calculation Rule Functions #
Both P&C and LIFE:
| Name | IF..Then..Else..End |
|---|---|
| Code name | (#IF ( <condition> ) #THEN <command1> #ELSE <command2> #END) |
| Return data type | Depends on return date type of <command1> or <command2> respectively. |
| Arguments | <condition> is a Boolean expression <command1> is one or more commands that are executed if <condition> evaluates to true <command2> is one or more commands that are executed if <condition> evaluates to false |
| Description | This function works like known from other programming languages. A condition is checked. Depending on the result (true or false) the Then branch or the Else branch is executed. |
| Name | Includes… |
|---|---|
| Code name | ( #FUNC objectCollection: #( <object1> <object2> <etc..> ) includes: <anObject> ) |
| Return data type | To be used with If…Then…Else…End… |
| Arguments | |
| Description | This function can be used with Variables that can return more than one value, for example Accounting Quarter. |
Calculated Amounts #
For P&C:
| Name | (Stepped) Sliding Scale Commission %… |
|---|---|
| Code name | ( #FUNC getSlidingScaleCommissionPercentageForIncurredLosses: <name> andEstimatedPremiumIncome: <name>) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimation Items or Sub Calculations in single quotes. |
| Description | The arguments of the function are selected from a pop-up table that contains all Estimation Items and created Sub Calculations. Sliding Scale Commission is calculated without considering any input in Interim 1 and/or Interim 2 fields in the Sliding Scale Commission definition on the business. |
| Name | (Stepped) Sliding Scale Commission % with interim… |
| Code name | ( #FUNC getSlidingScaleCommissionPercentageWithInterimForIncurredLosses: <name> andEstimatedPremiumIncome: <name>) |
| Return data type | Decimal |
| Argument | <name> is the name of the referenced Estimation Items or Sub Calculations in single quotes. |
| Description | The arguments of the function are selected from a pop-up table that contains all Estimation Items and created Sub Calculations. Input in Interim 1 and/or Interim 2 fields in the Sliding Scale Commission definition on the business are considered when Sliding Scale Commission is calculated. |
| Name | (Stepped) Sliding Scale Profit Commission %… |
| Code name | ( #FUNC getSlidingScaleProfitCommissionPercentageForResult: <name> andEstimatedPremiumIncome: <name>) |
| Return data type | Decimal |
| Argument | <name> is the name of the referenced Estimation Items or Sub Calculations in single quotes. |
| Description | The arguments of the function are selected from a pop-up table that contains all Estimation Items and created Sub Calculations. The Profit Commission % is calculated based on the Sliding Scale or Stepped Sliding Scale defined in the Profit Commission Condition |
| Name | Deduction Basis |
| Code name | (#FUNC getDeductionBasisForOption: ‘<code>’ “<name>”) |
| Return data type | Alphanumeric |
| Arguments | <code> is the Code of the referenced Deduction Type <name> is the Name of the referenced Deduction Type |
| Description | The argument of the function is selected from a popup window. The function returns the Entry Code Group (Code) selected as Deduction Basis in Deduction Conditions for the referenced Deduction Type. The function can be used in an IF-THEN-ELSE function to apply different calculation of deductions depending on the Deduction Basis selected in Deduction Conditions. |
| Name | Estimated Item Amount |
| Code name | ( #FUNC getEstimatedAmountForEstimationItem: ‘<name>’) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimation Item in single quotes. |
| Description | Instead of performing a calculation rule that belongs to another Estimation Item you can reference the amount from the period estimate tab directly. To do so use this function. The advantage of using this function is that you can also execute calculation. |
| Name | Limit Optional Amount… |
| Code name | ( #FUNC getLimitAmountForOptionCode: <name>) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Limit amount defined as “Limit Premium Optional Field” in the SICS Reference Data Maintenance. Only active optional fields of type amount limit with treaty limit behaviour are shown in the list. Exemptions to the rule are optional fields being system defined not to show our share e.g. Excess. |
| Description | This makes the selection of limit amounts flexible and according to the user’s definitions. |
| Name | Premium Optional Amount (Non-Proportional) |
| Code name | ( #FUNC getPremiumAmountForOptionCode:<name> ) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Premium Optional Amount defined as “Limit Premium Optional Field” in the SICS Reference Data Maintenance. |
| Description | This makes the selection of the premium amounts for non-proportional business flexible and user defined. |
| Name | Premium Optional Amount (Proportional) |
| Code name | ( #FUNC getPremiumAmountForOptionCode:<name> ) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Premium Optional Amount defined as “Limit Premium Optional Field” in the SICS Reference Data Maintenance. |
| Description | This makes the selection of the premium amounts for proportional business flexible and user defined. |
| Name | Reinstatement Premium |
| Code name | ( #FUNC getReinstatementAmountUsingIncurredClaim: <Incurred Losses>andLimitOptionAmount: ‘<Limit Option> “Cover” andPremiumOptionAmount: <Premium>) |
| Return data type | Decimal |
| Arguments | <Incurred Losses> is the reference to the data field with claim value. <Limit Option> is the reference to the data field with the limit value. <Premium> is the reference to the data field with the premium value. |
| Description | This function calculates the Reinstatement Premium based on input of variables. The arguments are added as parameters. |
For LIFE:
| Name | Claim Portfolio (IN) |
|---|---|
| Code name | ( #FUNC getClaimPortfolioInAmountForTransferItem: <name1> forUnitType: <name2> ) |
| Return data type | Decimal |
| Arguments | <name1> is the name of the referenced Transfer Item in single quotes. <name2> is the name of the referenced Unit Type in single quotes. |
| Description | The arguments of the function are selected from a pop-up table that contains all values available in the Portfolio Transfer condition. |
| Name | Claim Portfolio (OUT) |
| Code name | ( #FUNC getClaimPortfolioOutAmountForTransferItem: <name1> forUnitType: <name2> ) |
| Return data type | Decimal |
| Arguments | <name1> is the name of the referenced Transfer Item in single quotes. <name2> is the name of the referenced Unit Type in single quotes. |
| Description | The arguments of the function are selected from a pop-up table that contains all values available in the Portfolio Transfer condition. |
| Name | Estimated Item Amount |
| Code name | ( #FUNC getEstimatedAmountForEstimationItem: <name>) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimation Item |
| Description | This makes the selection of Estimation amounts flexible and according to the user’s definitions. |
| Name | Estimated Item Amount for Accounting Year |
| Code name | ( #FUNC getEstimatedAmountForAccountingYear: ‘Premium Income (PI)’ accountingYear:’(%accountingYear - 1)’) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimation Item |
| Description | This makes the Estimation Item value possible to select from a previous Projection Year |
| Name | Other Deductions Per Mille |
| Code name | ( #FUNC getOtherDeductionPerMilleForDeductionType<name>) |
| Return data type | Permille |
| Arguments | <name> is the name of the referenced Deduction Type Permille defined as Add Permille/Percent Deductions in the Deduction conditions |
| Description | This is according to the user defined Agreement Deductions on specific assumed business |
| Name | Other Deductions Percent |
| Code name | ( #FUNC getOtherDeductionPercentForDeductionType<name>) |
| Return data type | Percent |
| Arguments | <name> is the name of the referenced Deduction Type Percent defined as Add Permille/Percent Deductions in the Deduction conditions |
| Description | This is according to the user defined Agreement Deductions on specific assumed business |
| Name | Premium Portfolio (IN) |
| Code name | ( #FUNC getPremiumPortfolioInAmountForTransferItem: <name1> forUnitType: <name2> ) |
| Return data type | Decimal |
| Arguments | <name1> is the name of the referenced Transfer Item in single quotes. <name2> is the name of the referenced Unit Type in single quotes. |
| Description | The arguments of the function are selected from a pop-up table that contains all values available in the Portfolio Transfer condition. |
| Name | Premium Portfolio (OUT) |
| Code name | ( #FUNC getPremiumPortfolioOutAmountForTransferItem: <name1> forUnitType: <name2> ) |
| Return data type | Decimal |
| Arguments | <name1> is the name of the referenced Transfer Item in single quotes. <name2> is the name of the referenced Unit Type in single quotes. |
| Description | The arguments for the function are selected from a pop-up table that contains all values available in the Portfolio Transfer condition. |
Calculated Amounts - System Created #
For P&C:
| Name | Brokerage Amount |
|---|---|
| Code name | ( #FUNC getBrokerageAmountForEstimatedPremiumIncome:<name>) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimated Premium Income in single quotes. |
| Description | By using this function it is possible to get the Brokerage Amount calculated by using a predefined Code function |
| Name | Portfolio Aggregated Amount |
| Code name | ( #FUNC getCommissionsForEstimatedPremiumIncome:<name>) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimated Premium Income in single quotes. |
| Description | By using this function it is possible to get the Commission Amount calculated by using a predefined Code function |
| Name | Loss Corridor Amount |
| Code name | ( #FUNC getLossCorridorAmountForIncurredLosses:<name1> andEstimatedPremiumIncome: <name2>) |
| Return data type | Decimal |
| Arguments | <name1> is the name of the referenced Estimation Item that handles the claim amount in single quotes. <name2> is the name of the referenced Estimation Item that handles the premium amount in single quotes. |
| Description | This function is used when calculating the Loss corridor amount together with the conditions registered for the business. |
| Name | Loss Participation Amount |
| Code name | ( #FUNC getLossParticipationAmountForIncurredLosses<name1> andEstimatedPremiumIncome: <name2>) |
| Return data type | Decimal |
| Arguments | <name1> is the name of the referenced Estimation Item that handles the claim amount in single quotes. <name2> is the name of the referenced Estimation Item that handles the premium amount in single quotes. |
| Description | This function is used when calculating the Loss participation amount together with the conditions registered for the business. |
| Name | No Claim Bonus Amount |
| Code name | ( #FUNC getNoClaimBonusAmountForIncurredLosses:<name1> andEstimatedPremiumIncome: <name2>) |
| Return data type | Decimal |
| Arguments | <name1> is the name of the referenced Estimation Item that handles the claim amount in single quotes. <name2> is the name of the referenced Estimation Item that handles the premium amount in single quotes. |
| Description | This function is used when calculating the No Claims Bonus amount together with the conditions registered for the business. |
| Name | Other Deductions Amount |
| Code name | ( #FUNC getOtherDeductionsAmountForEstimatedPremiumIncome: <name>) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimated Premium Income in single quotes. |
| Description | By using this function it is possible to get the Other Deductions Amount calculated by using a predefined Code function |
| Name | Overrider Amount |
| Code name | ( #FUNC getOverriderAmountForEstimatedPremiumIncome: ‘Premium Income (PI)’) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimated Premium Income in single quotes. |
| Description | By using this function it is possible to get the Overrider Amount calculated by using a predefined Code function |
| Name | Tax on Premium Amount |
| Code name | ( #FUNC getTaxOnPremiumAmountForEstimatedPremiumIncome: <name>) |
| Return data type | Decimal |
| Arguments | <name> is the name of the referenced Estimated Premium Income in single quotes. |
| Description | By using this function it is possible to get the Tax on Premium Amount calculated by using a predefined Code function |
Date related Functions #
Both P&C and LIFE:
| Name | Days between Dates |
|---|---|
| Code name | ( #FUNC daysBetween: ( <higherDate> ) and: ( <lowerDate> ) ) |
| Return data type | Number |
| Arguments | <higherDate> is the higher date from which the <lowerDate> is subtracted |
| Description | This function calculates the number of days that lie between two dates. Depending on which date is supplied as the first and which date is supplied as the second argument this function returns a positive or negative value. |
| Name | Days between Dates (always +ve) |
| Code name | ( #FUNC positiveDaysBetween: ( <date 1> ) and: ( <date 2> ) ) |
| Return data type | Number |
| Arguments | <date1> and <date2> are two variables or terms that represent date values |
| Description | Same as above but always returns a positive value. |
| Name | User defined Date |
| Code name | ( #FUNC day: <day> month: <month index> year: <year> ) |
| Return data type | Date |
| Arguments | <day> is a number specifying a day <month index> represent the month where 1 is January, 2 is February etc. <year> is a number representing the year |
| Description | This function can be used to create new date values. A day, month and year is supplied. |
| Name | Add days to a date |
| Code name | ( #FUNC addDays: <anInteger> toDate: <aDate> ) |
| Return data type | Date |
| Arguments | <anInteger> is a number <adate> is a date |
| Description | This function can be used to create new date values. |
| Name | Subtract days from a date |
| Code name | ( #FUNC subtractDays: <anInteger> fromDate: <aDate> ) |
| Return data type | Date |
| Arguments | <anInteger> is a number <adate> is a date |
| Description | This function can be used to create new date values. |
| Name | The day of a date |
| Code name | ( <date> dayOfMonth ) |
| Return data type | Number |
| Arguments | <date> is a variable or term of type Date |
| Description | For a given date this functionality returns a number that indicates which day of the month it is. |
| Name | The month of a date |
| Code name | ( <date> monthIndex ) |
| Return data type | Number |
| Arguments | <dateh> is a variable or term of type date |
| Description | Returns the index of the respective month. |
| Name | The year of a date |
| Code name | ( <date> year ) |
| Return data type | Number |
| Arguments | <date> is a variable or term of type date |
| Description | Returns the year of a date value. |
Number Functions #
Both P&C and LIFE:
| Name | Convert to Integer |
|---|---|
| Code name | ( <aNumber> ) asInteger |
| Return data type | Number |
| Arguments | <aNumber> is a decimal |
| Description | This function converts a number to the nearest integer number. |
| Name | Exponent function |
| Code name | ( #FUNC raise: ( <value> ) toPower: ( <exponent> )) |
| Return data type | Decimal |
| Arguments | <value> and <exponent> are numbers (integer or decimal). Both can be entered as fixed values, variables, functions or sub calculations |
| Description | Raises the Value to the power of the Exponent. The calculation follows the general mathematical rules for exponent functions. However, note that 0 raised to power of 0, and 0 raised to power of a negative value, are both calculated as 0. |
| Name | Fraction of a Number |
| Code name | ( <aNumber> ) fractionPart |
| Return data type | Decimal |
| Arguments | <aNumber> is a decimal |
| Description | Returns the fraction part of a number. |
| Name | Max |
| Code name | ( <arg1> max: <arg2> ) |
| Return data type | Decimal |
| Arguments | <arg1> and <arg2> are decimals. |
| Description | Returns the greater of two values. |
| Name | Min |
| Code name | ( <arg1> min: <arg2> ) |
| Return data type | Decimal |
| Arguments | <arg1> and <arg2> are decimals. |
| Description | Returns the smaller of two values. |
| Name | Rounding function |
| Code name | ( ( <aNumber> ) roundToDigits: <Decimal Places> ) |
| Return data type | Decimal |
| Arguments | <aNumber> is a decimal <DecimalPlaces> is a number |
| Description | Rounds a number to the supplied number of digits. |
| Name | Truncate a Number |
| Code name | ( <aNumber> ) truncated |
| Return data type | Number |
| Arguments | <aNumber> is a decimal |
| Description | Applied to a number this function returns the integer part of the number. The fraction part is truncated. |
| Name | Modulo |
| Code name | ( #FUNC moduloOf: <value> factor: <factor> ) |
| Return data type | Decimal |
| Arguments | <value> and <factor> are numbers (integer or decimal). <value> must be non-negative. <factor> must be positive. |
| Description | Returns the modulo of the given value using the supplied factor. |
Perform Calculation #
Both P&C and LIFE:
| Name | Perform Calculation |
|---|---|
| Code name | ( #FUNC performCalculation: ‘<crule>’ ) |
| Return data type | Decimal |
| Arguments | <crule> is the name of the called calculation rule. |
| Description | If there is an already defined calculation that you want to use in another calculation you can use this function. It is meant as a shortcut. It would also be possible to repeat the (text of the) calculation again. Note therefore that the called calculation is performed in the context of the calling calculation. Any variables used in the called calculation will have a value related to the calling calculation. |
| Name | Perform Calculation (with Quarters) |
| Code name | ( #FUNC performCalculation: ‘<crule>’ quarterOffset: <quarter> ) |
| Return data type | Decimal |
| Arguments | <crule> is the name of the rule that should be called <quarter> is the offset to the current quarter. |
| Description | This function is basically the same than above. But you can additionally specify a quarter offset. Without a quarter offset the called calculation is performed with the current quarter. The offset is applied to the current quarter |