| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLIBNRHEALTHDET | Quantities and Costs (Totalled, if Nec) at Single Case Level | 7 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
2 | ICLIBNRHEALTHDRI | Standard Driver for Single Case Level | 5 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
3 | ICL_IBNRCLUSTER | Reserve Cluster Allocation (IBNR) | 6 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
4 | ICL_IBNRDIRECT | Entries for "Direct" IBNR Reserve Definition | 5 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
5 | TICL841 | ResGpType/ResGp -> Indicative Values | 3 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
6 | TICL842 | Reserve Cluster Allocation (IBNR) | 6 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
7 | TICL844 | ResGpType/ResGpCluster/ResGp | 4 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
8 | TICL845 | Reserves for Allocation per Reserve Group | 5 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
9 | TICL847 | Assignment of Reserve Groups to Reserve Group Clusters | 5 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
10 | TICL856 | Reserving per Reserve Group Cluster | 6 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
11 | TICL858 | Distribution Percentages for Incident Years | 6 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
12 | TICL859 | Cost Allocation Percentage Rates for Incident Years | 6 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
13 | TICL861 | Reserve Group: General Features | 3 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
14 | TICL861T | Name of Reserve Group Type | 4 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
15 | TICL866 | Reserve Group Definition | 2 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
16 | TICL866T | Name of Reserve Group Type | 3 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
17 | TICL870 | Distribution Percentages for Incident Years | 6 | RESGR | Reserve Group (IBNR) | nvarchar | 25 | 0 | | |
TOPCross-Application Components |
18 | CCRHD | Work Center Header | 123 | RESGR | Matrix identification | nvarchar | 8 | 0 | | |
TOPWork Center |
19 | CRHD | Work Center Header | 123 | RESGR | Matrix identification | nvarchar | 8 | 0 | | |