| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLCLAIM | Claim | 59 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
2 | ICLSUBCL | Subclaim | 37 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
3 | ICLSUBCLCL | Obsolete - Internal Claim Types, Contracts of Int.Claim Type | 12 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
4 | ICSCLAIM | Claim | 59 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
5 | ICSSUBCL | Subclaim | 37 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
6 | ICSSUBCLCL | Internal Claim Types, Contracts of Internal Claim Type | 12 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
7 | TICL005 | Internal Claim Type: Permitted Subclaim Type | 18 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
8 | TICL100 | Internal Claim Type - Permitted Coverage Type | 9 | BENTREE | Different Benefit Type Tree | nvarchar | 8 | 0 | | |
9 | TICL159 | Benefit Type Tree | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
10 | TICL160 | Generation of Benefit Type Tree | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
11 | TICL160T | Generation of Benefit Type Tree - Text | 3 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
12 | TICL161 | Version of Benefit Type Tree | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
13 | TICL161T | Version of Benefit Type Tree - Text | 3 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
14 | TICL162 | Benefit Type Tree: Permitted Benefit Type | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
15 | TICL163 | Benefit Type Tree: Limit and Deductible | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
16 | TICL164 | Benefit Type Tree: Permitted Object Type | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
17 | TICL165 | Benefit Type Tree: Definition of Payment Reason Group | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
18 | TICL167 | Benefit Type Tree: Sum Insured and Calculation Rules | 2 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |
19 | TICL321 | Policy Product Version | 24 | BENTREE | Benefit Type Tree at Policy Product Level | nvarchar | 8 | 0 | | |
20 | TICL323 | Policy Product: Permitted Coverage Type | 12 | BENTREE | Benefit Type Tree | nvarchar | 8 | 0 | | |