SICS Service Pack Documentation

Deliverables

NEW REFERENCE DATA ITEMS
Case Id Reference Data Class Reference Data item Description
SE-943 SicsRefClaimConditionAttributeClass BROK_REINS_PM Calculated brokerage not equal to booked
SE-943 SicsRefClaimConditionAttributeClass REINS_PM Calculated reinstatement premium not equal to booked
SE-869 SicsRefSchedulerJobStepTypeClass REV_EPI Revised EPI Mass Update
SE-575 SicsRefAccountingOrderTypeClass REMU Revised EPI Mass Update
SE-242 SicsRefClaimConditionAttributeClass RES_AAD_POS_CL Reserve in AAD is positive for claim
SE-242 SicsRefClaimConditionAttributeClass LOSS_RES_POS_CL Loss reserves are positive for claim

NEW SYSTEM PARAMETERS

Case Id ID Description
SICSE-5278 EMSG_CLM_ADD_VAL eMessaging - Processing Options - Business Logic - Claims Due Date Additional Days [Value]
SICSE-565 BOOK_AC_VALID_ORIGBC Accounting - Retrocession - General - Booking on Accounting Classification valid for Original Base Company
SE-1111 VALID_BO_CLAIM_DUP Claim - Claim Accounting - Check for Existing Duplicated Claim Worksheet Balances
SE-1050 IS_AGE_CAL_TOL Cession - Cession Tolerances - Use Age Calculation Tolerance
SE-979 IS_MUL_DEC_DIS accounting - Miscellaneous - Multidigit Decimal Display
SE-929 USE_FX_HL_TWD_LINK_TO_HL Accounting - Miscellaneous - Use FX Headline for Technical Worksheet details linked to Headline
SE-575 REV_EPI_MASS_UPDATE Business - Miscellaneous- Revised EPI Mass Update - Include Previously Updated Businesses
SE-575 ENTRY_CODE_EPI Business - Miscellaneous- Revised EPI Mass Update - Entry Code Group
SE-575 EST_ITMS_EPI Business - Miscellaneous- Revised EPI Mass Update - Estimated Item

NEW SICS SERVER WEB SERVICES

Case Id WS Name Entry Point Description
  excludePreviousMessage SicsWsEMessagingEntryPoint  
  includePreviousMessage SicsWsEMessagingEntryPoint  

NEW SECURITY USE CASES

Case Id Name Description Replaces Use Case
SE-575 Business Revised EPI Mass Update Controls access to Revised EPI Mass Update Orders.\n\t This function is found in the Periodic Functions folder. Executing Access

DATABASE PATCHES

Case Id Patch No DB build Developer Description
SE-315 lf_833 492ba Deepali Agrawal Create table LCM_CLM_EXPENSE
SE-315 lf_834 492ba Deepali Agrawal Add column HAS_EXPENSES to table LCM_CLAIM with default value ‘N’
SC-1059 lf_835 492ak Piyush Aggarwal Increase size of columns STRNG01
SC-1407 lf_837 492cm Andi Thomas Drop index F_4CE97F627F9AA8A7(FK_AGREEMENT_SEC) on table BENEFIT_GROUP
SE-1050 lf_838 492dt Shilei Wu Add columns AGE_CAL_TOLERANCE
SE-484 re_2400 492bf Bjørn Add column IS_QS_BASED to BUSINESS
SE-492 re_2401 492bl Akhil Morapally Add column BAL_SPLIT_BY_MCOB to ACCOUNTING_ORDER
SE-575 re_2402 492ca Sheetal Sharma Add column IS_REV_EPI to BUS_PERIOD_EST
SE-487 re_2403 492dk Bjørn Add column TR_NEXT_IP to BUS_RESERVE_COND
SE-1035 re_2404 492do Nikhil Sanghvi Add column EXCLUDED_PREVIOUS to EMES_MSG
SE-1035 re_2405 492do Nikhil Sanghvi Add EMINF_EXCLUDED_PREVIOUS to INSURED_PERIOD
SE-566 re_2408 492ei Alok Ayachit Add column FK_ENTRY_TERM to SCOPE_OF_COVER