| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLCLAUSE | Clauses | 13 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
2 | ICLDIPL | Distribution Plan | 15 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
3 | ICLPOL | Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
4 | ICLPOLBF | Benefit Types in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
5 | ICLPOLL | Limit and Deductible in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
6 | ICLPOLM | Coverage in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
7 | ICLPOLN | Assign Insured Object to Coverage | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
8 | ICLPOLO | Insured Object in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
9 | ICLPOLOAU | Insured Vehicle | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
10 | ICLPOLOPE | Insured Equipment | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
11 | ICLPOLORE | Insured Building | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
12 | ICLPOLOSI | Insured Site | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
13 | ICLPOLOWA | Insured Watercraft | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
14 | ICLPOLS | Sums Insured and Calculations in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
15 | ICSCLAUSE | Clauses (Shadow Table) | 13 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
16 | ICSDIPL | Distribution Plan (Shadow Table) | 15 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
17 | ICSPOL | Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
18 | ICSPOLBF | Benefit Types in Policy Snapshot (Shadow Table) | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
19 | ICSPOLL | Limit and Deductible in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
20 | ICSPOLM | Coverage in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
21 | ICSPOLN | Assign Insured Object to Coverage | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
22 | ICSPOLO | Insured Object in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
23 | ICSPOLOAU | Insured Vehicle | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
24 | ICSPOLOPE | Insured Equipment | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
25 | ICSPOLORE | Insured Building | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
26 | ICSPOLOSI | Insured Site | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
27 | ICSPOLOWA | Insured Watercraft | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
28 | ICSPOLS | Sums Insured and Calculations in Policy Snapshot | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
TOPFinancial Services Localization |
29 | /GSINS/PSR_NDRVC | Policy Snapshot - Driver's License Classes of Named Drivers | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
30 | /GSINS/PSR_NDRVL | Named Driver's Additional Info | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |
31 | /GSINS/PSR_POLAU | Policy Snapshot Vehicle Additional Information | 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | |