| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLIBNRHEALTHCLU | Cases, Quantities, and Costs (Totalled) at Evaluation Level | 4 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
2 | ICLIBNRHEALTHDET | Quantities and Costs (Totalled, if Nec) at Single Case Level | 4 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
3 | ICLIBNRHEALTHDRI | Standard Driver for Single Case Level | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
4 | ICLIBNRHEALTHSTA | Statistics: Cases, Quantities and Costs at Evaluation Level | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
5 | ICL_IBNRCLUSTER | Reserve Cluster Allocation (IBNR) | 4 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
6 | ICL_IBNRCLUSTERT | All Data for Reserve Group Clusters | 4 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
7 | ICL_IBNRDIRECT | Entries for "Direct" IBNR Reserve Definition | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
8 | ICL_IBNR_RESULT | IBNR Reserves | 4 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
9 | TICL840 | Allocation of Indicatives to Reserve Group Types | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
10 | TICL841 | ResGpType/ResGp -> Indicative Values | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
11 | TICL842 | Reserve Cluster Allocation (IBNR) | 4 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
12 | TICL843 | Allocation: Reserve Group Cluster to Reserve Groups | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
13 | TICL844 | ResGpType/ResGpCluster/ResGp | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
14 | TICL845 | Reserves for Allocation per Reserve Group | 4 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
15 | TICL847 | Assignment of Reserve Groups to Reserve Group Clusters | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
16 | TICL856 | Reserving per Reserve Group Cluster | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
17 | TICL858 | Distribution Percentages for Incident Years | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
18 | TICL859 | Cost Allocation Percentage Rates for Incident Years | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
19 | TICL860 | Reserve Group Category | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
20 | TICL860T | Name of Reserve Group Type | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
21 | TICL861 | Reserve Group: General Features | 2 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
22 | TICL861T | Name of Reserve Group Type | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
23 | TICL863 | IBNR Driver | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
24 | TICL864 | Reserve Group Cluster | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
25 | TICL867 | Version for Reserve Group Cluster | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
26 | TICL870 | Distribution Percentages for Incident Years | 3 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |
27 | TICL873 | Sequence of Procedures for Reserving | 5 | RESGRTYPE | Reserve Group Category | nvarchar | 10 | 0 | | |