Deliverables

4 minute read

SICS Service Pack Documentation

REFERENCE DATA

NEW REFERENCE DATA TYPES
Case Id Reference Data Class Name
  SicsRefDMSDocumentTypeClass DMS Document Type
  SicsRefPremiumRateCalculationBasisClass Premium Rate Basis
SE-2997 SicsRefClaimDueDateBasisClass Claim Due Date Basis
SE-2663 SicsRefGovernmentTaxValidationIndicatorClass Government Tax Validation Indicator
SE-2663 SicsRefTaxPercentageCalculationBasisClass Tax Percentage Calculation Basis
SE-2663 SicsRefGovernmentTaxCategoryClass Government Tax Category
NEW REFERENCE DATA ITEMS
Case Id Reference Data Class Reference Data item Description
  SicsRefPartyRelationshipTypeClass LIN Linked Insureds
  SicsRefRatioUnitClass FAC Factor
  SicsRefPartyRelationshipTypeClass LBP Linked Business Partners
  SicsRefInterpolationRuleClass DAYSONLY Days Value Only
  SicsRefPremiumRateCalculationBasisClass FOB Per Other Basis
  SicsRefAccountingEntrySubCategoryClass GOVTX GovernmentTaxes
  SicsLfRefTransactionCodeClass ADJREV Adjustment Reversal
  SicsRefPremiumRateCalculationBasisClass PSRI Per Sum Reinsured
SE-3218 SicsRefSchedulerJobStepTypeClass MULTIRUGPA Multi RUG Protection Assignment
SE-3178 SicsRefAccountingRetrocessionPairingTypeClass ORPTOIGC Placement To IGC
SE-2997 SicsRefClaimDueDateBasisClass MSG_AS_OF_DATE Message As of Date
SE-2997 SicsRefClaimDueDateBasisClass MSG_CREATION_DT Message Creation Date
SE-2883 SicsRefCalculationTypeClass CLCLC Claim Liability Calculation Basis
SE-2663 SicsRefTaxPercentageCalculationBasisClass BOOKDATE Booking Date
SE-2663 SicsRefTaxPercentageCalculationBasisClass ACPEREND Acct Period End Date
SE-2663 SicsRefGovernmentTaxValidationIndicatorClass STOPTACL TA & CL WS - Always Stop if Trigger/Target EC is booked
SE-2663 SicsRefGovernmentTaxValidationIndicatorClass EXCLTACL TA & CL WS excluded from Validation
SE-2663 SicsRefGovernmentTaxValidationIndicatorClass EXCLTAONLY TA WS only excluded from Validation
SE-2663 SicsRefBusinessAdministratorTaskClass GTAXACC Government Tax Accounting
SE-2663 SicsRefGovernmentTaxValidationIndicatorClass EXCLCLONLY CL WS only excluded from Validation
SE-2663 SicsRefGovernmentTaxValidationIndicatorClass STOPCLONLY CL WS only - Always Stop if Trigger/Target EC is booked
SE-2663 SicsRefAccountingEntryCodeGroupCatecoryClass GOVTAX Government Tax Target
SE-2663 SicsRefGovernmentTaxValidationIndicatorClass STOPTAONLY TA WS only - Always Stop if Trigger/Target EC is booked
SE-2395 SicsRefAccountingCalculationClass CIBNRRPR Client IBNR Reinstatement Premium Reserve
SE-2395 SicsRefAccountingEntrySubCategoryClass CIBNR Client IBNR
SE-2395 SicsRefAccountingEntrySubCategoryClass CIBNRRR Client IBNR Reinstatement Reserve
SE-2395 SicsRefAccountingEntrySubCategoryClass CIBNRLAE Client IBNR LAE
SE-2395 SicsRefFromGroundUpBookingGroupClass CIBNRLAE Client IBNR LAE
SE-2395 SicsRefFromGroundUpBookingGroupClass CIBNR Client IBNR
SE-2395 SicsRefAccountingEntrySubCategoryClass CIBNRAAD Client IBNR AAD

NEW SYSTEM PARAMETERS

Case Id ID Description
SICSE-3145 REINS_SEQ_MAX_RET Base Company Specific Settings - System Parameter Types - Retrocession Basis - Method of Retrocession is Reinsured Sequentially in excess of Maximum Retention
SE-3145 BENID_IN_USE Database - Extend Base Company Segration - Extend Base Company Segration
SE-2885 ALLOW_TRAN_NUM Cession - Allow transaction number on cession transactions
SE-2663 FK_EU_AREA Accounting - Miscellaneous - EU Area
SE-2663 GTAX_IN_USE Accounting - Miscellaneous - Government Tax Framework in use

NEW SICS SERVER WEB SERVICES

Case Id WS Name Entry Point Description
SE-3863 importMultipleSubSOA SicsWsLfAccountingEntryPoint  
SE-3028 createCancellationProvisionsForLife SicsWsBusinessEntryPoint  
SE-3028 updateCancellationProvisionsForLife SicsWsBusinessEntryPoint  
SE-3027 updateClaimConditionForLife SicsWsBusinessEntryPoint  
SE-3027 createClaimConditionForLife SicsWsBusinessEntryPoint  
SE-3026 createReferralLimitsConditionForLife SicsWsBusinessEntryPoint  
SE-3026 updateReferralLimitsConditionForLife SicsWsBusinessEntryPoint  
SE-2902 createExperienceAdjustmentConditionForLife SicsWsBusinessEntryPoint  
SE-2902 updateNonContractAdminAdjustmentConditionForLife SicsWsBusinessEntryPoint  
SE-2902 createNonContractAdminAdjustmentConditionForLife SicsWsBusinessEntryPoint  
SE-2902 updateExperienceAdjustmentConditionForLife SicsWsBusinessEntryPoint  

