Deliverables

SICS Service Pack Documentation

REFERENCE DATA

NEW REFERENCE DATA TYPES

Case Id	Reference Data Class	Name
	SicsRefEMessagingPreviousMessageExclusionStatusClass	eMessaging Previous Message Exclusion Status

NEW REFERENCE DATA ITEMS

Case Id	Reference Data Class	Reference Data item	Description
SE-2496	SicsRefCalculationMethodClass	COMBINATION	Percent of Combination
SE-1976	SicsRefEMessagingAcordCodeUsageTypeClass	PREV_PAID_ANN	Previously Paid Annuity
SE-1976	SicsRefEMessagingAcordCodeUsageTypeClass	ANNUITY_RES	Annuity Reserves
SE-1865	SicsRefAccountingEntryCodeGroupCatecoryClass	PREMPRELOSS	Premium Before Loss
SE-1685	SicsRefEMessagingAcordCodeUsageTypeClass	DEPOSIT_PREMIUM	Deposit Premium
SE-1685	SicsRefEMessagingAcordCodeUsageTypeClass	MINIMUM_PREMIUM	Minimum Premium
SE-1684	SicsRefEMessagingPreviousMessageExclusionStatusClass	PMEXIPEX	Insured Period excluded
SE-1684	SicsRefEMessagingPreviousMessageExclusionStatusClass	PMEXNOEX	No Exclusions
SE-1684	SicsRefEMessagingPreviousMessageExclusionStatusClass	PMEXMSGEX	Individual Message(s) excluded
SE-299	SicsRefAccountingCalculationClass	PCAB	Profit Commission Automatic Booking
SE-299	SicsRefAccountingCalculationClass	MEAB	Management Expenses Automatic Booking

NEW SYSTEM PARAMETERS

Case Id	ID	Description
SICSR-18288	AP_NOT_RAC_PTTY_AB	Accounting - Worksheet - Accounting Periods not restricted by definition on Admin conditions
SE-1865	PREMIUM_BEFORE_LOSS	Claims - Claim Accounting - Customize Warnings To Be Shown - Premium must come before the loss amount on Facultative Business
SE-1841	CLAIM_BDX	Claims-miscellanous -Claims Bordereaux in Use
SE-793	RUG_PA_CAL_FREQUENCY	Business - Protection - Proportional Risk Unit Group � Protection calculation frequency - 1 = Quarterly , 2 = Monthly, 3 = Weekly, 4 = Daily

UPDATED SICS SERVER WEB SERVICES

