What’s New

36 minute read

Accounting General

SE-1781 - Alternative exchange rate tables used by Base Company - Aon

Aim of function

To support that 2 or more Base Companies can use different rate tables for the same primary currency. 

System Parameters / Security Affected

To enhance a FC rule dependent on the Base company, define as a new system parameter type in the ‘Base Company Specific Settings’, named e.g. ‘Exchange Rate Category’. Wherein two new drop-down field must be specified, one for Day Rate and one for Period Rate.

BaseCompanySettings_ExchangeRate.PNG

A new Domain Restriction - Accounting Alternative Exchange Rate Tables Used By Bae Company - is created. In case the user has this domain restriction assigned, then the only Selected user defined Day Rate/Period Rate values can be selected in the above new Base Company Specific Settings.

Domain_Restriction.png

Existing functionality affected

Enhancement of existing functionality.

Exchange Rates are stored towards a Primary Currency.

Exchange Rates can be stored as Day Rate, Period Rate and Year Rate.

SICS supports that we can have different categories of rates for each type. Seen to be applicable for Period and Year rates; End rates, average rate, budget rate, etc.

For Day Rates different categories can be defined, possibly due to different source. Recommended use is to have only one day rate exchange rate table per primary currency.

SE-3178 - Display trace information for all details under the balance layer - China Re

Aim of function

When the RP business is linked to an Intra Group Assumed Business (IGC IAB), the bookings take place from the source ORP will be copied to the linked assumed business. But, at present, for the SOA generated in the IGC IAB, there is not any accounting trace information between the IGC IAB and the source ORP, which makes financial reconciliation on both sides very difficult.

In this situation, the system introduces a new detail pairing type, so that the source/target details can be inspected from a detail on the IGC IAB / ORP respectively. On the business ledger, when a detail of the balance is highlighted, you can choose the option to view the source/target details.

System Parameters Affected

N/A

Existing functionality affected

  • View Target Details
  • View Source Details

Changed documentation

business_ledger/#view-target-details

business_ledger/#view-source-details

SE-3183 - Add a settlement association identifier between IGC worksheets - China Re

Aim of function

On the business partner ledger, when looking at the actual balance of an IGC IAB:

  • If the booking details of this balance has a detail pairing link to the source ORP, the system will display the worksheet id of the source detail on ORP in a new separate column.

  • If this balance is selected on the BP ledger, the system will enable a new option on the popup menu, named e.g. Source Settlement Status. When the new option is selected, a small dialogue window appears to show information about the source balance on ORP (e.g. Business Id, Worksheet Id, Currency, Balance Amount, Unsettled Amount and Settlement Indicator).

System Parameters Affected

N/A

Existing functionality affected

Business Partner Ledger:

When the booking details of the balance come from the IGC IAB, which has a detail pairing link to the source details on ORP. In a new separate column, the system will show the Worksheet Id of the source details on ORP.

screenshot-1.png

If the balance is selected, the system will enable a new option on the pop-up menu. A new window is displayed to show the information about the source balance on ORP when the new option is selected.

screenshot-2.png

screenshot-3.png

Changed documentation

bp_ledger/#11174-retrieve-business-partner-ledger-balances

bp_ledger/#11178-navigate-from-the-business-partner-ledger

SE-3185 - Improved Reporting Unit handling in Find Worksheet window - China Re

Aim of function

On the Find Accounting Worksheet window

  • Special Tab - a new check box ‘Show Business RU’ is added beside the existing check box ‘From Business’
  • A new column (named e.g. Business RU) will be visible in the balance container. When the existing check box ‘From Business’ and new check box ‘Show Business RU’ are selected, the system will populate the reporting unit(s) from business for the listed balances.

System Parameters Affected

N/A

Existing functionality affected

Find Accounting Worksheet

screenshot-1.png

Changed documentation

find_ws/#special-search-for-worksheets

SE-3186 - Add two more column to display create and close user on business ledger - China Re

Aim of function

Add the user names of the persons that created the worksheets and the persons that closed the worksheets respectively on the Business Ledger.

System Parameters Affected

N/A

Existing functionality affected

New fields added in the Business Ledger:

  • WS Created By
  • WS Closed By

  image-2020-09-24-14-58-59-218.png

SE-3187 - Enhance TW domain restriction apply to non proportional installment automatic bookings - China Re

Aim of function

Some reinsurance companies use the domain restriction to prevent users from closing the worksheets that are created by the same users through Closing Worksheet window and Instalments, but they want to allow users to close the worksheets that are created by the same users through Retrocession Orders (including Retrocession Account Orders, Retrocession Calculation Orders, Restriction Group Orders, and Restriction Estimation Orders.).

Currently, the system restricts both booking of Instalments (including Instalment orders) as well as the Retrocession orders. Therefore, a new option within this domain restriction, to exclude retrocession orders from this automatic closing restriction is to be implemented.

The new additional restriction ‘Closing worksheets automatically closed as part of a process, not for Retrocession Orders’ will be enabled only when ‘Closing worksheets automatically closed as part of a process’ is selected.

SE_3606_1.png

System Parameters Affected

N/A

Existing functionality affected

Domain Restriction: ‘Accounting Worksheet Created or Last Updated By - Closed by different user’

SE-3189 - Add Due date condition to filter the worksheet in retro cession calculation order - China Re

Aim of function