NEW SECURITY USE CASES

Case Id Name Description Replaces Use Case
SE-2663 Business Insured Period Government Tax Validation Indicator Controls access to update Government Tax Validation Indicator. Updating Access
SE-2663 Business Insured Period Government Tax Validation Active Controls access to update Government Tax Validation Active. Updating Access
SE-2663 System Parameter Government Tax Table Controls access to edit the existing new Government Tax Table Rules Updating Access
SE-793 Business Multi RUG Auto Protection Find Controls access to Business Multi RUG Auto Protection Find.\n\t This function is found in the Periodic Functions folder. Executing Access

DATABASE PATCHES

Case Id Patch No DB build Developer Description
SE-3145 lf_859 4203au Shilei Wu Adding new column BEN_IDENTIFER in LF_CESSION
SE-3222 lf_860 4203bw Helen Zhang Add PREM_BASIS to PROP_PREMIUM
SE-3222 lf_861 4203bz Helen Zhang Adding new column SALARY
SE-3010 lf_862 4203cd Helen Zhang Adding new column SAR_CLAIM_BAS in SAR_COND
SE-3222 lf_863 4203bz Helen Zhang Adding new column SALARY
SE-3222 lf_864 4203cz Helen Zhang Increase size of decimal value for the column PREM_RATE from 2 to 6 digits in table CESSION_DETAIL
SE-2839 lf_865 4203ek Nagarjuna Guddeti Add PREMIUM_AMOUNT column to CESSION_DETAIL table
SE-3677 lf_866 4203ex Helen Zhang Add MALE_EXPIRY_AGE column to CESSION_DETAIL table
SE-3321 lf_867 4203fi Rishabh Gupta Create Cession Loader Joint Life Table
SE-2839 lf_868 4203fk Nagarjuna Guddeti Add Column IS_RATE_AMT_CESSION_BENE_TRAN to table PROP_PREMIUM With default Value ‘N’
SE-3724 lf_869 4203fp Gaurav Kumar Pandey Adding new column MALE_EXPIRY_AGE in LCM_CESSION
SE-3321 lf_870 4203fw Rishabh Gupta Added Column PrimayLife
SE-2364 lf_871 4203gs Rishabh Gupta Add column FK_DATASOURCE to table LCM_CLM_EXPENSE
SE-3321 lf_872 4203gs Rishabh Gupta Added Column residenceLegalArea and preferredLifeClassification to LCM_JOINT_LIFE_DATA
SE-2885 lf_873 4203hf Helen Zhang Adding new column TRANSACTION_NMBR in LCM_CESSION
SE-2663 re_2492 4203ap Bjørn Larssen Add FRK/FSK GTAX_VALIDATOR to INSPER_ACC_VAL_IND
SE-2663 re_2493 4203ap Bjørn Larssen Add IS_GTAX_ACTIVE to INSURED_PERIOD
SE-3120 re_2494 4203au SatyaNarayana Reddy Increase size of decimal value for the column BASE_FIGURE from (22
SE-1031 re_2496 4203av Helen Zhang Increase the length of MDT_COL_VALUES.TB_COL_VALUE column from 22 to 50
SE-2597 re_2497 4203bo Piyush Aggarwal Add join Table for CNU_USER and PARTY
SE-3218 re_2499 4203by Fanhua Kong Create new table RUG_FACOCC_RET
SE-2663 re_2500 4203eh Bjørn Create new table AC_GTAX_PAIR
SE-3226 re_2501 4203em Sartaj Khan Add FSK/FRK_EMINF_CDDB to INSURED_PERIOD
SE-3217 re_2502 4203em Ayushi Garg Add columns PC_ACCU_EXCL
SE-2663 re_2504 4203eo Kalyani Rupan Add IS_BASED_ON_GT to AC_BAL_GRP_PARM
SE-3301 re_2505 4203ez Srinivas Veenam Add Column RST_REV_WKSTCLS_AUT to SEC_CLAIM_WKSHT
SE-2663 re_2506 4203ez Bjørn Rename reference data ‘VAT Calculation Basis’
SE-3189 re_2507 4203fa Shilei Wu Add DUE_DT on ACCOUNTING_ORDER
SE-2395 re_2508 4203fe Abhishek Lalwani Add column FGU_CLIENT_IBNR_LAE
SE-2663 re_2509 4203fc Morapally Akhil Add FRK/FSK GOV_TAX_VLD_CAT and GOV_TAX_VLD_CMT to table AC_LEDGER_DETAIL
SE-2663 re_2510 4203fi Kalyani Rupan Add new Columnns INVOICE_NO
SE-2885 re_2511 4203fh Helen Zhang Add Column TRANSACTION_NMBR to AMENDMENT
SE-1781 re_2512 4203fk Morapally Akhil Create new table AC_DR_AERT and join tables AC_DR_AERT_DRC
SE-2341 re_2513 4203fn Sartaj Khan Add column CMNT to EMES_CHUNK
SE-2597 re_2514 4203fm Piyush Aggarwal Add column FK_CURRENT_PARTY to table CNU_USER
SE-2663 re_2515 4203fz Srinivas Veenam Add column GOV_TAX_RULE_REF to table AC_LEDGER_DETAIL
SE-2663 re_2516 4203gy Bjørn Create new table GOVTAX_RULE
SE-2395 re_2517 4203gw Abhishek Lalwani Add column AMT_EXL_CLIENT_IBNR