Case Id	WS Name	Entry Point	Description
CSI90497	createPolicyClaim	SicsWsPcClaimEntryPoint
CSI90497	assignToExistingPolicyClaim	SicsWsPcClaimEntryPoint
CSI90497	updatePolicyClaim	SicsWsPcClaimEntryPoint
CSI90498	createPolicyAccountingClaimDetail	SicsWsPcAccountingEntryPoint
CSI90498	createPolicyAccountingDetail	SicsWsPcAccountingEntryPoint
CSI90519	createClaim	SicsWsPcClaimEntryPoint	This document describes the Create Claim service which is part of the Claim API \n\t\twhich is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90520	assignToExistingClaim	SicsWsPcClaimEntryPoint	This document describes the Assign To Existing Claim service which is part of the Claim API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90521	updateClaim	SicsWsPcClaimEntryPoint	This document describes the Update Claim Group service which is part of the \n\t\tClaim API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90522	createHeadlineLoss	SicsWsPcClaimEntryPoint
CSI90523	deleteHeadlineLoss	SicsWsPcClaimEntryPoint
CSI90524	updateHeadlineLoss	SicsWsPcClaimEntryPoint
CSI90526	retrieveHLClaimListFigures	SicsWsPcClaimEntryPoint	This document describes Claim List Figures Retrieval, which is a part in System User API which is included in SICS\nt Application Programming Interfaces.
CSI90527	retrieveNonProportionalRecoveryListFigures	SicsWsPcClaimEntryPoint	This document describes Headline Loss Non-Proportional Recovery List service which is part of the Claim API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90528	createClaimProgram	SicsWsPcClaimEntryPoint
CSI90529	updateClaimProgram	SicsWsPcClaimEntryPoint
CSI90530	deleteClaimFromClaimProgram	SicsWsPcClaimEntryPoint	This document describes the delete claim from claim program service which is part of the Claims API of the SICS/Server Application Programming Interfaces (APIs).
CSI90531	renewClaimProgram	SicsWsPcClaimEntryPoint
CSI90581	createInsurableObject	SicsWsBusinessInsurablesEntryPoint	This document describes Creating Insurable Object with Details which is a part in Insurable Object API that is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90582	updateInsurableObject	SicsWsBusinessInsurablesEntryPoint	This document describes Updating Insurable Object with Details which is a part in Insurable Object API that is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90584	maintainCessionInsurablePeril	SicsWsBusinessInsurablesEntryPoint	This document describes Maintain Cession Insurable Peril for Create, Update and Delete Cession Insurable Peril which is a part in System User API which is included in SICS\nt Application Programming Interfaces.
CSI90586	createBusinessPartner	SicsWsBusinessPartnerEntryPoint
CSI90587	updateBusinessPartner	SicsWsBusinessPartnerEntryPoint
CSI90588	createBank	SicsWsBusinessPartnerEntryPoint
CSI90589	updateBank	SicsWsBusinessPartnerEntryPoint
CSI90590	createPerson	SicsWsBusinessPartnerEntryPoint
CSI90591	updatePerson	SicsWsBusinessPartnerEntryPoint
CSI90592	deleteParty	SicsWsBusinessPartnerEntryPoint
CSI90594	createClaimGroup	SicsWsPcClaimEntryPoint	This document describes the Create Claim Group service which is part of the Claim API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90595	updateClaimGroup	SicsWsPcClaimEntryPoint	This document describes the Update Claim Group service which is part of the Claim API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90596	deleteClaimGroup	SicsWsPcClaimEntryPoint	This document describes Delete Claim Group which is a part in Claim API which is included in Sics\nt Application Programming Interfaces
CSI90614	createUser	SicsWsSystemAdministrationEntryPoint	This document describes the Create User service which is part of the Security API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90628	retrieveCPClaimListFigures	SicsWsPcClaimEntryPoint	This document describes Retrieve Claim Figures for Claim Program service which is part of the Claim API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90629	moveClaim	SicsWsPcClaimEntryPoint	This document describes the Move Claim (from a Claim Program) to Another Claim Program, to Another Treaty,\n\t\tor to Same Source Treaty service which is part of the Claims API of the SICS/Server Application Programming Interfaces (APIs).
CSI90630	deleteClaimProgram	SicsWsPcClaimEntryPoint	This document describes the delete claim program service which is part of the Claims API of the SICS/Server Application Programming Interfaces (APIs). The only input field and MINIMUM input is the Claim Program ID
CSI90631	deleteClaimToSOCRelation	SicsWsPcClaimEntryPoint	This document describes the delete claim to SOC relation service which is part of the Claims API of the SICS/Server Application Programming Interfaces (APIs).
CSI90632	createRemittanceBalance	SicsWsPcAccountingEntryPoint	This document describes the create recieved/paid remittance balance service which is part of the Accounting API of the SICS/Server Application Programming Interfaces (APIs).
CSI90633	changeStatusRemittanceBalance	SicsWsPcAccountingEntryPoint	This document describes the change status of recieved/paid remittance balance service which is part of the Accounting API of the SICS/Server Application Programming Interfaces (APIs).
CSI90634	createBalancePairing	SicsWsPcAccountingEntryPoint
CSI90635	reverseTechnicalWorksheet	SicsWsPcAccountingEntryPoint	This document describes reverse worksheet , balance or details web service which is part of the Accounting API of the SICS/Server Application Programming Interfaces (APIs).
CSI90717	createBusinessPartnerGroup	SicsWsBusinessPartnerEntryPoint	This document describes the Create Business Partner Group which is part of the \n\t\tBusiness Partner API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90730	updateBusinessPartnerGroup	SicsWsBusinessPartnerEntryPoint	This document describes the Update Business Partner Group which is part of the \n\t\tBusiness Partner API which is part of the SICS/Server Application Programming Interfaces (APIs).
CSI90746	retrieveReferenceData	SicsWsReferenceItemsEntryPoint	This document describes the Retrieve Reference Data service which retrieves all the Reference Data from the system.
CSI90752	shutDown	SicsWsAdministrationEntryPoint
CSI90766	retrieveInsurablePerils	SicsWsBusinessInsurablesEntryPoint	This document describes Retrive Insurable Peril on the basis of the country/ countryGroup as input, which is a part in System User API which is included in SICS\nt Application Programming Interfaces.
CSI90778	assignAutoClaimProtectionAllocation	SicsWsPcClaimEntryPoint
CSI90782	createLightClaim	SicsWsPcClaimEntryPoint
CSI90782	updateLightClaim	SicsWsPcClaimEntryPoint
CSI90793	login	SicsWsAdministrationEntryPoint
CSI90875	currencies	SicsWsReferenceItemsEntryPoint
CSI90908	updateCurrency	SicsWsReferenceItemsEntryPoint	This document describes Update Currency which is a part in System User API which is included in Sics\nt Application Programming Interfaces
GEN90020	createExchangeRate	SicsWsReferenceItemsEntryPoint	This document describes Create Exchange Rate service which creates Daily Rate,Period Rate, Year Rate.
GEN90022	createCurrency	SicsWsReferenceItemsEntryPoint	This document describes Create Currency which is a part in System User API which is included in Sics\nt Application Programming Interfaces
PRG90257	fullRefresh	SicsWsAdministrationEntryPoint
PRG90257	serverOptions	SicsWsAdministrationEntryPoint
PRG90257	lightRefresh	SicsWsAdministrationEntryPoint
PRG90273	produceDocument	SicsWsDocumentProductionEntryPoint
SE-1867	deleteClaimToHLRelation	SicsWsPcClaimEntryPoint
SIR90050	currencyExchangeRate	SicsWsReferenceItemsEntryPoint	This document describes Currency Exchange Rate service which retrieves the exchange rate between 2 currencies.
SRZ90328	retrieveClaimLedger	SicsWsPcClaimEntryPoint
UNKNOWN	referenceDataDependencyType	SicsWsReferenceItemsEntryPoint
UNKNOWN	referenceDataTypeWithFilteredItems	SicsWsReferenceItemsEntryPoint
UNKNOWN	referenceDataDependency	SicsWsReferenceItemsEntryPoint
UNKNOWN	referenceDataType	SicsWsReferenceItemsEntryPoint
UNKNOWN	createAndUpdateClaimFGU	SicsWsPcClaimEntryPoint	This document describes the Create And Update Claim From Ground Up (FGU) service which is part of the \n\t\tClaim API which is part of the SICS/Server Application Programming Interfaces (APIs).
UNKNOWN	countryGroup	SicsWsReferenceItemsEntryPoint
UNKNOWN	countries	SicsWsReferenceItemsEntryPoint