At present, when running the retrocession calculation order, retrocession estimation calculation order or retrocession calculation order group, the system provides the extraction criteria Last Booking Year and Period / Last Accounting Year and Period for the user to define the extraction rules for ‘as original’ worksheets.

However, for some insurance companies, these extraction criteria are not enough to meet business requirements. Some international business, to control the cash flow, the extraction criteria of the retrocession accounting is the Booking Year and Period combined with the Due Date. So, the system introduces a new extraction criteria ‘Due Date’ in addition to the existing ones.

SE-3189_RetrocessionCalculationOrder_create_20.3.png

System Parameters Affected

N/A

Existing functionality affected

  • Retrocession Calculation Order
  • Retrocession Estimation Calculation Order
  • Retrocession Calculation Order Group
  • Retrocession Calculation Order - Worksheet Exclusion Window

Changed documentation

retro_calc_order/#1321-create-and-run-the-retrocession-calculation-order

SE-3333 - Enhance TW – Closing worksheet wizard - China Re

Aim of function

The Accounting Reviewer want to see more information of the Worksheet that can bee seen the ‘Technical Worksheet’ Window in the ‘View Balance Details’ window. They also want to check the balance details of multiple balances together. These new functions help Accounting Reviewer make decisions easier.

System Parameters Affected

System Parameter/Accounting/Worksheet/Automatic Conversion to Our Share: When this parameter is selected, system allows check the balance details in 100% figures.

Entry Code Maintenance/Flags/Calculate Based on As of Date: When this tick box is set for Entry Code, and the balances include the Entry Codes calculated based on As of Date, System allows to check the Previous Amount and New Amount in the ‘View Balance Details’ window.

Existing functionality affected

Enhance TW – Closing worksheet wizard:

  • Introduce new Attributes in the ‘View Balance Details’ window: Received Date, Close Date, Business Partner Reference, Business ID, Insured Period, TA Process ID, Responsible Business Partner, Payment Partner, Base Company.
  • When selecting multiple balance to view balance details, SICS shows all Balance’s details information together
  • In the view balance details, user is able to see the New Amount and Previous Amount for the Entry Codes that are calculated based on As of Date.
  • In the view balance details, user is able to see 100% figures and our share. Same as what we display in actual details screen.

Changed documentation

manual_bookings_on_ws/#view-balance-details-from-the-worksheet-closing-window

SE-3743 - When select one member and enter the pairing screen, system can add all other group members of this remittance group automatically - China Re

Aim of function

For a Remittance Classification Group, when one of the group internal member is selected as the driving balance to do the balance pairing, in the pairing screen, the system can automatically add other group internal members of the same group into the pairing process.

screenshot-1.png

screenshot-2.png

System Parameters Affected

N/A

Existing functionality affected

  • Remittance Classification Group
  • Create Balance Pairing

Changed documentation

remittance_booking/#remittance-classification-group

SE-2305 - Reversal of Instalments/Adjustments functionality from Premium Installment Screen - Milli Re

Aim of function

The goal is to prevent one single user to Reverse Instalments/Adjustments from Accounting Premium window in Premium & Limit conditions and at the same time Close the worksheet. It is required that the reversal worksheet is kept in status Open and that a second user suppose to Close it.

System Parameters/Security Affected

A new option in the Domain Restriction “Accounting Worksheet Created or Last updated By - Close by different User” named “Restrict Closing of Reversal of Instalment/Adjustment Worksheet”

DomainRestriction.png

Existing functionality affected

The Reversal options for Instalments, Adjustments and Special Premium Acceptances in the Limit and Premium conditions.

A reversal worksheet affected by the above new domain restriction and stored as Open, is fully protected in the way that it cannot be updated by any user, other than updating the Booking Year/Period, the Booking Date and change status to Closed.

Reversal of Instalments/Adjustments functionality from Premium Installment Screen. Please see the attachment for more details.

Changed documentation

auto_prem_acc/#reverse-booked-instalments

auto_prem_acc/#1147-handle-special-acceptance-premiums-accounting

SE-2663 - Government Tax Validation framework - Swiss Re Zurich

Aim of function

The aim of the function is to introduce a more flexible tax calculation than today due to each country has its own tax requirements which need to be applied Possible to automatically book and validate Government Tax details for Assumed Businesses based on a new Government Tax Table and to link details (e.g. Premium and Government Tax on Premium)

Possible to split balances including ordinary details like premium and claim and Government Tax details

 

System Parameters Affected

Two new Accounting system parameter are introduced;

  • ‘Government Tax Framework in use’ to activate the new Government Tax functionality.
  • ‘Government Tax Table’ to define various rules for what to be booked and validated

 

Existing functionality affected

  • The existing VAT functionality is disabled when the new system parameter ‘Government Tax Framework in use’ is activated

Changed documentation

categorise_business/#view-business-partners

Changed documentation

introduction/#add-accounting-validation-information

Business

SE-2597 - Complete Segregation per Base Company - Aon

Aim of function

Often organizations have several (re)insurance companies sharing the same SICS installation.  These are legal entities and might not wish to have knowledge of each other, neither each other’s existence, nor each other’s business administration.   An example would be a company using captives of a high number and variety.  

SICS offers now a base company segregation facility, which is more extensive than the earlier access code segregation. 

Examples of features in the new base company segregation facility are:

A user is assigned a Current Base Company (mandatory)

