SICS Service Pack Documentation
Deliverables
REFERENCE DATA
NEW REFERENCE DATA TYPES
| Case Id | Reference Data Class | Name |
|---|---|---|
| SE-1413 | SicsRefSARAccumulationCategoryClass | SAR Accumulation Category |
NEW REFERENCE DATA ITEMS
| Case Id | Reference Data Class | Reference Data item | Description |
|---|---|---|---|
| SicsRefInsurableObjectPersonStatusClass | STATUS | Status | |
| SicsLfRefIndividualInsurableObjectStatusClass | STATUS | Status | |
| SicsLfRefLimitBasisTypeClass | PLPC | Per Life, Per SAR Accumulation Category | |
| SicsRefSARAccumulationCategoryClass | NDEF | Non Defnition | |
| SE-1348 | SicsRefEMessagingReferencingMethodClass | LINK_VPH | via Previous Message Hybrid |
| SE-1332 | SicsRefEMessagingMatchingRuleTypeClass | LT OR EQUAL | Less Than or Equal |
| SE-1332 | SicsRefEMessagingMatchingRuleTypeClass | GT_OR_EQUAL | Greater Than or Equal |
| SE-1222 | SicsRefTypeOfOrderClass | APDMUO | Anonymize Personal Data Mass Update Order |
NEW SYSTEM PARAMETERS
| Case Id | ID | Description |
|---|---|---|
| SICSR-15533 | WARNING_IF_NO_PTF_CURVE | Accounting - Reserve Calculation - General - Warning if no Portfolio Earning Curve is defined |
| SE-1413 | PRODUCT_INCLUDE_SAR_CATE | Business Partner - Branded product Classification - Insurance Product included in SAR Accumulation Category |
| SE-1410 | REINS_PROP_MAX_RET_CATE | Base Company Specific Settings - System Parameter Types - Retrocession Basis - Method of Retrocession is Reinsured Proportionally in excess of Maximum Retention Per Life/Per Category |
| SE-1410 | ALLOW_PART_WHEN_EXCEEDED | Base Company Specific Settings - System Parameter Types - Retrocession Basis- Allow Partial Retrocession When EXCEEDED |
| SE-1102 | AUTO_BK_INST_REG_SET | Accounting - Automatic Instalment Booking - Book Instalments automatically when setting registration complete flag |
| SE-929 | DEF_ORGNL_RESP_PARTNR | Accounting - Miscellaneous - Default Original Responsible Partner |
| SE-929 | ORGNL_RESP_PARTNR_MAND | Accounting - Miscellaneous - Original Responsible Partner Mandatory |
| SE-814 | VLD_ACLMTS_IN_CES_BATCH | System Parameters - Cession - Cession Setup - Validate Auto Cover Limits in Cession Batch |
| SE-800 | ENBLE_BENFIT_STAR_DATE | System Parameters - Cession - Cession Setup - Enable Benefit Reinsurance Start Date |
| SE-797 | ALLOW_PARTIALPROC_CES_BAT | Cession - Cession Setup - Allow Partial Processing of Cession Batch |
| SE-796 | SUMM_FOR_THEY_BILL_ORDER | Accounting - Worksheet - Active Summary Account for They Bill Order |
| SE-403 | ENBLE_MINOR_ADJ_FGU | Claims - Claim Accounting - Claim Worksheets - Enable Minor Adjustments in FGU worksheet |
NEW SECURITY USE CASES
| Case Id | Name | Description | Replaces Use Case |
|---|---|---|---|
| SE-1359 | eMessaging Rule on Rule Tab Override | The Use Case ‘eMessaging Rule on Rule Tab Override’ controls creation of a Rule Override from the Rules Tab in distinction from the Problems tab. | Updating Access |
| SE-1222 | Anonymize Personal Data Mass Update | Controls access to Anonymize Personal Data.\n\t This function is found in the Periodic Functions folder. | Executing Access |
NEW EMESSAGING RULES
| Case Id | Name | Type | Description |
|---|---|---|---|
| BookingYearAndPeriodPerDueDate.java | partner | Set Booking Year and Period per due date |
DATABASE PATCHES
| Case Id | Patch No | DB build | Developer | Description |
|---|---|---|---|---|
| SE-814 | lf_836 | 493 | Reinhard Bi | Add FSK_MAX_OCC_CLASS |
| SE-797 | lf_839 | 493ax | Piyush Aggarwal | Add ALLOW_PARTIALPROC_CESS_BAT column to LCM_BATCH table |
| SE-600 | lf_840 | 493bn | Nagarjuna Guddeti | Add HAS_QLFR to LCM_CESSION table |
| SE-600 | lf_842 | 493bs | Nagarjuna Guddeti | Create Cession Loader Qualifier Table |
| SE-1050 | lf_843 | 493bs | Shilei Wu | Add columns TOL_MONTHS |
| SE-700 | lf_844 | 493cb | Leslie Ji | Add Simplified UDF cloumns on table LF_CESSION |
| SE-700 | lf_845 | 493cb | Leslie Ji | Add Simplified UDF cloumns and Column CED_TOTAL_SAR |
| SE-700 | lf_846 | 493cb | Leslie Ji | Add Column CED_TOTAL_SAR |
| SE-580 | lf_851 | 493eg | Swati Ambwani | Add Column GROUP_SCHEME_NAME |
| SE-1222 | lf_852 | 493er | Sheetal Sharma | Add Column RETENTION_DATE to table LF_INSURABLE_OBJ |
| SICSR-14247 | pc_726 | 493dy | Kettan Kataria | Update Fk_claim column values in AC_LEDGER_BALANCE to NULL for SUBCLASS number 4 |
| SE-797 | re_2409 | 493ax | Piyush Aggarwal | Add ALLOW_PARTIALPROC_CESS_BAT column to BUSINESS table |
| SE-1315 | re_2411 | 493bm | Kamini Patidar | Add column DATE5 to PLB_RULE |
| SE-1346 | re_2412 | 493cb | Akhil Morapally | Add column EXCL_AUTO_EMES to PLB_RULE |
| SICSR-15786 | re_2413 | 493cf | Prachi Agrawal | Increase size of column UDF_TXT1 |
| SE-1425 | re_2414 | 493cm | Sheetal Sharma | Add column PRICING_EST_ULR2 to BUS_ESTIMATE |
| SE-1246 | re_2415 | 493co | KEVIN QIN | Update SOA_AC_YEAR and FRK/FSK SOA_AC_PERIOD of AC_WORKSHEET |
| SE-1417 | re_2416 | 493dm | Kevin Qin | Add join table to describe Brand Product related SAR Accumulation Insurance Product |
| SE-1102 | re_2417 | 493fb | Alok Ayachit | Create table EXCL_CRITERIA and join tables |
| SE-1410 | re_2418 | 493eh | Shilei Wu | Add Column ALW_PART_RE_WHEN_EXC to table PROTECTION_PRO_IBR |
| SE-1222 | re_2419 | 493er | Sheetal Sharma | Add Column RETENTION_DATE to table IO_PERSON |
| SE-1222 | re_2420 | 493er | Sheetal Sharma | Add Column RETENTION_DATE to table PARTY |
| SE-1222 | re_2421 | 493ex | Sheetal Sharma | Add Column RETENTION_DATE to table AUTOMATIC_ORDER |
| SE-1222 | re_2422 | 493fh | Sheetal Sharma | Add Column RETENTION_DATE_TO to table AUTOMATIC_ORDER |
| SE-1332 | re_2423 | 493gb | Deepali Agrawal | Create MF_REF_DATA_A |