Deliverables

1 minute read

SICS Service Pack Documentation

NEW REFERENCE DATA ITEMS
Case Id Reference Data Class Reference Data item Description
  SicsLfRefClaimPartialPaymentReasonClass IR Instalment Recovery
SE-2841 SicsLfRefReasonForLoadingClass AFCL Above Free Cover Limit

NEW SYSTEM PARAMETERS

Case Id ID Description
SE-4049 CRT_PE_ON_NEW_SOC Underwriters Estimates - General - Calc. Order: Allow creation Pricing Estimate on a child section when it has already been created on another child section
SC-4422 KEEP_SIGN_FM_NONPROP_OCC Accounting - Retrocession - General - Miscellaneous - Keep Sign from Non Prop OCC

NEW SICS SERVER WEB SERVICES

Case Id WS Name Entry Point Description
SE-3923 annulBalancePairing SicsWsPcAccountingEntryPoint  
SE-3923 annulBalancePairing SicsWsCommonAccountingEntryPoint  

DATABASE PATCHES

Case Id Patch No DB build Developer Description
SE-3711 lf_874 4204af Helen Zhang Adding new column POLICY_YEAR in CESSION_DETAIL
SE-3763 lf_875 4204ap Rishabh Gupta Add join Table for Cession Detail and Additional Classification as for Life MCOB
SE-4195 lf_876 4204bo Sakshi Rajodia Add Column IS_SUM_AT_RISK_OUR_SHARE to LF_CESSION TABLE
SE-4123 lf_877 4204ay Helen Zhang Adding new column IS_GROUP_WITHOUT_INDI_MEM in CESSION_DETAIL
SE-4123 lf_878 4204ay Helen Zhang Adding new column IS_GROUP_WITHOUT_INDI_MEM in LCM_CESSION
SE-3874 lf_879 4204bo Sakshi Rajodia Add Column IS_CESSION_CLAIMS_OUR_SHARE
SE-3720 lf_880 4204bu Sakshi Rajodia Add Column IS_CLAIM_AMOUNTS_OUR_SHARE
SE-4122 lf_882 4204cb Rishabh Gupta Add Column LoadingLifeId1
SE-3720 lf_883 4204cm Sakshi Rajodia Adding new column IS_SUM_AT_RISK_OUR_SHARE in LCM_CESSION table
SE-3720 lf_884 4204cm Sakshi Rajodia Adding new column IS_CLAIM_AMOUNTS_OUR_SHARE in LCM_CLAIM table
SE-3007 lf_885 4204co Nagarjuna Guddeti Add columns to tables CESSION_DETAIL and LCM_CESSION
SE-5050 lf_886 4204eh Kevin Qin Increase size of decimal value for the column ITEM_AMOUNT and ITEM_ADJST from 2 to 6 digits in table CES_ACCOUNT_ITEM
SE-5050 lf_887 4204eh Kevin Qin Increase size of decimal value for the column ITEM_AMOUNT and ITEM_ADJST from 2 to 6 digits in table LCM_ACI_DATA
SE-2740 re_2518 4204ag JITENDRA GUPTA Add column IS_CLAIM_COMPLEX to table CLAIMS with default value ‘N’
SE-4053 re_2519 4204ag Bjørn Larssen Add AUTO_BOOK to GOVTAX_RULE
SE-3393 re_2520 4204aw Vinay Mathwal Add column CLAIM_SHORT_DESC to table CEDE_INTERFACE
SE-488 re_2521 4204aw Morapally Akhil Add column IS_PORTF_INCL to table ACCOUNTING_ORDER
SE-488 re_2522 4204bo Morapally Akhil Set IS_PORTF_INCL=’N’ When IS_PORT_RES_INCL=’Y’ OR INCL_RES_PRT=’Y’ OR IS_RES_PORT=’N’
SE-4053 re_2523 4204bs Bjørn Create new table GOVTAX_LOG
SE-4053 re_2524 4204cc Bjørn Add FRK/FSK_GOVTAX_VAL_CAT and FK_GOVTAX_RULE to EMES_OVERRIDE
SE-4053 re_2526 4204cm Bjørn Add MESSAGE_ID to EMES_OVERRIDE
SE-1031 re_2527 4204cv Helen Zhang Increase the length of MDT_COL_DES.TB_COL_NAME
SE-2379 re_2528 4204cx prajoriya Add VAL_COMPLETE_FLG to AC_MASS_UPDT
SE-2379 re_2529 4204dt prajoriya Add IS_BASED_ON_EC_LIQUIDITY to AC_BAL_GRP_PARM