| 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) | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
2 | ICLCLAIMDATA | Suppl. Reserves: Claim File | 3 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
3 | ICLCLAIMDATA_OUT | Suppl. Res.: Reserving Results at Indicative Level | 4 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
4 | ICLDRIVER2 | Example 2 for IBNR Driver Table | 3 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
5 | ICLHISTDATA | Suppl. Reserves: History Data | 5 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
6 | ICLINDRESI | Claim-Independent Reserve | 7 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
7 | ICLULAEACCRES | Additional Reserve Amounts at Claim Year and Coverage Level | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
8 | ICLULAECOVRES | Determined Additional Reserve Amounts at Coverage Level | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
9 | ICLULAEDRIVER1 | Reported Distribution Key 1 | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
10 | ICLULAEDRIVER2 | Reported Distribution Key 2 | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
11 | ICLULAEPERCENT | Determined Percentage and Additional Reserve Amounts | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
12 | ICLULAEREPPAY | Reported Settlement Expenses | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
13 | ICLULAERES | Current Reassigned Reserves (ULAE) | 6 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
14 | ICL_IBNR_RESULT | IBNR Reserves | 20 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
15 | TICL820 | Entity Table: Product Group | 2 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
16 | TICL820T | Text Table 820T | 3 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
17 | TICL821 | Entity Table: Line of Insurance | 3 | PRDGRP | Product Group | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
18 | NLDBC_DECL | IS-H NL: Deklaration kode | 3 | PRDGRP | IS-H NL: Productcode | nvarchar | 10 | 0 | | |
19 | NLDBC_RELATION | IS-H NL: DBC Beziehungen | 10 | PRDGRP | IS-H NL: Productcode | nvarchar | 10 | 0 | | |