NEW SECURITY USE CASES

Case Id	Name	Description	Replaces Use Case
SE-1810	Business Conditions Year End Calculation	Controls Updating Final Year End Calculations.\n\t This function is available in Profit Commission conditions, Deduction conditions and Deductible conditions.	Updating Access

NEW EMESSAGING RULES

Case Id	Name	Type	Description
	ReferRelatedMessagesBySenderContractReference.java	messageType	Related message by contract sender reference
	CheckContractRegistrationComplete.java	messageType	Check that Insured Period has Registration Complete if activated
SE-1685	DepositPremiumAmountValidation.java	insuredPeriod	Compare the message Deposit Premium Amount with that of the section

DATABASE PATCHES

Case Id	Patch No	DB build	Developer	Description
SICSE-4461	re_2240	999zz	Mads Johannessen	Update database to support Unicode
SE-299	re_2450	4201dl	Ankit Jain	Adding new columns ACCT_YEAR_TO and ACCT_PR_TO in ACCOUNTING_ORDER table and IS_PC_CALC in AC_LEDGER_DETAIL
SE-2125	re_2453	4201bb	Kamini Patidar	Add column FGU_CLIENT_IBNR to table CLAIMS_FGU_DTL
SE-2296	re_2454	4201bm	Nick Irwin	Add column RECEIVE_CM to BP_EMESSAGING_DETAILS
SE-2474	re_2455	4201cf	Mayank Rajdev	Modify ADH_OUT_PATT_FLD increase length of NAME
SE-490	re_2456	4201cn	Bjørn	Add column FRK_TMPL_FREQ to table ACCOUNTING_ORDER
SE-1684	re_2457	4201ct	Nick Irwin	Add column FRK_TMPL_FREQ to table EMES_MSG
SE-1810	re_2458	4201eq	Kalyani Rupan	Add column FINAL_YR_CALC_FQ to BUS_PROFIT_COMM
SE-1544	re_2459	4201da	Surya Bhaskar Kakarla	Create new table EXMPT_PARTY_IDTYPE
SE-793	re_2460	4201df	Sheetal Sharma	Add Ref Data foreign key columns FSK/FRK_MAN_PROT and add Column IS_RSLT_PR_POLICY
SE-1964	re_2461	4201dh	Saloni Maheshwari	Add column CLM_BDX to table CLAIM_COND with default value ‘N’
SE-1841	re_2462	4201fs	KAMINI PATIDAR	Add column CLAIM_BDX to table CLAIMS with default value ‘N’
SICSR-18008	re_2463	4201fv	Prachi Agrawal	Increase size of column CLAIM_UDF_TXT1
SE-1841	re_2464	4201fs	Saloni Maheshwari	Add column CLM_BDX to table CLAIM_PROGRAM with default value ‘N’
SE-2496	re_2465	4201fs	Shilei Wu	Add column PCT_COMBINE
SE-490	re_2466	4201gc	Bjørn	Add column FK_LAST_ORDER to table ACCOUNTING_ORDER
SE-490	re_2467	4201gc	Bjørn	Add column FK_ORDER_TEMPL to table JOB_TEMPLATE
SC-3157	re_2469	4201ic	Bhuvaneshwari Ramasubbu	Alter Table Business Column IS_SUPPORTING from CHAR(1) to NCHAR(1) and Recreate Index I_BUS_IS_SUPP