Cede Interface Table
The Cede Interface Table is split in four different domains, distinguished by the attribute Record Type:
- Type 1: P&C Policies (Contracts and Premiums)
- Type 2: P&C Claims and Claim Accounting
- Type 3: Life Policies (Contracts and Premiums)
- Type 4: Life Claims and Claim Accounting
Importing data to the Cede Interface Table is the bulk load step of the process. The data to be loaded are accounting records. These will be imported in SICS with the included policy and claim data. There are four possible entry records:
- P&C Premium
- P&C Claim
- Life Premium
- Life Claim
They are mapped to the same physical table named CEDE_INTERFACE. The following three sections describe the common, the P&C specific and the Life specific attributes:
Common Attributes
| ID | Attribute | Description | Data Type | Mandatory | Attribute Group |
|---|---|---|---|---|---|
| COM.01 | FK_ORDER | Foreign Key to the order | String (32) | No | Internal / Reserved |
| COM.02 | PID | Process ID, identifies the OS Task | String (32) | No | Internal / Reserved |
| COM.03 | STATUS | Can be null if newly imported row, ACQUIRED when firstly accessed, SUCCESS if processed successfully or ERROR if processed with errors | String (15) | No | Internal / Reserved |
| COM.90 | REASON_FOR_CHANGE | Can be null if newly imported row, ACQUIRED when firstly accessed, SUCCESS if processed successfully or ERROR if processed with errors | String (254) | No | Internal / Reserved |
| COM.91 | VERSION | Record version, for write lock handling. Default value ‘1’ | Integer (10) | Yes | Internal / Reserved |
| COM.96 | FRK_LIGHT_DETAIL | Foreign key to the booking detail created from the imported record | String (32) | No | Internal / Reserved |
| COM.04 | IMPORT_TS | Import Timestamp | Date Time | Yes | Technical |
| COM.05 | BATCH_NAME | Identifier of the batch, not mandatory but useful for data recovery | String (50) | No | Technical |
| COM.06 | CREATION_TS | Creation Timestamp, originated by the primary (source) system. Needed to catch the policy variation sequence | Date Time | Yes | Technical |
| COM.07 | RECORD_UNIQUE_ID | An identifier that uniquely represent the record within the given primary (source) system | String(32). RECORD_UNIQUE_ID and prim_SYS are the primary key of this table | Yes | Technical |
| COM.08 | PRIM_SYS | Primary (source) System - A code (max 15 chars) that represents the primary (source) system. It must be defined in SICS as a ref data. SubclassNumber: 01074. SicsRefExternalSystemName. RECORD_UNIQUE_ID and prim_SYS are the primary key of this table | SICS Reference Data code. String (15) | Yes | Technical |
| COM.09 | RECORD_TYPE | Record type, four possible values are: P&C Premium, P&C Claim, Life Premium, Life Claim | Integer (3) | Yes | Technical |
| COM.10 | ACCESS_CODE | Access Code for data segregation. SicsRefAccessCode. Subclass number 260 | SICS Reference Data code. String (15) | No | Accounting |
| COM.11 | BASE_COMPANY | SICS identifier of Base Company | String (20) | Yes | Accounting |
| COM.12 | EC | Entry Code | String (15) | Yes | Accounting |
| COM.13 | CURRENCY | Currency Code - currency of the booking. ISO ALPHA3 or other codes if data mapping feature in use | String (15) | Yes | Accounting |
| COM.14 | DTL_AMT | Detail Amount. The Currency is defined in the corresponding Balance | Decimal (22,2) | Yes | Accounting |
| COM.15 | AS_AT | Y/N - if yes then the DTL AMT is considered as cumulated. Normally used in case of Claim Reserves. If NO then figure will be loaded as adjustment. Note that if the entry code is choosen to be managed as AS AT, then this must be done for all the bookings coming from the specific source system. Same applies in case of AS AT = N. Otherwise the interface will not load properly | Boolean | Yes | Accounting |
| COM.16 | OCC_YR | Occurrence Year. Year of loss for claims or year of earning for premiums | Integer (4) | Yes for Claim record | Accounting |
| COM.17 | UW_YEAR | Underwriting Year | Integer (4) | Yes | Accounting |
| COM.18 | AC_YEAR | Financial year used for the original transaction in the primary system. Normally same as booking year (see booking year attribute) | Integer (4) | Yes | Accounting |
| COM.19 | AC_REF_PERIOD | Financial period used for the original transaction in the primary system. Normally same logic as per booking period (See booking period). Reference data code for: SicsRefAccountingPeriod. Reference data subclass Number 177. Available codes: AHY1 = 1st Of 2, AHY2 = 2nd Of 2, AM01 = 1st Of 12, AM02 = 2nd Of 12, AM03 = 3rd Of 12, …, AM12 = 12th Of 12, AQ1 = 1st Of 4, AQ2 = 2nd Of 4, AQ3 = 3rd Of 4, AQ4 = 4th Of 4, ATRI1 = 1st Of 3, ATRI2 = 2nd Of 3, ATRI3 = 3rd Of 3, AYR = Yearly | SICS Reference Data Code. String (15) | Yes | Accounting |
| COM.20 | AC_START_DATE | The Start Date of the Accounting Period. The accounting period is a span of dates used to find the proper protection assignment for premiums | Date | Yes | Accounting |
| COM.21 | AC_END_DATE | The End Date of the Accounting Period. The accounting period is a span of dates used to find the proper protection assignment for premiums | Date | Yes | Accounting |
| COM.22 | DATE_OF_BOOKING | Date of Booking. Should be same as Creation Timestamp (date part) | Date | Yes | Accounting |
| COM.23 | BOOKING_YEAR | Local Booking Year. Fiscal Year | Integer (4) | Yes | Accounting |
| COM.24 | BOOKING_YEAR_2 | Legal Entity Booking Year. Can be the fiscal year for the parent legal entity | Integer (4) | No | Accounting |
| COM.25 | BOOKING_YEAR_3 | Global Booking Year. Can be the fiscal year of the group legal entity | Integer (4) | No | Accounting |
| COM.26 | BOOKING_PERIOD | Period assigned to each accounting entry to refer to the company period closing. Period closing can be expressed in Months, Quarters or half years. The specified frequency can be higher than the official closure frequency (e.g. Months instead of Quarters) for specific reporting needs. Reference data code for: SicsRefBookingPeriod. Reference data subclass Number 10. Can be M01, Q01, etc. Normally expressed in months (Mnn). Available codes: HY1 = 1st Half Year, Q1 = 1st Quarter, HY2 = 2nd Half Year, Q2 = 2nd Quarter, Q3 = 3rd Quarter, Q4 = 4th Quarter, M01 = Month 01, M02 = Month 02, M03 = Month 03, …, M13 = Month 13 | Integer (4) | No | Accounting |
| COM.27 | BOOKING_PERIOD_2 | Booking Period for Legal Entity (see booking year 2). Reference data code for: Booking Period. Reference data subclass Number 10. See above for samples | SICS Reference Data code. String (15) | No | Accounting |
| COM.28 | BOOKING_PERIOD_3 | Booking Period for Global Entity (see booking year 3). Reference data code for: Booking Period. Reference data subclass Number 10. See above for samples | SICS Reference Data code. String (15) | No | Accounting |
| COM.29 | DTL_COMMENT | String - Comment to the booking | String (254) | No | Accounting |
| COM.30 | CEDE | Y/N - IF ‘N’ then does not cede the created accounting booking | Boolean | Yes | Accounting |
| COM.33 | WS_IDENTIFIER | Worksheet Id for reconciliation purpose. If Null is defaulted to Record unique id. | String (40) | No | Accounting |
| COM.34 | WS_TITLE | Worksheet Title | String (30) | No | Accounting |
| COM.35 | IS_ESTIMATE | For estimated figures - default is ‘N’. Will not be Retroceded. | Boolean | No | Accounting |
| COM.36 | UDF_TXT1 | User Defined field, String 01 | String (30) | No | Policy |
| COM.37 | UDF_TXT2 | User Defined field, String 02 | String (30) | No | Policy |
| COM.38 | UDF_TXT3 | User Defined field, String 03 | String (30) | No | Policy |
| COM.105 | UDF_TXT4 | User Defined field, String 04 | String (30) | No | Policy |
| COM.106 | UDF_PCT1 | User Defined field, Percentage | Number (10,6) | No | Policy |
| COM.107 | UDF_PCT2 | User Defined field, Percentage | Number (10,6) | No | Policy |
| COM.108 | UDF_PCT3 | User Defined field, Percentage | Number (10,6) | No | Policy |
| COM.109 | UDF_PCT4 | User Defined field, Percentage | Number (10,6) | No | Policy |
| COM.120 | FSK_UDF_REF_DATA | User Defined field, Reference Data Code | Number (4) | No | Policy |
| COM.121 | FRK_UDF_REF_DATA | User Defined field, Reference Data Item | String (15) | No | Policy |
| COM.110 | FK_UDF_AMT1_CY | User Defined field, Currency for Amount 1. ISO ALPHA 3 | Number (10,6) | No | Policy |
| COM.111 | UDF_AMT1_AMT | User Defined field, Amount 1 | String (3) | No | Policy |
| COM.112 | FK_UDF_AMT2_CY | User Defined field, Currency for Amount 2. ISO ALPHA 3 | Number (10,6) | No | Policy |
| COM.113 | UDF_AMT2_AMT | User Defined field, Amount 2 | String (3) | No | Policy |
| COM.114 | FK_UDF_AMT3_CY | User Defined field, Currency for Amount 3. ISO ALPHA 3 | Number (10,6) | No | Policy |
| COM.115 | UDF_AMT3_AMT | User Defined field, Amount 3 | String (3) | No | Policy |
| COM.116 | FK_UDF_AMT4_CY | User Defined field, Currency for Amount 4. ISO ALPHA 3 | Number (10,6) | No | Policy |
| COM.117 | UDF_AMT4_AMT | User Defined field, Amount 4 | String (3) | No | Policy |
| COM.118 | FK_UDF_AMT5_CY | User Defined field, Currency for Amount 5. ISO ALPHA 3 | Number (10,6) | No | Policy |
| COM.119 | UDF_AMT5_AMT | User Defined field, Amount 5 | String (3) | No | Policy |
| COM.39 | POLICY_ID | Policy unique identifier. Must be an upper case text | String (36) | Yes | Policy |
| COM.40 | POLICY_TITLE | Policy Title | String (30) | No | Policy |
| COM.41 | POLICY_FORMER_ID | Former Identifier | String (50) | No | Policy |
| COM.42 | IP_START | Insured Period Start | Date | Yes | Policy |
| COM.43 | IP_END | Insured Period End | Date | Yes | Policy |
| COM.44 | ORIGINAL_IP_START | Original Insured Period start - informational | Date | No | Policy |
| COM.45 | ORIGINAL_IP_END | Original Insured Period end - informational | Date | No | Policy |
| COM.46 | AUTOMATIC_PROT_ASS | IF “N” then will not be automatically protected by MBPA Order. Needed for policies protected via Facultative protection | Boolean | Yes | Policy |
| COM.47 | REASON_FOR_MANPROT | Reason For Manual Protection. Used to indicate the reason why the business cannot be automatically protected. SicsRefReasonForManualProtection. Subclass no 1073. e.g.: NONE = _ |
SICS Reference Data Code. String (15) | No | Policy |
| COM.48 | SECTION_EXT_ID | Section External Identifier | String (32) | No | Policy |
| COM.49 | SECTION_NAME | Section name. Section is related to the Coverage entity | String (80) | Yes | Policy |
| COM.50 | ATT_FROM | Attachment Period From. The attachment period is a span of dates used to find the proper protection assignment for sections | Date | Yes | Policy |
| COM.51 | ATT_TO | Attachment Period To. The attachment period is a span of dates used to find the proper protection assignment for sections | Date | Yes | Policy |
| COM.52 | SEC_CURRENCY | Currency Code - currency of the Coverage (section). ISO ALPHA 3 or other codes if data mapping feature in use | Date | Yes | Policy |
| COM.53 | MAIN_LIMIT | Main Limit. Insured limit, Insurer responsibility amount - related to the coverage. This limit will be used for the reinsurance allocation | Date | Yes | Policy |
| COM.54 | MAIN_LIMIT_TYPE | Main Limit Type - SicsRefLimit Type - Default to SUM_INS (Sum Insured) - SubclassNumber: 1004. E.g: 100LIMIT = 100% Policy Limit, ANNUAL = Annual, DAMAGE = Damage, DAYS = Days, EML = EML, FOR_MAC = For Machinery, MONTHS = Months, MPL = MPL, OF_LOSS = Of Loss, OF_SUPI = Of Supi, PARTLOSS = Partial Loss, PML = PML | SICS Reference Data Cod. String (15) | No | Policy |
| COM.55 | TOTAL_GROSS_P | Total gross premium. Informational | Decimal (22,2) | No | Policy |
| COM.56 | SHARE_PCT | SHARE can be different from 100% in case of co-insurance. Informational. | Decimal (10,6) | No | Policy |
| COM.57 | COUNTRY | Country of coverage - ISO ALPHA 3 or other codes if data mapping feature in use | ISO Alpha3. String(15) | Yes. Not mandatory if COUNTRY_GRP is given | Classification |
| COM.58 | COUNTRY_GRP | Country Group, e.g. WorldWide. If Country is filled, this value will be ignored | String (15) | No | Classification |
| COM.88 | STATE | State of coverage - ISO ALPHA 3 or other codes if data mapping feature in use. The country containing the state must be given in COUNTRY | ISO Alpha3. String(15) | No | Classification |
| COM.89 | STATE_GRP | State Group. The country containing the state group must be given in COUNTRY | String (15) | No | Classification |
| COM.59 | MCOB | Main Class of Business. Used for classification of a reinsurance business describing the nature of the covered business. SicsRefMainClassOfBusiness. Suclass no 19. E.g.: AVIATION = Aviation, CASUALTY = Casualty, CREDIT = Credit Risk, ENERGY = Energy, LIABILITY = Liability, LIFE = Life, MARINE = Marine, MOTOR = Motor, PROPERTY = Property, SPACE = Space | SICS Reference Data Code. String (15) | Yes | Classification |
| COM.60 | COB | Class Of Business. Categorisation of business depending on Main Class Of Business. SicsRefClassOfBusiness, subclass no 3. e.g. AVIATIONAH = Aviation Aircraft Hull (Aviation), AVIATIONLI = Aviation Liability (Aviation), AVIATIONPA = Aviation Personal Accident (Aviation), CONT = Contingency (Casualty), WC = Workmen’s Compensation (Casualty), LIABGEN = General Liability (Liability), LIABPER = Personal Liability (Liability), LIABPROD = Product Liability (Liability), LIABPROF = Professional Liability (Liability), HEALTH = Health (Life), LIFE = Life (Life), MARINEL = Marine Liability (Marine), MARINELOH = Marine Loss Of Hire Insurance (Marine), MARINEMA = Marine Machinery (Marine), MARINEC = Marine Cargo (Marine, Marine Cargo), MARINEH = Marine Hull (Marine, Marine Hull), MOTORCA = Motor Cargo (Motor), MOTORCO = Motor Commercial (Motor), MOTORLI = Motor Liability (Motor), MOTORPP = Motor Private Passenger (Motor), BI = Business Interruption Ins. (Property), FIRE = Fire Insurance (Property), HAIL = Hail Insurance (Property), LIVESTOCK = Live Stock (Property), ROBBERY = Robbery Insurance (Property), THEFT = Theft Insurance (Property), ENG = Engineering (Property, Engineering) | SICS Reference Data Code. String (15) | Yes | Classification |
| COM.61 | SCOB | Sub Class Of Business. Categorisation of business depending on COB. SicsRefClassOfBusiness, subclass no 50. e.g. ALPASSENGER = Aviation Liability Passenger (Aviation Liability), ALWAR = Aviation Liability War Only (Aviation Liability), ALPRODUCT = Aviation Liability Product (Aviation Liability, Aviation Liability Product), CAREAR = CAR And EAR (Engineering), MACHINERY = Machinery (Engineering), FIRECOM = Fire Commercial (Fire Insurance), FIREIND = Fire Industrial (Fire Insurance), FIREPRI = Fire Private (Fire Insurance), BINTER = Business Interruption (Fire Insurance, Business Interruption), ILLNESS = Critical Illness (Health), DISEASE = Dread Disease (Health), MEDICALEXP = Medical Expenses (Health), ENDOWASS = Endowment Assurance (Life), GROUPLIFE = Group Life (Life), TERMASS = Term Assurance (Life), WHOLELIFE = Whole Life (Life), MCFLAMMABLE = Marine Cargo Flammable (Marine Cargo), MCGOODS = Marine Cargo Goods In Transit (Marine Cargo), MCNONPRESH = Marine Cargo Nonperishable (Marine Cargo), MCPRESH = Marine Cargo Perishable (Marine Cargo), MHPASSENGER = Marine Hull Passenger (Marine Hull), MHTANKER = Marine Hull Tanker (Marine Hull), MHYACHTS = Marine Hull Yachts (Marine Hull), MHCONSTR = Marine Hull Construction (Marine Hull, Marine Hull Construction), MLCARGO = Marine Liability Cargo (Marine Liability), MLHULL = Marine Liability Hull (Marine Liability) | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.62 | ADDL_CLASS_1 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification1. Subclass no 51 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.63 | ADDL_CLASS_2 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification2. Subclass no 53 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.64 | ADDL_CLASS_3 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification3. Subclass no 214 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.65 | ADDL_CLASS_4 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification4. Subclass no 216 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.66 | ADDL_CLASS_5 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification5. Subclass no 218 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.67 | ADDL_CLASS_6 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification6. Subclass no 261 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.68 | ADDL_CLASS_7 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification7. Subclass no 262 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.69 | ADDL_CLASS_8 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification8. Subclass no 263 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.70 | ADDL_CLASS_9 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification9. Subclass no 264 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.71 | ADDL_CLASS_10 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification10. Subclass no 265 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.72 | ADDL_CLASS_11 | Additional Classification. One of the data types reserved for user defined use on the business classification. You can configure this data type with your own name and values and then assign it for use in the business and accounting classifications. SicsRefAdditionalClassification11. Subclass no 266 | SICS Reference Data Code. String (15) | Only if mandatory for Base Company | Classification |
| COM.73 | REP_UNIT_1 | Reporting Unit 1 - Profit Center, often used to distinguish insurer departments. Classification related to the company organisation. | RU Code. String (15) | No | Classification |
| COM.74 | REP_UNIT_2 | Reporting Unit 2 - Segment Code, often used as further specification for profit center. Classification related to the company organisation. | RU Code. String (15) | No | Classification |
| COM.75 | REP_UNIT_3 | Reporting Unit 3 | RU Code. String (15) | No | Classification |
| COM.76 | ORIGIN_OF_BUS | Origin Of Business. Categorisation of insurance/reinsurance being the source of the reinsurance, for example; cession, retrocession, co-insurance. Normal for Cede is “Cession”. Can be specified a different code for specific cession. SicsRefOriginOfBusiness, subclass no 48. Codes: C=Cession, R=Retrocession, CO=Co-Insurance | SICS Reference Data Code. String (15) | Yes | Classification |
| COM.77 | PERIL | Peril - used to cumulate the insurer exposure within geographic zone. Mandatory if catastrophe exposure function is used in SICS. SicsRefPerilType, subclass no 44. e.g: BI = Business Interruption, COLLISION = Collision, DEATH = Death, DIS = Disability, EARTHQUAKE = Earthquake, FP = Failure To Pay, FIRE = Fire, FLOOD = Flood, FRAUD = Fraud, HAIL = Hail, HURRICANE = Hurricane, IMPACT = Impact, LIGHTNING = Lightning, LOH = Loss Of Hire, MBD = Machinery Breakdown, MLH = Marine Loss Of Hire, MD = Material Damage, METEORITE = Meteorite, MC = Motor Collision, MPD = Motor Physical Damage, MUTING = Muting, NOTSPEC = Not Specified, PR = Political Risk, RADIATION = Radiation, ROBBERY = Robbery, SINKING = Sinking, SW = Space Waste, STRANDING = Stranding, SUR = Survival, THEFT = Theft, VANDALISM = Vandalism, WAR = War, WS = Wind Storm | SICS Reference Data Code. String (15) | No | Classification |
| COM.78 | CLAIM_ID | Claim Identifier | String (30) | Yes, if Claim | Claim |
| COM.79 | HL_LOSS_ID | Headline Loss Id. The Headline Loss is a possibility to group claims together. Used for recovery calculation when catastrophe events, e.g. Hurricanes, Earthquake etc. | String (30) | No | Claim |
| COM.80 | HL_LOSS_NAME | Headline Loss Name | String (60) | No | Claim |
| COM.103 | HL_DOL_BEGIN | Headline Loss Date of loss start | Date | No | Claim |
| COM.104 | HL_DOL_END | Headline Loss Date of loss end | Date | No | Claim |
| COM.81 | DOL_BEGIN | Date of loss start. The loss period is a span of dates. These dates are used to find the proper protection assignment for claims | Date | Yes, if Claim | Claim |
| COM.82 | DOL_END | Date of loss end. If a period of loss is not applicable, it can be set equal to DOL_BEGIN | Date | Yes, if Claim | Claim |
| COM.99 | CLMS_TRIG_DT | Claims Trigger Date | Date | No | Claim |
| COM.100 | CLAIMS_TRIG | Claims Trigger Reference Data | String (15) | No | Claim |
| COM.102 | CLAIM_STATUS | Claim Status. Reference Data Table 00517 | String (15) | No | Claim |
| COM.101 | CLAIMANT | Claimant Name | String (40) | No | Claim |
| COM.83 | INCL_IN_REC_ORDER | Include in Recovery order - Yes/No. Default Yes, which indicates that the loss must be included in Recovery Calculation as a single Claim. | Boolean | No | Claim |
| COM.84 | ACC_AS_OF_DATE | Claim As Of Date. Value date. Used to calculate the adjustment booking from a cumulated (as at) booking. Typically used for claim reserves. If not available can be set to booking date | Date | Yes, if Claim | Claim |
| COM.96 | CLAIM_ADVISED_DT | Claim Advised Date | Date | No | Claim |
| COM.85 | CAUSE_OF_LOSS | Cause Of Loss. Used in Claim and Insurable Object. SicsRefClaimCauseOfLoss. Subclass no 523. e.g: ABORTED = Aborted Take-Off, ACTS = Acts Of God, ADVERSE = Adverse Weather, AGENTORANGE = Agent Orange, ARSON = Arson, ASBESTOSIS = Asbestosis, AUTO = Auto Accident, AVALANCHE = Avalanche, BADSTORAGE = Bad Storage, BADSTOWAGE = Bad Stowage, BADWEATHER3 = Bad Weather - In Flight, BADWEATHER2 = Bad Weather - Landing, BADWEATHER1 = Bad Weather - Take-Off, CRIMINAL = Criminal Acts - Fraud, EARTHQUAKE = Earthquake, EXPLOSION = Explosion, FIRE = Fire, FLOOD = Flood, FOG = Fog, FREEZING = Freezing, FROST = Frost, POLITICAL = Political Risks, POLLUTION = Pollution, RAIN = Rain, RIOT = Riot, ROBBERY = Robbery, SABOTAGE = Sabotage, SALVAGE = Salvage, SICKNESS = Sickness | SICS Reference Data Code. String (15) | No | Claim |
| COM.86 | CONSEQUENCE_OF_LOSS | Claim Consequence Of Loss. Used to indicate possible consequences of a loss. SicsRefClaimConsequenceOfLoss. Subclass no 524. e.g: BODYINJURY = Bodily Injury, BURNS = Burns, BUS_ INT = Business Interruption, CLEAN_ASBESTOS = Clean Up Of Asbestos, CONSEQ_DAMAGE = Consequence Damages, PHYSICALDAMAGE = Physical Damage, POLLUTION = Pollution Third Party Damage, PROPERTY = Property Damage, SEENOTES = See Notes, SILICOSIS = Silicosis, VARIOUS = Various | SICS Reference Data Code. String (15) | No | Claim |
| COM.87 | CLAIM_NAME | A Name for the loss | String (60) | Yes, if Claim | Claim |
| COM.92 | RISKNAME | A common Risk Name for multiple claims. With this info the claim recovery can be done per Risk instead of per Event | String (60) | No | Claim |
| COM.122 | CLAIM_SHORT_DESC | A description of the claim | String (254) | No | Claim |
| COM.97 | AUTO_LGT_CL_PT_ASS | Yes/No. If No; Policy section will not be automatically protected by MBPA Order | Boolean | No | Claim |
| COM.98 | REA_LGT_CL_MANPT | Used to indicate the reason why the claim cannot be automatically protected. Reference data table 1073 | String (15) | No | Claim |
| COM.93 | CLAIM_UDF_TXT1 | User Defined fields, String 01 | String (30) | No | Claim |
| COM.94 | CLAIM_UDF_TXT2 | User Defined fields, String 02 | String (30) | No | Claim |
| COM.95 | CLAIM_UDF_TXT3 | User Defined fields, String 03 | String (30) | No | Claim |
P&C Specific Attributes
| ID | Attribute | Description | Data Type | Mandatory |
|---|---|---|---|---|
| PC.01 | PC_LIMIT_INFO1 | Info Limit 1 - Limit amount informational only. Will not be used by the SICS processes. Can be used to store the real policy limit if the Main Limit has been set to store a limit relevant for the reinsurance (e.g. Reinsurance done on the maximum limit of a group of risks / top location) | Integer (22) | No |
| PC.02 | PC_LIMIT_INFO1_TYPE | Info Limit 1 type , SicsRefLimit Type , Subclass no: 1004. See above for samples | SICS Reference Data Code. String (15) | Only if LIMIT_INFO1 is present |
| PC.03 | PC_LIMIT_INFO2 | Info Limit 2 - informational only | Integer (22) | No |
| PC.04 | PC_LIMIT_INFO2_TYPE | Info Limit 2 type , SicsRefLimit Type , Subclass no: 1004. See above for samples | SICS Reference Data Code. String (15) | Only if LIMIT_INFO2 is present |
| PC.05 | PC_DECL_ID | Declaration ID | String (32) | Yes, if other Declaration attributes are filled in |
| PC.06 | PC_DECL_NAME | Declaration Name | String (40) | Yes, if other Declaration attributes are filled in |
| PC.07 | PC_DECL_ATT_FROM | Declaration Attachment Period From | Date | Yes, if other Declaration attributes are filled in |
| PC.08 | PC_DECL_ATT_TO | Declaration Attachment Period To | Date | Yes, if other Declaration attributes are filled in |
| PC.09 | PC_DECL_MAIN_L | Declaration Main Limit | Integer (22) | Yes, if other Declaration attributes are filled in |
| PC.10 | PC_DECL_CURR | Declaration: Currency Code of the Coverage - ISO ALPHA 3 or other codes if data mapping feature in use. If NULL, it will be defaulted to parent section currency | String (15) | No |
| PC.11 | PC_INSURED_ID | Will be used in reports and outward documents | String (20) | No |
| PC.12 | PC_INSURED_NAME | Will be used in reports and outward documents | String (50) | No |
| PC.13 | PC_RUG | Risk Unit Group Identifier. If a Risk Unit Group with this id is absent in SICS, it must be created. Used to group policies to be treated as one reinsurance risk | String (30) | Yes, if other RUG attributes are filled in |
| PC.14 | PC_RUG_NAME | Risk Unit Group Name. See description above | String (40) | Yes, if other RUG attributes are filled in |
| PC.15 | PC_RUG_SEQUENT | RUG: Is sequential (Y/N). Y = Sequential, N = Proportional. | String (1) | Yes, if other RUG attributes are filled in |
| PC.16 | PC_IO_ID | Insurable object Identifier. Valid only for Declaration. Can be e.g. a Vessel name for marine | String (50) | Yes, if IO Name or IO Type are filled in |
| PC.17 | PC_IO_NAME | Insurable object Name. Valid only for Declaration | String (50) | Yes, if IO ID or IO Type are filled in |
| PC.18 | PC_IO_TYPE | Type Of Insurable Object. A data type used internally to determine the type of an insurable object. Valid only for Declaration. SicsRefTypeOfInsurableObject. Subclass no 128. Static ref data. Values: AV = Aviation, BL = Building, EC = CAR/EAR, EL = Electronic, GO = Goods, GR = Group, LB = Livestock And Bloodstock, PR = Person, SP = Space, UD = User Defined, VS = Vessel | SICS Reference Date Code. String (15) | Yes, if IO ID or IO Name are filled in |
| PC.19 | PC_CLAIM_BASIS | Claim Basis - indicates how losses will be evaluated against the insured period. The Claim Basis is implemented on the Claims Business Condition. E.g. CLMMADE = Claims Made, LOSOCCUR = Losses Occurring, RISKATT = Risks Attaching. Informational only (developed for GEN) | SICS Reference Data Code. String (15) | No |
| PC.20 | PC_ASSISTANCE_KEY | Assistance Key, Reference data table 1219. Used when calculating Assistance Coverage Premium based upon OCC LookUpTable, Assistance Key and Number of Insured Objects | String (15) | No |
| PC.21 | PC_NUM_OF_INSRD_OBJ | Number of Insured Objects. Used when calculating Assistance Coverage Premium based upon OCC LookUpTable, Assistance Key and Number of Insured Objects | Integer (3) | No |
| PC.22 | PC_RUG_PROP_GRP | Risk Unit Group (RUG) is Proportional with protection on group level (Y/N). Yes = Proportional, having option Result Saved Per Group selected. No = Proportional, having option Result Saved Per Policy selected | Boolean | No |
| PC.23 | PC_RUG_AUTOMATIC_PROT_ASS | Automatic Protection Assignment flag on RUG group level. No update, effect only when creating new RUG. Inheritance to RUG members. Yes = flag selected, No = flag cleared. | Boolean | Yes, if PC_RUG_PROP_GRP = Yes |
| PC.24 | PC_RUG_REASON_FOR_MANPROT | Reason for Manual Protection on RUG group level when Automatic Protection Assignment flag is cleared. No update, effect only when creating new RUG. Values: SubclassNumber: 01073, SicsRefReasonForManualProtection | SICS Reference Data Code | Yes, if PC_RUG_AUTOMATIC_PROT_ASS = No |
| PC.25 | PC_RUG_TOP_LOCATION | Top Location flag on RUG group level (relevant only if PC_RUG_PROP_GRP = Yes). Effect only when creating new RUG. Yes = flag selected, No = flag cleared | Boolean | No |
| PC.26 | PC_ACCU_EXCL | Is RUG Accumulation excluded for Policy SOC. Functional impact only for policy being member of Proportional RUG with protection on group level (when PC_RUG_PROP_GRP = Yes). Yes = flag selected, No = flag cleared (Default). | Boolean | No |
| PC.27 | PC_PA_INHERIT_EXCL | Is RUG PA Inheritance excluded for Policy SOC. Functional impact only for policy being member of Proportional RUG with protection on group level (when PC_RUG_PROP_GRP = Yes). Yes = flag selected, No = flag cleared (Default). Validation: Cannot be Yes unless PC_ACCU_EXCL also is Yes. | Boolean | No |
Life Specific Attributes
| ID | Attribute | Description | Data Type | Mandatory |
|---|---|---|---|---|
| LF.01 | LF_TRANS_TYPE | Identifies the type of transaction that affects the calculations of ceded premium in case of Risk-Premium-Reinsurance. Can be associated in SICS to one or more between this 4 behaviors: Initial Premium, Premium Calculation, Premium Recalculation, Protection Assignment Calculation. SicsRefTransactionType. Subclass no 1131. E.g. NEWBUS for “New Business”, AMEND for “Amendment”, TERMINATION for “Termination”, RENEWAL for “Renewal” | SICS Reference Data Code. String (15) | Yes |
| LF.02 | LF_SAR | Sum At Risk | Integer (22) | Yes |
| LF.03 | LF_XTRA_MORTAL_PCT | Extra Mortality / Morbidity percentage | Decimal (10,6) | Yes |
| LF.04 | LF_OTHER_XTRA_PREM | Other extra premium percentage | Decimal (10,6) | Yes |
| LF.05 | LF_CALC_BASIS | Calculation Basis. Option defining how Other Extra Premium is expressed. SicsRefOtherExtraPremiumOption. Subclass no 1172. E.g. PCS = Per Cent of SAR, PMS = Per Mile of SAR, FOS = Factor of SAR | SICS Reference Data Code. String (15) | Yes |
| LF.06 | LF_AGE | Age of insured | Integer (3) | Yes |
| LF.07 | LF_RETIREMENT_AGE | Retirement Age of insured | Integer (3) | No |
| LF.08 | LF_SMOKER_STATUS | Available Dimension for Premium Tables. Smoker/Non Smoker. Can be code for NONE. SicsRefSmokerStatus, subclass no 1133. E.g. SMOKER, NONSMOKER | SICS Reference Data Code. String (15) | Yes |
| LF.09 | LF_OCCUPATION_CLS | Available Dimension for Premium Tables. Related to the risk associated to the worker. Can be NONE. SicsRefOccupationClass, subclass no 1134. E.g. CLASS1, CLASS2, … | SICS Reference Data Code. String (15) | Yes |
| LF.10 | LF_RISK_CLASS | Available Dimension for Premium Tables. Related to the class of risk. Can be NONE. SicsRefRiskClass, subclass no 1128. e.g. CLASS1, CLASS2, … | SICS Reference Data Code. String (15) | Yes |
| LF.11 | LF_DISABILITY_CLS | Available Dimension for Premium Tables. Related to the class of disability. Can be code for NONE. SicsRefDisabilityClass, subclass no 1129. E.g. CLASS1, CLASS2, … | SICS Reference Data Code. String (15) | Yes |
| LF.12 | LF_ESCALATION | Available Dimension for Premium Tables. Can be code for NONE. SicsRefEscalation, subclass no 1171 | SICS Reference Data Code. String (15) | Yes |
| LF.13 | LF_IAB_IDENTIFIER | Link to an Assumed Business. Mandatory in case of Origin of business is Retrocession | String (36) | Yes, if Origin of business is Retrocession |
| LF.14 | LF_IAB_BEGIN_DATE | Insured period start date of an Assumed Business | Date | Yes, if Origin of business is Retrocession |
| LF.15 | LF_IO_PERSON_ID | Person Unique identifier | String (15) | Yes |
| LF.16 | LF_IO_PERSON_NAME | Person Name | String (50) | Yes |
| LF.17 | LF_IO_ALIAS | Person Name Alias | String (82) | No |
| LF.18 | LF_IO_DT_OF_BIRTH | Date of birth | Date | Yes |
| LF.19 | LF_IO_BIRTH_COUNTRY | Country of coverage - ISO Alpha 3 or other codes if data mapping feature in use | ISO Alpha 3 - String (15) | No |
| LF.20 | LF_IO_NATIONALITY | Country of coverage - ISO Alpha 3 or other codes if data mapping feature in use | ISO Alpha 3 - String (15) | No |
| LF.21 | LF_IO_PERSON_STATUS | User Defined. Person status. SicsRefInsurableObjectPersonStatus, subclass no 1130. E.g. ALIVE = Alive, DEAD = Dead, DISABILITY = Disability, DISABLED = Disabled Permanently, NORMAL = Normal, TEMPILL = Temporarily ill | SICS Reference Data Code. String (15) | No |
| LF.22 | LF_IO_GENDER | Code for gender. M for Male, F for Female. SicsRefSex, subclass no 15 | SICS Reference Data Code. String (15) | Yes |