A user sees only business (claims, accounting, etc.) of his/her assigned Current Base Company (mandatory)

A user can switch to another Current Base Company, but only if other granted base company have been assigned to this user (optional/customizable)

The system may hide company information of all other Base Companies than the user’s Current Base Company (optional/customizable)

The system may hide company information of all other Business Partners than the ones linked to the user’s Current Base Company (optional/customizable)

The system may hide company information of all other Insureds than the ones linked to the user’s Current Base Company (optional/customizable)

image-2020-09-05-17-07-24-522.png

image-2020-09-05-15-44-43-727.png

image-2020-10-02-13-59-27-492.png

image-2020-09-05-16-49-23-334.png

image-2020-09-05-18-36-20-772.png

screenshot-1.png

  

System Parameters Affected

System Parameter / Database and Systems:  Extend Base Company Segregation

System Parameter / Database and Systems:  Hide Insureds

System Parameter / Database and Systems:  Hide Business Partners 

System Parameter / Database and Systems:  Hide Base Companies 

 

Existing functionality affected

Maintain Business Partners

Maintain Insureds

Find Business

Create New Business

Change Life Cycle Status of Business

Renew Business

Maintain Business Partner Roles

Mass update of Business Partner Roles

Protect Business Manually

Protect Business Automatically

Protect Multiple Business Automatically

Find Business Groups

Mange Business in Business Group

Find Business to be renewed (Pre-Renewal function)

Find Insured Object Cessions

List Cessions linked to Insured Object

Perform Accumulation Control of Insured Object

Perform Accumulation Control of Insured Peril Risk Zone

Mass Update Business with Commutation Information

Find Claims

Create New Claim

Manage Claims in Claim Group

Find Claim Programs

Create New Claim Program

Find Linked Business and Claims in Claim Program

Manage Claims in Headline Loss

Perform Business Partners Facultative Analysis

Find Accounting Worksheets

Create Remittance Worksheet

View Pending Remittances

Find Accounting Data on Business Partner Ledger

Find Accounting Orders

Create new Accounting Order

Run Retrocession Accounting Due Orders

Mass Update Business Partner Balances

Mass Update Reserve and Deposit Details

View Preliminary Bookings

Mass Update Closed Balances

Mass Update Open Balances

Mass Update Open Worksheets

Revaluate Functional Currency

Mass Pairing of Remittances

Mass Pairing of Paid Remittance

Mass Update of Estimation Complete

Mass Update Multi GAAP Stop Calculation

Mass Update Revised EPI

Mass Update Estimate Settlement Indicator

Monitor Accounting Order

Extract Balances for Account Statements by Batch Job

Manage Billing Statements by Batch Job

Find Items by Quick Find from Desktop Bar

Maintain Reporting Units

Maintain Entry Codes

Maintain System Parameter

Manage Security

Maintain User Preferences

SICS Cede Specific Functions not supported

SICS Life Specific Functions not supported

Changed documentation

inter_bp_relations/#384-view-base-companies-assigned-to-partner

Changed documentation

inter_bp_relations/#384-view-base-companies-assigned-to-partner

Changed documentation

inter_bp_relations/#384-view-base-companies-assigned-to-partner

Changed documentation

set_user_prefs/#263-define-default-base-companies-settings

SE-3190 - Import multiple protected assumed business to outward cedent’s contracts - China Re

Aim of function

To speed up the protection assignment for a list of assumed businesses to a given treaty Outward Cedent’s Contract (section), it is now possible to load the referenced assumed businesses from an external file to SICS.  This is initiated from the Protected Assumed Business List of the OCC and loads the referenced assumed businesses with necessary information.

screenshot-1.png

System Parameters Affected

System Parameter / Business / Miscellaneous: Import Protected Assumed Business on Treaty OCC

Existing functionality affected

Protect Business 

Changed documentation

protect_business/#assign-protected-business-by-upload

SE-3236 - Customize giving warning before replacing inactive business partner with active merger parent - China Re

Aim of function

The automatic replacement of an inactive business partner with its active merger parent, which the system does at at renewal, copy to new business and change of life cycle status of a business, was earlier only made after a question to the user.  The user could then reply yes or no to this.  As some companies wish to speed up this these processes, the system now allows setting up the system to replace the inactive business partner without any question the the user. 

System Parameters Affected

System parameters / Business / Copy/Renewal: Warn before replacing inactive business partner

system_parameter.jpg

Existing functionality affected

Renew business manually

Mass Renew Business

Copy to new business

Change business life cycle status

Changed documentation

offer_quotation_process/#5101-change-life-cycle-status

renew_business/#renewal-details

SE-3676 - Auto replace inactive business partner with active during Mass Renewal - China Re

Aim of function

The automatic replacement of an inactive business partner with its active merger parent was before only available for manual renewal, copy to new business and change of life cycle status of a business.  Now, it is available also at mass renewal of business.

Mass_renewal.jpg    

mass_rw_msg.jpg

System Parameters Affected

System parameters / Business / Copy/Renewal: Warn before replacing inactive business partner

Existing functionality affected

Mass renew business in Reinsurance Program

Mass renew placements in Outward Cedent’s Contract

Mass renew business in Cedent’s Program

Mass renew business in Protection Program

Mass renew policies Insured’s Contract

Mass renew business in Master Agreement

 

Changed documentation

renew_business/#5114-mass-renew-business

