| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLALAERES | Current Reserves (Settlement Expenses (ALAE) and Losses) | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
2 | ICLCLAIMDATA | Suppl. Reserves: Claim File | 6 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
3 | ICLCLAIMDATA_OUT | Suppl. Res.: Reserving Results at Indicative Level | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
4 | ICLHISTDATA | Suppl. Reserves: History Data | 8 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
5 | ICLINDRESI | Claim-Independent Reserve | 11 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
6 | ICLULAEACCRES | Additional Reserve Amounts at Claim Year and Coverage Level | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
7 | ICLULAECOVRES | Determined Additional Reserve Amounts at Coverage Level | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
8 | ICLULAEDRIVER1 | Reported Distribution Key 1 | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
9 | ICLULAEDRIVER2 | Reported Distribution Key 2 | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
10 | ICLULAEPERCENT | Determined Percentage and Additional Reserve Amounts | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
11 | ICLULAEREPPAY | Reported Settlement Expenses | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
12 | ICLULAERES | Current Reassigned Reserves (ULAE) | 7 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
13 | ICL_IBNR_RESULT | IBNR Reserves | 24 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
14 | TICL824 | Entity Table: Regional Office | 2 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
15 | TICL824T | Text Table 824T | 3 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |
16 | TICL827 | CoCde/Ins.Line/RegOff/State: Permitted Combinations | 4 | REGOFFICE | Regional Office | nvarchar | 4 | 0 | | |