| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ICLCCEVENTCO | Multiple Contract Handling - Contract Overview | 18 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
2 | ICL_MC_INC_COVT | Mapping of Incident-Specific Fields to Subclaim Type | 4 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
3 | ICSCCEVENTCO | Bearbeitung mehrerer Verträge - Vertragsübersicht | 18 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
4 | TICL600 | Mapping: Condition Fields for Rule Variant | 4 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
TOPClaims Management |
5 | ICLDIPL | Distribution Plan | 16 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
6 | ICLDRGITEM | DRG Item | 9 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
7 | ICLITEM | Claim Item | 12 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
8 | ICLPAYI | Claim Payment Item | 14 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
9 | ICLPOLM | Coverage in Policy Snapshot | 9 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
10 | ICSDIPL | Distribution Plan (Shadow Table) | 16 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
11 | ICSDRGITEM | DRG Item | 9 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
12 | ICSITEM | Claim Item | 12 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
13 | ICSPAYI | Payment Item | 14 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
14 | ICSPOLM | Coverage in Policy Snapshot | 9 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
15 | TICL083 | Internal Claim Type: Limit and Deductible | 17 | COVTYPE | Coverage Type of Reference Limit in Contract | nvarchar | 10 | 0 | | |
16 | TICL100 | Internal Claim Type - Permitted Coverage Type | 6 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
17 | TICL163 | Benefit Type Tree: Limit and Deductible | 17 | COVTYPE | Coverage Type of Reference Limit in Contract | nvarchar | 10 | 0 | | |
18 | TICL166 | Dependent Benefit Types | 5 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
19 | TICL322 | Coverage Type | 2 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
20 | TICL322T | Coverage Type Text | 3 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |
21 | TICL323 | Policy Product: Permitted Coverage Type | 7 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | |