What’s New
Accounting General
SE-4306 - Calculate preliminary bookings at Upload of Protected Assumed Business from Outward Cedent’s Contract side - China Re
Based on the requirement of SE-3190, China Re also hope that system can transfer bookings from IAB to OCC automatically when upload protection assignments on OCC. If the selected IAB has bookings, they hope that system can generate bookings on OCC automatically during the upload. Currently, the transfer only happens when we link OCC with a protection programs.
SE-5013 - Show allowable values of section and accounting classification in ‘View Balance Details’ screen - China Re
After CR SE-3333, the Accounting Reviewer can see more information of the Worksheet that can bee seen the ‘Technical Worksheet’ Window in the ‘View Balance Details’ window.
Now they also want to see the allowable values of “section” and “accounting classification” in combo-boxes in the table in the ‘View Balance Details’ screen. (These two combo-boxes are cascade operation.) They can change the value of these two combo-boxes, but system will not save the changes.
The purpose of this requirement is that, the Accounting Reviewer wants to verify if the data input is correct. Also they hope to verify the information of section and accounting classification.
SE-5014 - Do not allow update business insured period start date and underwriting year if it has unsettled bookings/estimates - China Re
If one business has bookings or estimates on its technical worksheets (including IAB and OCC), when we try to update its insured period start date and underwriting year, we need to settle all the bookings and estimates first. Otherwise system does not allow the udpate.
SE-5107 - Assign review technical worksheet right but no edit right for users - China Re
Now in the worksheet search page, if user does not have the access right to edit worksheet (user case: “uAccountingTechnical”), but has the access right to review worksheet (user case “uAccountingTechnicalWorksheetClosing”), after user double click the worksheet, system will only show a message to say that the user dose not have access right to edit worksheet.
China Re want to enter the review worksheet screen under this condition. The new requirement is just the same logic as the process to open a worksheet in business T condition.
SE-3436 - PBR ‘Wrong Financial Period’ Remove Manual booking for Non-Prop Treaty businesses from trigger - Swiss Re Zurich
SE-3910 - Mass Pairing automatic update of paid - Swiss Re Zurich
SE-4203 - Enhance FastCreate Technical and Claims Worksheet with Split Percentage - Swiss Re Zurich
SE-3315 - Support New Amount import and Replacement Values via Import TW from Spreadsheet - Triglav
Aim of function
Adding the new column named “New Amount” in the related to SICS functionality ‘Import Technical Worksheet from Spreadsheet’.
The New Amount is an optional column and will activate the replacement value function on the worksheet, i.e. the Replacement Values box is ticked, and the Previous Amount and New Amount columns are displayed. The New Amount given in the spreadsheet will be set in the New Amount column for this detail and the Amount column will be calculated according to existing online functionality.
Normally the Amount is mandatory when the spreadsheet is validated, but if the Amount column is empty for detail in the spreadsheet the system should still accept this detail as long as the New Amount is present, i.e. either Amount or New Amount is mandatory.
Exceptions when a spreadsheet is imported:
If both the Amount and the New Amount is given in the spreadsheet, the system will ignore the New Amount value. If the Entry Code on the actual detail does not allow Replacement Value, the system will not use the New Amount value given in the soap which is also according to online functionality, i.e. the user can give the New Amount in the worksheet but the system will just ignore it.
System Parameters Affected
None
Existing functionality affected
The online functionality of Replacement Value wherein the user needs to update the new amount manually. Now, the user able to update the New amount in the “Import Technical Worksheet from Spreadsheet” spreadsheet itself and which will automatically activate the replacement value online functionality.
Changed documentation
Business
SE-5169 - Restrict Edit of Business by Business Administration Restriction - DXC
Aim of function
System Parameters Affected
Existing functionality affected
SE-475 - Capture multiple non-proportional facultative protections simultaneously - SOMPO JAPAN INSURANCE INC.
SE-3749 - Manage Bifurcation groups - Swiss Re Zurich
SE-932 - Show Premium Rate on Placement List of non-proportional outward cedent’s contract - Unive Verzekeringen
Claim, NP Recovery, Cede
SE-2567 - Creation and reversal of Technical Worksheets from Open Claim Worksheet - Allianz AG
SE-521 - Cede Life Claim Recalculation - DXC
SE-2797 - Streamlined Period Closing - Part 3 - DXC
SE-4070 - Recovery Orders - Auto Test - DXC
- Identify test scenarios.
- AmAg/HIIG
SE-4078 - Proportional Risk Unit Group protection assignment - remaining enhancement - DXC
Aim of function
Providing remaining enhancements/corrections related to Proportional Risk Unit Group functionality.
System Parameters Affected
Existing functionality affected
SE-1928 - OrigRespPartner Type ahead limitation - Renaissance Re
Aim of function
OrigRespPartner Type ahead limitation
System Parameters affected
Existing functionality affected
SE-1929 - Display of bookings on Statistics Screen - Renaissance Re
Aim of function
Display of bookings on Statistics Screen
System Parameters affected
Existing functionality affected
SE-1884 - Signed Share and Sections-Limits on Claim search - Swiss Re Zurich
SE-3414 - SICS to validate AAD entry codes against missing AAD condition - Swiss Re Zurich
Aim of function
Use the accuracy framework to raise errors if the worksheet contains entry codes in any of the “Annual Aggregate Deductible” sub categories, and corresponding condition is not present on insured period.
System Parameters affected:
Claim Accuracy template
Processes affected:
Create Claim Worksheet
process Claim Movement message
SE-3435 - Accuracy validation - Positive Loss Reserves and Loss Expense - Swiss Re Zurich
SE-3510 - SICS to validate and calculate expected Reinstatement Premium based on booked figures for a given insured period - Swiss Re Zurich
SE-3512 - Combined Annual Aggregate Limit - Swiss Re Zurich
Aim of function:
Ensure that the (Annual) Aggregate Limit captured as the “Combined Aggregate Limit” on Main Section, is the actual Aggregate Limit across all sections, and should not be changed on child sections. Similarly, the Reinstatement condition should not be changed on child sections.
System Parameters:
Validate Combined Annual Aggregate Limit
Processes affected:
Create conditions on child section
Calculate Reinstatement
claim worksheet validations
Claim Accuracy validations
SE-4446 - Accuracy Validation comparing the current worksheet type with the Calculation Rule on the RIP Condition - Swiss Re Zurich
eMessaging
SE-3667 - APREF - eMessaging Acord verification - DXC
Benefit
Verify support for APREF used in the French and Italian Market.
Acceptance Criteria
-
Source database created with outward contracts that support sending defined messages,
-
Source database created with inward contracts that can receive defined messages.
-
Create messages to be sent.
-
Process received messages.
-
Create auto test suite for sending
-
Create auto test suite for receiving.
SE-4979 - Government Tax Validation Step 3 - eMessaging - Swiss Re Zurich
SE-5634 - London Market Processing - Service Provider - Swiss Re Zurich
Aim of function
Make it possible to identify a Business Partner specifically as a London Market eMessage Service Provider. Specific London Market features will only be activated on an eMessage with Service Provider if the Service Provider is identified as being London Market.
System Parameters Affected
eMessaging Business Partner Rule Set - Available Rules for assignment
Existing functionality affected
eMessaging London Market and London Bureau specific processing for Service Provider messages.
Life
SE-2851 - Assumed Cessions to be correctly calculated when the Treaty has multiple layers - Africa Re
Assumed Cessions to be correctly calculated when the Treaty has multiple layers –
(a) Quota Share + Surplus;
(b) Surplus + Surplus. Each layer may have different Terms & Conditions
SE-5295 - Allocation of original accounting year based on policy anniversary - Africa Re
Aim of function
Allocation of ‘Original Accounting Year’ and ‘Original Accounting Period’ based on policy anniversary.
System Parameters Affected
A new system parameter under Accounting - > Worksheets ‘Original Accounting Year and Period based on Policy Anniversary’ is available for selection ONLY when a value under ‘Original Accounting Period Set in Order is selected
Existing functionality affected
Cession Benefit:
On the Cession Benefit a new dropdown to select the Original Accounting Period is available. This is informational as per the current functionality
SE-4115 - Life MTK support for Cessions, Claims, Partners - DXC
Life MTK support for Cessions, Claims, Partners
SE-5026 - Default transaction effective date and transaction code on the cession based on premium calculation frequency - DXC
Default Transaction Code and Transaction effective date to the cession benefit from the calculation frequency
SE-5237 - Cession Loader- Old Business and other transactions- Issues to be fixed - DXC
Old Business Loading issues
SE-5241 - Cession Loader- Improvements Part 1 - DXC
https://cscjranor004.csc-fsg.com/browse/SICSR-20298
Issues regarding blank fields
Issues regarding leading and trailing spaces
SE-5263 - To retrocede in sequence: ordered by policy then rider instead of OCC then rider - Heng An Standard Life
- Please refer blow scenario when one insured object has more than one policies, and the same Benefit Cover is across defferent OCCs,
after running RPO for OUT187COPY then OUT206COPY, Client would like to retrocede in sequence:ordered by policy then rider instead of OCC then rider, expected CIU1LDIR00-> MIE1LDIR01-> LDLRLDIR00-> MIE1LDIR01 instead of sequence CIU1LDIR00-> LDLRLDIR00-> MIE1LDIR01-> MIE1LDIR01
IOPolicy NoReinsuranceInsured Object1Policy_1
cession IdBPBenefit CoveredInsured ProductriderOCCCb4-0CIU1LDIRLDIR00OUT187COPYCB4-1MIE1LDIRLDIR01OUT206COPY
| Insured Object1Policy_2
cession IdBPBenefit CoveredInsured ProductriderOCCCB4-2LDLRLDIRLDIR00OUT206COPYCB4-3MIE1LDIRLDIR01OUT206COPY
SE-5264 - To not round sum at risk of Cession for calculating retrocession retroceded amount - Heng An Standard Life
If sum at risk of cession has decimal place, after running RPO , the retrocession retroceded amount is calculated by rounded sum at risk of cession, client doesn’t want to round sum at risk
SE-5294 - Claim Recovery Calculation Rule for Wavier of Premium Rider Policy” - Heng An Standard Life
Summary:
A New Claim Recovery Calculation Rule for Wavier of Premium Rider Policy
Description:
Currently, the client only has one claim recovery calculation rule, and this rule is applied to all insurance policies.
Since the claim ACI figure for the wavier of premium rider (WPR) policies are calculated differently from other policies in client’s old system (LA), and as a result, the existing claim recovery calculation rule cannot produce the expected result for WPR claims.
Hence, client needs a different calculation rule for WPR claims. Client expects SICS to be able to apply different calculation rules based on the following two new fields they will provide to SICS.
Two new fields client will pass into SICS:
No. Name Expected Value from the Client
1 Claim Percentage 0% ~ 100%, and most of the time will be 100%
2 Claim Type “T” for regular claim (use the existing claim calculation rule),
“P” for WPR claim (use the new WPR claim calculation rule).
The calculation rule for WPR claims (with the Claim Type of “P”):
WPR Claim Recovery = Retroceded SAR * Claim Percentage (the new field stated above)
MG & Reserve Orders
SE-2354 - Support copy and update of Multi GAAP set-up from one db to another db - DXC
SE-3477 - Progress and log recording for all orders - DXC
Feature:
Progress Bar when I run an order form the workstation.
Job Progress logged in Job Log when the order is scheduled.
Acceptance Criteria:
Supported Accounting Orders Group Orders excluded as the included orders are executed.
Some orders are already supported.
Name
Account Group Order
Accrual Accounting On Inward
Adjust Claim Figures in Underwriters Estimate
Balance Reserves
Billing Statement
Billing Statement For Selected Balances
Brokerage Handling
Calculation Group Order
Cash Account Statement
Cash Chaser Document
Ceded Premium Order
Closed Balances Mass Update
Commutation Calculation Order
Commutation Multi Businesses
Commutation Multi Businesses – Account Currency
Document Chaser Document
Estimate Settlement Indicator Mass Update
Facultative
Facultative Adjustment
Filtered General Ledger Transfer
Financial Claim Reserves
Financial Premium Reserves
General Reserves
Generate Insurance Premium Tax to Tax Authority
Multi GAAP Accounting
Multi GAAP Recalculation
Multi GAAP Retrocession
Non-Proportional Treaty Adjustment
Occurrence Year Allocation of Losses
Open Balances Mass Update
Open Worksheets Mass Update
Original Premium Reserves
Original Premium Reserves Reversal
Outward Treaty and Fac OCC
Policy Ceded Accounting Order
Preliminary Bookings
Preliminary Bookings Correction
Recovery Calculation For Protection Program
Recovery Calculation For Protection Program AX
Recovery Calculation For Protection Program SL
Recovery Calculation For Single OCC
Recovery Calculation For Single OCC AX
Recovery Calculation For Single OCC SL
Recovery Calculation For US QuotaShare
Recovery Calculation For XL Fac
Recovery Calculation Group Order
Recovery Per Base Company For Protection Program
Recovery Per Base Company For Single OCC
Reinstatement Premium Assumed Business
Reinstatement Premium For Protection Program
Reinstatement Premium For Single OCC/XL CA
Reminder Statement
Reserve Correction
Retrocession Account
Retrocession Account Commutation
Retrocession Calculation
Retrocession Calculation Commutation
Retrocession Calculation for Non-Proportional
Retrocession Estimation Calculation
Retrocession Per Insured
Technical Account
Treaty Inward
Treaty Outward / Fac
Unearned Premium
Anonymize Personal Data Mass Update Order
Automatic Protection Assignment
Automatic Protection Assignment Claim
Cede Interface
Cession Renewal
Multi RUG Auto PA Order
SE-4230 - Add Underwriters Estimates Supporting Figures import facility in Life - DXC
Add Underwriters Estimates Supporting figures import facility in SICS Life
Same as for P&C but with an additional field in the import file for Projection Year, to support contracts with Projection Basis = Yearly.
SE-4231 - Add an Order similar to Underwriters Estimation Calculation Order in Life - DXC
SE-5128 - Add variables for booked amounts in UW Estimates calculation rules in SICS Life, similar to P&C - DXC
SE-5246 - Autotest for UPR and OPR Orders - DXC
SE-4249 - Government Tax Validation - Deviation Details - Swiss Re Zurich
SE-4262 - Government Tax - Make it possible to delete linked Target EC or Trigger EC from Worksheet - Swiss Re Zurich
Changed documentation
claim_acc/#delete-a-booking-or-booking-detail
manual_bookings_on_ws/#delete-a-booking-line-from-the-technical-worksheet
SE-5049 - SE-2663 Government Tax Validation framework - Documentation - Swiss Re Zurich
Separate task for following up on SE-2663
SE-2585 - Upload File for Estimation Complete Mass Update - Toa Re Europe
Other
SE-4109 - Autotest - Period Closing - DXC
Aim of function
< Please enter a short description on why this function has been implemented>
System Parameters Affected
<List all system parameters relevant for the new function>
Existing functionality affected
<List all existing functions that are affected by the new enhancement>.
SE-4110 - AmAg Period Closing - DXC
SE-4176 - Update SICS Docs framework - DXC
Move from MinimalMistakes to https://gohugo.io
SE-4218 - Enable use of Java 15 with SICS - DXC
Enable use of Java 15 with SICS
3p libraries are starting to use Java 11 as a target runtime.
Something we get out of this update for free: https://openjdk.java.net/jeps/358
SE-4305 - Code Coverage Reporting - DXC
Use Jacoco to create a code coverage reports for test cases
- Auto Test coverage
- Manual Test coverage
SE-5334 - Consolidate SQL Server instances - DXC
Benefit Hypothesis:
- Reduce HW requirements for running our SQL Server databases & increase capacity and performance
Acceptance Criteria:
- Redundant/old databases deleted
- New SQL Server 2019 instance created
- Remaining DB’s moved to new instance
- Old SQL Server instances removed
SE-5514 - Fix Cyclic Dependencies - DXC
Analyze the report of dependencies and work towards resolving them.
SE-5772 - Batch Server Instrumentation - DXC
The batch server should present the following metrics in a URI style structure:
- list of schedulers
-
for a given scheduler:
- queue depth (the number of pending jobs on the queue)
- current job progress (the completion % of the current active job)
- current job name
- current job step type (or some string representation of the job step)
This is in addition to the usual JRE and health check metrics.
This will permit the creation of a Batch Server dashboard to be created in Grafana+ clearly showing current status, progress, and backlog of jobs.
SE-4063 - ADH - Domain Block - Extra output fields with problem description and execution code - Swiss Re Zurich
Aimof function
To provide an explanation of the failure reason when a Domain Data block does not provide any output. This explanation will be a new output field on the Domain Data block, for all types. Another new output field will provide an ‘execution code’: 0=output provided, 1/2/3/…=various failure categories (to be determined).
Imagine a Claim Section Domain Data block that has claim identifier as input, but provides no output. These failure categories come to mind:
- Claim id does not exist in SICS
- Claim id exists on more than one claim (and the DD block is not indexed)
- A Java exception has occurred within the DD block’s processing logic, possibly caused by faulty data in the database.
System Parameters Affected
None
Existing functionality affected
ADH Transformation Mappings
SE-4112 - ADH - There are a number of blocks that should accept SICS objects as input - Swiss Re Zurich
Aim of function
Currently, a block output which provides a SICS object type (Partner, Section, etc.) can only be connected to a SICS object type input on another block.
Mentioned input and output types are related to Domain Data blocks only.
This enhancement aims to allow SICS objects to be used with other ADH transformation blocks’ inputs/outputs that do no more than,
- block or allow input value to be propagated to output
- or, test if input is null/empty.
Such blocks are: Empty, Not Empty, boolean-Gate (not the ‘Switch’ input), data-Gate, Default, boolean-Branch (not the ‘Switch’ input), matches-Branch (not the ‘Switch’ input), If (not the ‘Test’ input).
A common scenario would be to pass a SICS object output from one Domain Data block, through a boolean Gate block and into another Domain Data block. The Gate block would be configured to block the pass-through of the SICS object, and also other data inputs on the Gate block, if certain conditions are not satisfied. Thus avoiding that the second Domain Data block executes a database query with too few predicates (which could be very time-consuming).
System Parameters Affected
None
Existing functionality affected
ADH Transformation Mappings
SE-5077 - ADH - Options for date format handling when importing from Excel - Swiss Re Zurich
When ADH input data is imported from an Excel spreadsheet, cells that are formatted as Date will be converted to a string representation of the date value. This conversion uses default settings that are not always fitting.
In order to get better control over the conversion, this enhancement will add new settings on the ADH system parameter Options UI:
- ‘Excel import date format’ (e.g. ‘dd.MM.yyyy’, defaults to empty)
- ‘Locale’ (e.g. ‘English’, defaults to empty)
- ‘Apply to date cells with built-in formatting only’=yes/no (defaults to ‘yes’)
Any date imported from an Excel spreadsheet shall be formatted accordingly.
If ‘Excel import date format’ is empty/missing, the pre-enhancement default settings mentioned above will be used.
Data imported from .xml files are not affected by this enhancement.
SICS5
SE-1420 - DXC Assure UX Platform enabled REST APIs - DXC
Aim of function
< Please enter a short description on why this function has been implemented>
System Parameters Affected
<List all system parameters relevant for the new function>
Existing functionality affected
<List all existing functions that are affected by the new enhancement>.
Scope:
- Basic SICS REST framework
- API for Currencies & exchange rates
- API for Legal Areas (at a minimum Countries as this links to Currencies)
- Basic UX developed with DXC Assure Platform UX Framework
- API published on https://developer.dxc.com
- Auto-test framework
Generally useful links:
https://github.dxc.com/pages/ArchitectureOffice/Standards/API_Standards/Guidelines/
https://github.dxc.com/pages/diaas/doc-hub/
https://github.com/dxc-technology/halstack-client
https://github.com/dxc-technology/halstack-browser
https://developer.dxc.com/apis/tools
SE-5147 - SICS4 21.1 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-5453 - Multi-Server Cache Coherency - DXC
Coherent Caching of Object Graphs using a caching framework to synchronize across DMs either running on the same server or a different server.
SE-5467 - GHOP Deployment of SICS5 Builds - DXC
SE-5468 - Server Side Scaling - DXC
Support for scaling data managers automatically
SE-5469 - SICS Server Updates - DXC
Updates to the SICS Servers to align with the new architecture:
- Use DataManager
- Publish Metrics
SE-5516 - SVG Icon Support - DXC
Support SVG icons at any resolution or scaling
SE-5520 - Desktop Startup Optimization - DXC
Optimize and improve serialization and startup operations
SE-5589 - SICS5 Initial Life support - DXC
Life launcher etc. Packaging. Backend services. Bespoke Data Manager.