Claim, NP Recovery, Cede

SE-1886 - Calculation details indexed Recovery - DXC

Aim of function

Improve the understanding of how the indexed recovery is calculated, by providing details of index points, index ratios, and index adjusted values.

The Calculation Details Overview provide a list of claims, with the current accumulated position per claim, whereas the Breakdown list provide the same list of claims, displaying the adjustments per Year and Month, and index adjusted values.

 

System Parameters affected:

None

 

Existing functionality affected

Recovery order for Protection Program

Recovery order for Single OCC 

Changed documentation

recovery_calc_order_for_prot_prog/#view-recovery-details-breakdown

Changed documentation

recovery_calc_order_for_prot_prog/#calculation-details-overview

SE-3217 - Proportional Risk Unit Group protection assignment - remaining enhancement - DXC

Aim of function

Providing remaining enhancements/corrections related to Proportional Risk Unit Group functionality

Improving the RUG Protection Assignment display and functionality

Improving support by Preliminary Bookings and Preliminary Bookings Correction orders

1_View_Proportional_Risk_Unit_Group.png

2_Potential_Facultative_Outward_Cedent's_Contract_Protections_for_Prop_RUG.png

3_Prop_RUG_Protection_Assignment_and_linked_policies.png

4_Policy_Light_with_link_to_RUG_Protection_Assignment.png

5_Multi_RUG_Auto_Protection_order.png

6_New_Scheduler_Job_Step_Type_Multi_RUG_Protection_Assignment.png

7_Risk_Unit_Group_Protection_Assignment_Proposal_and_linked_policies.png

8_Find_Risk_Unit_Group.png

System Parameters Affected

Business/Protection:

• Exceeding Proportional Program Limit Restricted

• Exceeding Combined Program Limit Restricted

• In Force functionality enabled/Allow exceeding prop program limit

• Proportional Risk Unit Group - Protection calculation frequency

Existing functionality affected

Find Business Groups

Assign/Remove members

Proportional Risk Unit Group w/Per Group option

Proportional Risk Unit Group Protection Assignment

Policy Light Protection Assignment

Multi RUG Auto Protection

Scheduled Jobs

Preliminary Bookings

Preliminary Booking Corrections

Cede Interface

Web service

createPolicyLightBusiness

updatePolicyLightBusiness

renewPolicyLightBusiness

Security

eMessaging

SE-2341 - Improvements eMessaging Settlement screen - Partner Re

Aim of function

Items under the Financial Account to be displayed in a grid view opened via a menu option.

The grid view has the layout and sort pop-up menu where the user can change the column view, sort, find, open the items in spread sheet, like the other grid views, e.g. Find Business/ Find Claims/ Find Accounting Worksheet.

Additional Column ‘Notes’ along with ‘Item Number’, ‘Broker Reference’, ‘Currency’, ‘Amount’, ‘Status’ that are available in the current list view.

System Parameters Affected

NA

Existing functionality affected

The message highlights tab of a Settlement message has three frames. The first shows message identification, is common to all message types. The second shows message type elements, and the third shows referenced SICS objects. 

Frame three (SICS References) shows the references between message elements and SICS objects. There are two sub-frames. 

A frame on the left hand side shows a tree structure, with Message as the root, and Financial Account and Financial Account items from the chosen message as leaves. The right hand frame will show specific references from the chosen leaf from left hand frame. The fields (selective) in right hand frame are editable if the message is in the status error or validated.

SE-2997 - Enhanced Due Date Setting for Claim Worksheets booked via eMessaging Module - Swiss Re Zurich

Aim of function

We want to have a more flexible way of setting Due Date on a claim worksheet created via eMessaging.

In addition to existing functionality, adding a number of days, moths or years to the message as-of-date, we implement the possibility to add a number of days, months or years to the message creation date.

In eMessaging Insured Period Information, we have added a drop down with values from new reference data code 01229 ‘Claims Due Date Basis’:

  •  Message As Of Date
  • Message Creation Date

 

System Parameters Affected

‘Claims Due Date Additional Days’

We have added a drop down with values from new reference data code 01229 ‘Claim Due Date Basis’:

  •  Message As Of Date
  • Message Creation Date

Existing functionality affected

ACORD Claim Movement message

eMessaging Insured Period Information

Changed documentation

info_on_business_insured_period

Life

SE-2839 - Premium rate at policy benefit transaction level - Africa Re

Aim of function

To be able to use the premium rate or amount from the cession benefit transaction to calculate the premiums, thereby overriding the premium rate or amount that has been defined on the PM condition of the business section

System Parameters Affected

Additional parameters under ‘Calculated Values’ on the Prop Premium Calculation Rule 

 

Calculated_Values_Rate_From_Cession.png

 

Existing functionality affected

On the PM condition of the business:

A new flag ‘Rate/ Amount from Cession Benefit Transaction’ is available. When this is selected, the user will be prompted to select a Premium Calculation Rule

The Premium Calculation Rule is set on the system parameters under ‘Prop Premium Calculation Rule’ using one of the calculated values as described in the previous section

When the PM condition is defined as such, the premium ACI will be calculated using either the Premium Rate from the Cession Benefit transaction or the Premium Amount from the Cession Benefit transaction when the value on the transaction is defined as a value greater than 0

 

PM_Condition_Rate_From_Cession.png

 

On the Cession Benefit Transaction: 

