| 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) | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
2 | ICLINDRESI | Claim-Independent Reserve | 24 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
3 | ICLULAEACCRES | Additional Reserve Amounts at Claim Year and Coverage Level | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
4 | ICLULAECOVRES | Determined Additional Reserve Amounts at Coverage Level | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
5 | ICLULAEDRIVER1 | Reported Distribution Key 1 | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
6 | ICLULAEDRIVER2 | Reported Distribution Key 2 | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
7 | ICLULAEPERCENT | Determined Percentage and Additional Reserve Amounts | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
8 | ICLULAEREPPAY | Reported Settlement Expenses | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
9 | ICLULAERES | Current Reassigned Reserves (ULAE) | 12 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
10 | TICL831 | Entity Table: Collective Account Based on Chart of Accounts | 2 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
11 | TICL831T | Text Table Collective Account | 3 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |
12 | TICL832 | Entity Table: G/L Account (Chart of Accts and Coll.Account) | 4 | ACCTSUM | Collective Account for Reserve Reallocation (LAE) | nvarchar | 10 | 0 | | |