| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLDAMOBJ | Damaged Object | 11 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
2 | ICLPOLL | Limit and Deductible in Policy Snapshot | 7 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
3 | ICLPOLN | Assign Insured Object to Coverage | 5 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
4 | ICLPOLO | Insured Object in Policy Snapshot | 5 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
5 | ICLPOLOAU | Insured Vehicle | 5 | INSUREDOBJ | Insured Vehicle | nvarchar | 4 | 0 | | |
6 | ICLPOLOPE | Insured Equipment | 5 | INSUREDOBJ | Insured equipment | nvarchar | 4 | 0 | | |
7 | ICLPOLORE | Insured Building | 5 | INSUREDOBJ | Insured Building | nvarchar | 4 | 0 | | |
8 | ICLPOLOSI | Insured Site | 5 | INSUREDOBJ | Insured Site | nvarchar | 4 | 0 | | |
9 | ICLPOLOWA | Insured Watercraft | 5 | INSUREDOBJ | Insured watercraft | nvarchar | 4 | 0 | | |
10 | ICLPOLS | Sums Insured and Calculations in Policy Snapshot | 7 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
11 | ICLSUBCL | Subclaim | 49 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
12 | ICSDAMOBJ | Damaged Object | 11 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
13 | ICSPOLL | Limit and Deductible in Policy Snapshot | 7 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
14 | ICSPOLN | Assign Insured Object to Coverage | 5 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
15 | ICSPOLO | Insured Object in Policy Snapshot | 5 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
16 | ICSPOLOAU | Insured Vehicle | 5 | INSUREDOBJ | Insured Vehicle | nvarchar | 4 | 0 | | |
17 | ICSPOLOPE | Insured Equipment | 5 | INSUREDOBJ | Insured equipment | nvarchar | 4 | 0 | | |
18 | ICSPOLORE | Insured Building | 5 | INSUREDOBJ | Insured Building | nvarchar | 4 | 0 | | |
19 | ICSPOLOSI | Insured Site | 5 | INSUREDOBJ | Insured Site | nvarchar | 4 | 0 | | |
20 | ICSPOLOWA | Insured Watercraft | 5 | INSUREDOBJ | Insured watercraft | nvarchar | 4 | 0 | | |
21 | ICSPOLS | Sums Insured and Calculations in Policy Snapshot | 7 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
22 | ICSSUBCL | Subclaim | 49 | INSUREDOBJ | Insured Object Number | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
23 | /GSINS/PSR_POLAU | Policy Snapshot Vehicle Additional Information | 5 | INSUREDOBJ | Insured Vehicle | nvarchar | 4 | 0 | | |