**On the Group Information Tab on the cession benefit, two new fields ‘Premium Rate’ and ‘Premium Amount’ are available. When the value from these fields is greater than 0, this will be used to calculate the premiums. 

Please note that this will follow the Rate or Amount option that has been selected on the PM condition

If the flag ‘‘Rate/ Amount from Cession Benefit Transaction’ is not selected on the PM condition, then the values in these fields will be purely informational

Cession_Benefit_Group_Info.png

SE-3674 - Implement Webservices importSubSOA and multipleImportSubSOA - China Re

 

Aim of function

To be able to import multiple Sub SOA files through webservices for more than one business and to be able to validate the results before the input is committed and run several uploads concurrently

System Parameters Affected

None

Existing functionality affected

New webservice to import multiple Sub SOA for one or multiple business

The service will accept the list of  SubSOA  and follow  current “importSubSOA” function to generate the TW of business one by one. If one of the TW failed because of validation or other error, the whole transaction will fail and return error message as output.

SE-1261 - To support the They Bill Order when the Summary Accounts are not in use - DXC

Aim of function

To be able to create and process They Bill Order when the system parameter ‘Use Summary Accounts in Technical Worksheet’ is NOT in use

System Parameters Affected

New System Parameter under Accounting- Worksheets will be available for selection when the system parameter ‘Enable Summary Account on Technical Worksheet’ is not available

TheyBill_SystemParameter.PNG

Existing functionality affected

A new flag ‘Summary’ on the Technical Worksheet will be available on They Bill Administered business. Selecting this flag will allow the user to enter the Summary details for each head of account from the Statement of Account sent by the cedent

SummaryFlag_TW.PNG

 

The summary bookings for each entry code will be created with the Summary flag on, and the They Bill order will then pick up the cession and claim ACIs and validate them against the Summary bookings. 

 

 

 

 

SE-3270 - To calculate the profit commission through a Profit Commission Calculation Order remaining testing - DXC

Aim of function

The aim of this case was to continue the testing of the profit commission calculation order

System Parameters Affected

None

Existing functionality affected

Profit Commission calculation order

 

SE-3401 - Life MTK Testing : Test all Tabs/conditions on Business - DXC

Aim of function

To update the MTK loader to support several fields on the Business that were introduced through recent enhancements and some existing fields in conditions were not currently supported

System Parameters Affected

None

Existing functionality affected

All the fields on the business and the business conditions will now be supported by the MTK loader

SE-1031 - Multiple Premium Rate Table - Heng An Standard Life

Aim of function

To be able to attach more than one premium rate table to an inward or outward business and apply a calculation rule that will use the values from all the tables to calculate the premium on the cession or retrocession

System Parameters Affected

The option to select Multiple Premium Rate tables will be available on the business PM condition only when the below system parameter is selected on Business–> Conditions

image-2020-10-22-10-00-05-547.png

Prop Premium Calculation Rule:

**On the Prop Premium Calculation Rule option, a calculation basis rule can be defined using the following function

   PropPremium_CalculationRule.png

Multiple Prop Premium Rate tables can be selected and included in a calculation rule

Eg: The below calculation rule uses three rate tables and applies a multiplication factor to the calculated rate. This rate will then be applied to the Sum at Risk on the cession benefit to calculate the premium

MultiPremiumRateTable_Rule.png

 

  

Existing functionality affected

When the system parameter ‘Allow Multiple Premium Rate Tables’ is selected, it will allow the user to select the option ‘Multi Premium Rate or Value’ on the PM condition Rate Amounts Option and select a calculation rule to be applied to the rate tables. 

image-2020-10-22-11-00-37-670.png

Note: It will be the user’s responsibility to ensure that the tables attached to the business condition match the tables referred to in the calculation rule since the list of tables on the business condition is informational and the calculation will be done based on the tables referred to in the calculation rule

 

Aim of function

To be able to capture more Group Information on the cession benefit and use some of those parameters in calculation of premiums

System Parameters Affected

Additional Cession Variables that refer to the Group Information Tab as described in the below section have been introduced under the Prop Premium Calculation Rule 

Below is an example of a Prop Premium Calculation Rule that has been created using the additional cession variables

image-2020-10-06-12-56-55-351.png

Existing functionality affected

 

Prop Premium Condition:

In addition to the existing options of Percent, Permille and Perten, it is now possible to define the rate as a factor 

An additional radio button is made available to specify whether the defined rate is to be applied to the Sum At Risk Reinsured or to any other amount i.e Per Other Basis which will use the amount in the field ‘Premium Calculation Basis’ on the Cession Benefit (as seen in the screenshot in the section below)

 

image-2020-10-06-13-02-10-633.png

 

Cession Benefit

A new tab ‘Group Information’ is now available on the Cession Benefit where additional details pertaining to the individual within the group or the overall group can be captured.

The fields within this tab can be referenced to in the Prop Premium Calculation Rules on the system parameters  

For example, the premium calculation rule referred to in the above section will use the values from the fields ‘Group Scheme Number of Lives’ and apply the fixed rates defined within the rule to the  rate from the Lookup table ‘Construction Costs’ that is referenced within the rule

 

    Group_Info_Tab.png

 

 

 

SE-2777 - Enhance RPO order to validate additional limits - Heng An Standard Life

Aim of function

To be able to validate the maximum allowable occupation class and a maximum EM percentage on the outward cessions while running the RPO

