| 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 | 6 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
2 | ICLIBNRHEALTHDET | Quantities and Costs (Totalled, if Nec) at Single Case Level | 6 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
3 | ICLIBNRHEALTHDRI | Standard Driver for Single Case Level | 4 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
4 | ICLIBNRHEALTHSTA | Statistics: Cases, Quantities and Costs at Evaluation Level | 4 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
5 | ICL_IBNRCLUSTER | Reserve Cluster Allocation (IBNR) | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
6 | ICL_IBNRCLUSTERT | All Data for Reserve Group Clusters | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
7 | TICL842 | Reserve Cluster Allocation (IBNR) | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
8 | TICL843 | Allocation: Reserve Group Cluster to Reserve Groups | 3 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
9 | TICL844 | ResGpType/ResGpCluster/ResGp | 3 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
10 | TICL847 | Assignment of Reserve Groups to Reserve Group Clusters | 4 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
11 | TICL856 | Reserving per Reserve Group Cluster | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
12 | TICL858 | Distribution Percentages for Incident Years | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
13 | TICL859 | Cost Allocation Percentage Rates for Incident Years | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
14 | TICL864 | Reserve Group Cluster | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
15 | TICL868 | Entity Table: Reserve Group Cluster | 2 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
16 | TICL868T | Reserve Group Cluster | 3 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
17 | TICL870 | Distribution Percentages for Incident Years | 5 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |
18 | TICL873 | Sequence of Procedures for Reserving | 7 | RESGRCLUSTER | Reserve Group Cluster | nvarchar | 10 | 0 | | |