| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ICLBPBUNDLE | Archived ICLCCEVENTB Entries per Business Partner | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
2 | ICLCCEVENTCO | Multiple Contract Handling - Contract Overview | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
3 | ICLEMC | Values of Claim Bundle "Multiple Contract Handling" | 4 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
4 | ICSCCEVENTCO | Bearbeitung mehrerer Verträge - Vertragsübersicht | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
5 | ICSEMC | Shadow Table: Values from Multiple Contract Handling | 4 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
TOPClaims Management |
6 | ICLCCEVENT | Claim Bundle | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
7 | ICLCCEVENTB | Claim Bundle - Participant Occurrence | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
8 | ICLCCEVENTL | Claim Bundle - Location Address - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
9 | ICLCCEVENTP | Claim Bundle - Policy - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
10 | ICLCCEVENTR | Claim Bundle - Region - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
11 | ICLCCEVENTU | Claim Bundle - Assigned Claims Sum | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
12 | ICLCCEVENTZ | Claim Bundle - Postal Code - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
13 | ICLCCEVPAY | Claim Bundle - Payment Sum | 2 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
14 | ICLCCEVRES | Claim Bundle - Reserve Sum | 2 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
15 | ICLEACTIVITY | Tasks in Claim Bundle | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
16 | ICLEALDD | Assignment of Archive Link Document to Claim Bundle | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
17 | ICLEBULKSBR | Coll.Subro/Recovery Settlement | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
18 | ICLEEXPLANATIONC | Values of Expressions per Bundle-Explanation (Cluster Table) | 4 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
19 | ICLINDRESC | Claim-Independent Reserve-Cumulative Reserve-Assignment | 4 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
20 | ICSCCEVENT | Shadow Table Claim Bundle | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
21 | ICSCCEVENTB | Claim Bundle - Participant Occurrence | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
22 | ICSCCEVENTL | Claim Bundle - Location Address - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
23 | ICSCCEVENTP | Claim Bundle - Policy - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
24 | ICSCCEVENTR | Claim Bundle - Region - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
25 | ICSCCEVENTU | Claim Bundle - Assigned Claims Sum | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
26 | ICSCCEVENTZ | Claim Bundle - Postal Code - Assignment | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
27 | ICSCCEVPAY | Claim Bundle - Payment Sum | 2 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
28 | ICSCCEVRES | Claim Bundle - Reserve Sum | 2 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
29 | ICSEACTIVITY | Task in Claim Bundle Shadow Table | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
30 | ICSEALDD | Assign Archive Link Document to Claim Subobject | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |
31 | ICSEBULKSBR | Shadow Table Collective Subrogation/Recovery Settlement | 3 | CCEVENT | Claim Bundle | nvarchar | 17 | 0 | | |