System Parameters Affected

None

Existing functionality affected

Additional Limits are defined on the Limit Condition OCC to specify the maximum Occupation Class and the maximum Extra Mortality percentage that will be allowed as per the terms and conditions of the contract. When the RPO is run and the cession that has been picked up by the RPO falls outside the allowable Occupation Class range or the EM% exceeds the limit, then the cession will not be retroceded and will be listed in the failed assignments with the reason 

Note: The maximum Occupation Class will be determined by the value defined in the Search Priority of the Reference Data ‘Occupation Class’.

 

SE-2881 - Standalone Retrocessions with Sequential Retroprocessing - Heng An Standard Life

Aim of function

a) To be able to assign a cession benefit identifier for all the cession benefits within the benefit group

b) To be able to sequentially process retrocessions when the ‘standalone retrocessions’ functionality is in use

System Parameters Affected

The following new system parameters are available

Under Cessions :

image-2020-10-22-09-29-04-165.png

   

Under Base Company Specific Settings- > Retrocession Basis:

image-2020-10-22-09-29-26-977.png

  

Existing functionality affected

 

**When the system parameter ‘Cession Benefit Identifier Series in use’ is selected, each cession benefit within the cession will be assigned an identifier series which is the cession idenfitier and a suffix that starts with -1.

All cession benefits will have the Coverage Indicator set as ‘Unknown’ by default

When the coverage indicator is set as either a Base or Rider and the cessions are created through the loader, the benefit identifier will be assigned first to the cession benefit that has the coverage indicator as ‘Base’ and then each ‘Rider’ and then ‘Unknown’

These identifiers will not be available on the cession benefit view and will be used only when sequentially processing the retrocessions 

When the system parameter ‘Method of Retrocession is Reinsured sequentially in excess of maximum retention’ is selected, the cession benefits that have been accumulated on per life, per benefit will be sequenced in the following order and the retroprocessing will be done sequentially

  • Reinsurance Start Date
  • Benefits that have the Coverage Indicator as Base
  • Benefits that have the Coverage Indicator as Rider/ Unknown/ Blank
  • When there is more than one benefit with the same Reinsurance Start date within the sequencing in points 1 to 4, the cession benefits will be sequenced based on the Cession Benefit Identifier 

(Please note that for the functionality to work as described above, it is expected that both the system parameters mentioned are selected and the cessions are created with the ceded flag. Though the system parameters are independent, it is not suggested that they are switched on independently or used without the ceded flag on the cession as per the current implementation)

 

SE-2883 - Flexible Claim Recovery Calculation Rules - Heng An Standard Life

Aim of function

The aim of this enhancement is to process the claim recovery for a ceded paid claim by applying a flexible claim recovery calculation rule where the claim liability is not the sum reinsured

System Parameters Affected

A new system parameter under Business ‘Claim Liability Calculation Rule’ is available

It is possible to define the Claim Liability Calculation Rule here

eg:

ClaimLiability_Calculation.PNG !

Claim recovery = claim paid amount * current period retro amount / current period SAR where the ‘current period retro amount’= Sum at Risk+ Reserves on the inward cessions

The retroceded sum at risk would have been processed using the Sum at Risk on the inward cession here, but for the claim recovery, the reserve on the inward cession would also be included in the calculation 

Existing functionality affected

On the SR condition of the OCC, when the Claim Liability Basis is selected as ‘Not SAR Reinsured’ the option to select a Claim Liability Calculation Rule will be available

The Calcualtion Rule that has been defined on the system parameters as described above can be selected and this rule will apply for all the claim recoveries done for cessions that have been created against this section of the business

SumAtRisk_Condition.PNG !

 

Please note that this functionality is currently applicable only to outward claims with the status of Ceded Paid

SE-2885 - Reversals and Backdated Transactions on Retrocessions - Heng An Standard Life

 

Aim of function

To be able to enter a transaction number for each cession benefit transaction manually or through the cession loader and to be able to reverse specific transactions on the cession benefit and the corresponding outward cession benefit by referring to this transaction number 

System Parameters Affected

 

 A new system parameter on Cessions is now available

image-2020-10-22-12-16-30-240.png

 

Existing functionality affected

 

On the cession benefit transaction:

A new field to input (or upload) a unique transaction number for each transaction is available. It will be defaulted to the amendment number of the transaction or updated sequentially on each transaction and can be overridden while creating the amendment. The cession loader output pattern also now contains an optional field ‘Transaction Number’

In the below screenshot, the SICS amendment number is Renewal (1), but the transaction number relevant to this cession that has been brought in from the core systems has been captured here as (4)

 

image-2020-10-22-12-21-44-615.png

 

A new transaction type ‘Adjustment Reversal’ is available on the cession benefit as an amendment transaction

It will be possible to refer to specific cession benefit transactions using the transaction number and process Adjustment Reversals of that transaction

image-2020-10-22-12-23-17-112.png

The Adjustment Reversal transaction will reverse the ACIs of the transaction and create a corresponding Adjustment Reversal on the linked retrocession transactions where available

No other field on the cession will be reversed and there will be no readjustment of the Sum at Risk based on these reversed transactions. 

When more than one Adjustment Reversal transaction has to be processed, it will need to be done sequentially from the last active transaction.

