| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ICLCCEVENTCO | Multiple Contract Handling - Contract Overview | 16 | COVERAGE | Unique Coverage Number | nvarchar | 17 | 0 | | |
2 | ICSCCEVENTCO | Bearbeitung mehrerer Verträge - Vertragsübersicht | 16 | COVERAGE | Unique Coverage Number | nvarchar | 17 | 0 | | |
TOPASAP Tools and Contents |
3 | SMAPPR0COV | Solution Map: Process - % coverage (SAP/Partner) | 4 | COVERAGE | Solution Map: % coverage by SAP | nvarchar | 40 | 0 | | |
TOPClaims Management |
4 | ICLALAERES | Current Reserves (Settlement Expenses (ALAE) and Losses) | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
5 | ICLCLAIMDATA | Suppl. Reserves: Claim File | 5 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
6 | ICLCLAIMDATA_OUT | Suppl. Res.: Reserving Results at Indicative Level | 6 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
7 | ICLDRGITEM | DRG Item | 13 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
8 | ICLHISTDATA | Suppl. Reserves: History Data | 7 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
9 | ICLIBNRQUART | IBNR: Reserves Table | 8 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
10 | ICLINDRESI | Claim-Independent Reserve | 9 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
11 | ICLITEM | Claim Item | 16 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
12 | ICLPOLBF | Benefit Types in Policy Snapshot | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
13 | ICLPOLL | Limit and Deductible in Policy Snapshot | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
14 | ICLPOLM | Coverage in Policy Snapshot | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
15 | ICLPOLN | Assign Insured Object to Coverage | 6 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
16 | ICLPOLS | Sums Insured and Calculations in Policy Snapshot | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
17 | ICLSUBCL | Subclaim | 27 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
18 | ICLULAEACCRES | Additional Reserve Amounts at Claim Year and Coverage Level | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
19 | ICLULAECOVRES | Determined Additional Reserve Amounts at Coverage Level | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
20 | ICLULAEDRIVER1 | Reported Distribution Key 1 | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
21 | ICLULAEDRIVER2 | Reported Distribution Key 2 | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
22 | ICLULAEPERCENT | Determined Percentage and Additional Reserve Amounts | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
23 | ICLULAEREPPAY | Reported Settlement Expenses | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
24 | ICLULAERES | Current Reassigned Reserves (ULAE) | 11 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
25 | ICL_IBNR_RESULT | IBNR Reserves | 22 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
26 | ICL_PRIVILEGE | Special Rights (Benefit/3rd Party Rights) in Benefit Split | 11 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
27 | ICSDRGITEM | DRG Item | 13 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
28 | ICSITEM | Claim Item | 16 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
29 | ICSPOLBF | Benefit Types in Policy Snapshot (Shadow Table) | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
30 | ICSPOLL | Limit and Deductible in Policy Snapshot | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
31 | ICSPOLM | Coverage in Policy Snapshot | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
32 | ICSPOLN | Assign Insured Object to Coverage | 6 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
33 | ICSPOLS | Sums Insured and Calculations in Policy Snapshot | 5 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
34 | ICSSUBCL | Subclaim | 27 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
35 | ICS_PRIVILEGE | Special Rights (Shadow Table) | 11 | COVERAGE | Coverage | nvarchar | 4 | 0 | | |
36 | TICL816 | Limit Determination Method for RATIO Method | 2 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
37 | TICL822 | Entity Table: Coverage | 2 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
38 | TICL822T | Text Table 820T | 3 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
39 | TICL826 | Line of Insurance/Coverage: Permitted Combination Suppl.Res | 3 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
40 | TICL834 | CoCde/State/LineProd/Coverage: Permitted Combinations | 5 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
41 | TICL848 | IBNR: Loss/Expense Percentages | 4 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
42 | TICL850 | IBNR: Loss/Expense Percentage Rate | 4 | COVERAGE | Coverage (Indicative for Background Reserve) | nvarchar | 4 | 0 | | |
TOPStakeholder Relationship Management |
43 | USS_COVERAGE | Coverage (Industries, Regions) | 2 | COVERAGE | Coverage of the Stakeholder | nvarchar | 3 | 0 | | |
44 | USS_STH_COVER | SEM-SRM: Relationship Stakeholder and Coverage | 3 | COVERAGE | Coverage of the Stakeholder | nvarchar | 3 | 0 | | |
45 | USS_TCOVERAGE | SRM: Coverage Text | 3 | COVERAGE | Coverage of the Stakeholder | nvarchar | 3 | 0 | | |