| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPPSSRM/PRMP | Permission assignment | 2 | ASSIGN_GUID | GUID Key for Permissions | varbinary | 16 | 0 | | |
2 | ICLCCEVENTCO | Multiple Contract Handling - Contract Overview | 6 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
3 | ICSCCEVENTCO | Bearbeitung mehrerer Verträge - Vertragsübersicht | 6 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
TOPClaims Management |
4 | ICLCLAIM | Claim | 69 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
5 | ICLDIAGNOSIS | Diagnoses Made | 30 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
6 | ICLITEM | Claim Item | 58 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
7 | ICLNOTE | Claim Note | 24 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
8 | ICLPART | Participants | 16 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
9 | ICLPARTOCC | Participant Occurrence | 14 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
10 | ICLPARTWC | Participant, Additional Info.: Workers Compensation | 49 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
11 | ICLPAY | Claim Payment | 60 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
12 | ICLPAYEE | Additional Payee | 17 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
13 | ICLPAYI | Claim Payment Item | 30 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
14 | ICLPOL | Policy Snapshot | 32 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
15 | ICLPOLBF | Benefit Types in Policy Snapshot | 12 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
16 | ICLPOLL | Limit and Deductible in Policy Snapshot | 28 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
17 | ICLPOLM | Coverage in Policy Snapshot | 19 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
18 | ICLPOLO | Insured Object in Policy Snapshot | 15 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
19 | ICLPOLS | Sums Insured and Calculations in Policy Snapshot | 25 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
20 | ICLPROCURE | Claim Item Groupings | 66 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
21 | ICLRESERVE | Case Reserve | 22 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
22 | ICLSUBCL | Subclaim | 42 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
23 | ICSCLAIM | Claim | 69 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
24 | ICSDIAGNOSIS | Diagnoses | 30 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
25 | ICSITEM | Claim Item | 58 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
26 | ICSNOTE | Note | 24 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
27 | ICSPART | Participant in Claim | 16 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
28 | ICSPARTOCC | Claim Participant Occurrence | 14 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
29 | ICSPARTWC | Workers Compensation: Additional Info on Claim Participant | 49 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
30 | ICSPAY | Payment | 60 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
31 | ICSPAYEE | Additional Payee | 17 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
32 | ICSPAYI | Payment Item | 30 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
33 | ICSPOL | Policy Snapshot | 32 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
34 | ICSPOLBF | Benefit Types in Policy Snapshot (Shadow Table) | 12 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
35 | ICSPOLL | Limit and Deductible in Policy Snapshot | 28 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
36 | ICSPOLM | Coverage in Policy Snapshot | 19 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
37 | ICSPOLO | Insured Object in Policy Snapshot | 15 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
38 | ICSPOLS | Sums Insured and Calculations in Policy Snapshot | 25 | ASSIGN_GUID | GUID of Length 32 | nvarchar | 32 | 0 | | |
39 | ICSPROCURE | Claim Item Groupings | 66 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
40 | ICSRESERVE | Case Reserve | 22 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
41 | ICSSUBCL | Subclaim | 42 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | |
TOPInterface to External Project Software |
42 | RIASSIGNMENTS | Assignment Table of Replication cProject PS | 2 | ASSIGN_GUID | GUIDs for Assigning cProject PS | varbinary | 16 | 0 | | |
TOPSAP Multiresource Scheduling |
43 | /MRSS/D_POT_LINK | links Service order <-> Capacity Pot | 10 | ASSIGN_GUID | GUID | varbinary | 16 | 0 | | |