Please note that the Adjustment Reversal transaction will be available only when the system parameter ‘Allow transaction number on cession benefits’ is selected. It is suggested that this system parameter is not selected when the Ceded functionality (i.e the ceded flag is selected on the cessions) is not in use

SE-2902 - Web-services for various functions - Heng An Standard Life

Aim of function

To be able to use Webservices for the following functions in SICS Life

Update Deduction Condition

Update Proportional Premium Condition

Update the Sum at Risk Condition

Update the Reinstatement Condition

Update the Profit Commission Condition

Update Agreement Clause Condition

System parameters affected

None

Existing functionality affected

Update Business Conditions through webservices

SE-3321 - Support for loading joint life cessions through the cession loader - Heng An Standard Life

Aim of function

To be able to create joint life cession benefits through the cession loader

 

 

System Parameters Affected

A new repeatable block is available on the cession output pattern is available in addition to the existing Joint Life related output pattern fields for LIFE_2

JointLife_OutputPattern.PNG

 

 

Existing functionality affected

When the above output pattern is used, a joint life cession benefit will be created on the joint life cession

The existing output pattern fields can still be used to create a Joint Life cession with each cession benefit created on individual lives

MG & Reserve Orders

SE-3272 - Enhance updateUnderwritersEstimates web service to validate Estimation Complete flag - China Re

Aim of function

The client want to use updateUnderwritersEstimates web service to load Adjusted Estimates, and have requested a couple of additional features to the web service. We have added the following two new elements in the SOAP Message:

  • checkEstimationComplete - When included in the message and set to ‘true’, the web service will NOT create any new Adjusted Estimates, or recalculate existing estimates on business sections where the Estimation Complete flag has been set. I.e. same functionality as the Underwriters Estimation Calculation Order
  • updateEstimate - When included in the message and set to ‘true’, the web service will update existing Adjusted Estimates, instead of creating a new Adjusted Estimate. If dateOfEstimate is given in the message, the Adjusted Estimate with this As At Date is updated. If dateOfEstimate is NOT given in the message, the latest Adjusted Estimate is updated.

update_Underwriters_Estimates.png

System Parameters Affected

N/A

Existing functionality affected

Process the updateUnderwritersEstimates web service

 

SE-2860 - Support stop calculation on estimation item/period level in Multi GAAP - DXC

Aim of function

When calculating Period Estimates, the general functionality is to always recalculate all Estimation Items and periods. Exceptions are:

  • If the values has been manually overwritten, then a flag is set to prevent recalculation
  • If the Complete flag is set on the Estimation item, in case this item will not be recalculated for any periods (depending of a global system parameter).

However, some times it may be relevant to stop the calculation on all or some Estimation Items for some periods, e.g. on all closed periods.

We have therefore implemented an option to stop the calculation for some/all estimation items for specific periods.

The new functionality is controlled by new Multi GAAP / General system parameters

MG_General_System_Parameters.png

Here you can setup the system to stop the calculation for flagged Estimation Items and Periods, or for all Estimation Items on closed periods. When Stop calculation for Closed Periods are selected, the Last Closed Period must be defined in the system parameter.

In case “Stop Period Estimation Calculation On Flagged Estimation Items / Periods” is used, a new mass update has been added within Periodic Functions, to set the ‘Stop Calc’ flag on the required Estimation Items and Periods.

Stop_Calculation_Mass_Update.png

In Period Estimates, it is possible to see the Stop Calc flag in a separate view.

Period_Estimates.png

When “View Stop Calculation” is selected, the Ow. column (Overwritten) is replaced with the StopCalc column.

This view is only available in View mode, and the flag cannot be set in the Period Estimates window.

System Parameters Affected

New Multi GAAP / General system parameters, as described above.

Existing functionality affected

Calculate Period Estimates

Run Multi GAAP Recalculation Order

View Period Estimates

Changed documentation

calc_period_estimates

Changed documentation

period_estimates

Changed documentation

periodic_function/#multi-gaap-stop-calculation-mass-update

SE-3281 - Populating Original Base Company on bookings created by UPR Order - Houston International Insurance Group

Aim of Function

Premium bookings on outward businesses can have different Base Companies and different Original Base Companies.

The Unearned Premium Reserve Order aggregates the source premium by various elements, such as Currency, Section, Accounting Classification and Base Company. Unearned Premium Reserve (UPR) is then calculated on each aggregated group.

Original Base Company is not an element in the aggregation, and UPR is therefore not populated on the UPR details.

This enhancement adds Original Base Company as an element in the aggregation of Source premium, and populates the Original Base Company on each UPR detail. The UPR will then have the same Original Base Company split as the source premium.

System Parameters Affected

None

Existing Functionality Affected

Unearned Premium Reserve Order

Other

SE-2917 - SICS4 20.3 changes supporting integration into SICS5 - DXC

Aim of function

Make non-functional changes in SICS4 that will support/ease updating SICS5 with the latest SICS4 contents.

System Parameters Affected

None

Existing functionality affected

Functionally, none.

SE-3322 - Introduce Document Category in DMSI - DXC

Aim of function

SICS provides a set of Index attributes to support classification and/or indexing of documents. The attributes are key information like Business ID and Accounting Period.

This new Document Category will enhance classification of documents in more detail with in a specific area of SICS

System Parameters Affected

N/A

Existing functionality affected

Document Management System

SE-3611 - Support for Hi DPI monitors - DXC

Aim of Function

