| 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) | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
2 | ICLCLAIMDATA | Suppl. Reserves: Claim File | 4 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
3 | ICLCLAIMDATA_OUT | Suppl. Res.: Reserving Results at Indicative Level | 5 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
4 | ICLDRIVER1 | Example 1 for IBNR Driver Table | 3 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
5 | ICLHISTDATA | Suppl. Reserves: History Data | 6 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
6 | ICLIBNRQUART | IBNR: Reserves Table | 7 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
7 | ICLINDRESI | Claim-Independent Reserve | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
8 | ICLULAEACCRES | Additional Reserve Amounts at Claim Year and Coverage Level | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
9 | ICLULAECOVRES | Determined Additional Reserve Amounts at Coverage Level | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
10 | ICLULAEDRIVER1 | Reported Distribution Key 1 | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
11 | ICLULAEDRIVER2 | Reported Distribution Key 2 | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
12 | ICLULAEPERCENT | Determined Percentage and Additional Reserve Amounts | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
13 | ICLULAEREPPAY | Reported Settlement Expenses | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
14 | ICLULAERES | Current Reassigned Reserves (ULAE) | 8 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
15 | ICL_IBNR_RESULT | IBNR Reserves | 21 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
16 | TICL821 | Entity Table: Line of Insurance | 2 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
17 | TICL821T | Text Table 820T | 3 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
18 | TICL826 | Line of Insurance/Coverage: Permitted Combination Suppl.Res | 2 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
19 | TICL827 | CoCde/Ins.Line/RegOff/State: Permitted Combinations | 3 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
20 | TICL834 | CoCde/State/LineProd/Coverage: Permitted Combinations | 4 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
21 | TICL848 | IBNR: Loss/Expense Percentages | 3 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
22 | TICL849 | IBNR: Loss/Expense Percentages | 3 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |
23 | TICL850 | IBNR: Loss/Expense Percentage Rate | 3 | LINEOFINS | Line of Insurance | nvarchar | 10 | 0 | | |