Improve the clarity of the displayed windows when a High DPI monitor is in use. This includes displaying a sharper font and sharper icons.

Increasing the resolution of a monitor without increasing its physical size serves to increase the the DPI (dots per inch) that can be displayed. Historically there were 2 scenarios for handling this higher resolution:

  • If run at the monitor at its full resolution, the images shown on screen are very sharp but very small and difficult to read.
  • If you run the monitor at a lower resolution, the images become larger but increase in fuzziness as each pixel shown becomes larger.

To counteract this, Windows & macOS introduced a scaling setting. This scales up the displayed images to a size that is readable but still using the full resolution of the monitor. Text appears larger and more legible, and is very sharp since it is using the full resolution available. However, scaled up images look blurry unless higher resolution versions are supported by an application.

SICS now supports display scaling at 100% & 200% accurately with both fonts & icons displayed at their highest fidelity. Other scaling percentages will work but may introduce some blurriness as the icons are rescaled. We will continue to improve the look of the icons as our capability grows.

Windows 10 scaling setting:

WindowsScalingSettin.png

SICS_HiDPI_Composite.png

System Parameters Affected

None

Existing functionality affected

All windows & icons

SE-3121 - ADH - Configure the Excel import compression ratio security limit and enhance the error shown to user - Swiss Re Zurich

Aim of function

An .xslx file is actually a kind of compressed/zip file. The compression ratio will be 1 (no compression) or less (the more compressed the file is, the smaller the ratio will be). Small ratio means high compression. When importing an Excel file into ADH, a security exception will be raised if the compression ratio is very small (i.e. a very tight compression). By default, the limit for raising a security exception is a compression ratio of 0.01.

  • To avoid the security risk error due to high compression, configuring the Excel import compression ratio security limit through a new ADH system parameter.
  • On import of .xslx file in ADH, a more meaningful error message will be displayed to the user if there is a security risk error.

System Parameters Affected

ADH Document Handling - Processing Options - Excel Compression Ratio Limit

  ADH_System_Parameters.png

Existing functionality affected

Automated Document Handling

SE-3168 - ADH - Domain Data block FGU enhancements - Swiss Re Zurich

Aim of function

  • To check if a claim has FGU, a new output field hasFGU is introduced on Claim Section Domain Data block. The output will be ‘true’ if the FGU indicator is true for the identified claim section.

                 ADH_Claim_Section_hasFGU.png

  • The Section, Claim Section, Partner, Claim Ledger Figures and FGU Advisory Figures Domain Data blocks currently have a performance-related limit of 10 items/records which is not sufficient in some cases. So a new input field  Index Limit is introduced to Section, Claim Section, Partner, Claim Ledger Figures and FGU Advisory Figures Domain Data blocks. If a numeric value is provided to this input field, this will set the limit of the database query, and overrides the default of 10.

                 ADH_Mapping_Index_Limit.png

  • Sorting logic based on as-of-date (most current first) is implemented for the FGU Advisory Figures Domain Data block.

  • In Entry Code Constant block properties, sorting is implemented of Entry Code drop down list.

                 ADH_Mapping_Entry_Code_Sorting.png

System Parameters Affected

None

Existing functionality affected

ADH Transformation Mapping

SE-3397 - ADH - Claim Section Domain - additional input fields - Swiss Re Zurich

Aim of function

  • To fetch the correct claim, additional input fields mentioned below are introduced in the Claim Section Domain Data block 

         → Claim Reference type

         → Loss Name

         → U/W Year (Underwriting year)

         → Date of Loss From Date

         → Date of Loss To Date

         → Partner Role

         → Partner Object

                            ADH_Mapping_Claim_Section_Domain_Data_Block.png                            

  • Introducing new output field Partner Object, in Partner Domain Data block. This new output field may be mapped to the Partner Object input field of Claim Section Domain Data block.

                            ADH_Mapping_Partner_Domain_Data_Block.png

System Parameters Affected

None

Existing functionality affected

ADH Edit/View Mapping

SE-3415 - ADH Versioning - Swiss Re Zurich

Aimof function

  • To uniquely identify version comparisons in mappings between databases, a visual ID will be assigned for the mappings in different databases to check if the mapping has the same/identical contents. So a calculated fingerprint on the mapping will be displayed in the UI which is a 7-character value using characters 0-9 and a-z, without storing this value in the database. The 7-character value reflects the essential contents of the mapping.

                 ADH_Mapping_Fingerprint.png

  • To uniquely identify version comparisons in output patterns between databases, a visual ID will be assigned for the output patterns in different databases to check if the output pattern has the same/identical contents. So a calculated fingerprint on the output pattern will be displayed in the UI which is a 7-character value using characters 0-9 and a-z, without storing this value in the database. The 7-character value reflects the essential contents of the output pattern.

                 ADH_Output_Pattern_Fingerprint.png

  • To have a adequate check when importing a mapping between databases, if the output patterns used by the mapping in the new environment are the same as in the original, a confirmation message will be displayed with if there is a list of unmatched Output Pattern fields, if the connected Output Pattern fields in the source database (and in the exported .xml file) do not find a matching (same name and same hierarchical structure) Output Pattern field in the target database. Such non-matching connections will be dropped.

                 ADH_Import_Mapping_Missing_Output_Fields_Confirmation_Message.png

System Parameters Affected

None

Existing functionality affected

ADH Transformation Mappings

ADH Output Patterns