| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ICLCCEVENTCO | Multiple Contract Handling - Contract Overview | 22 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
2 | ICL_CPROCDOC | Internal Claim Type: Manual Claim Document per CIG Category | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
3 | ICSCCEVENTCO | Bearbeitung mehrerer Verträge - Vertragsübersicht | 22 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
TOPClaims Management |
4 | ICLCLAIM | Claim | 25 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
5 | ICL_CNOTE_CTYPE | Internal Claim Type: Permitted Communication Type | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
6 | ICL_CNOTE_TEMPL1 | Internal Claim Type: Permitted Text Templates | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
7 | ICL_CNOTE_TYPE | Internal Claim Type: Permitted Topic of Claim Note | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
8 | ICSCLAIM | Claim | 25 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
9 | TICL003 | Internal Claim Type Version | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
10 | TICL003T | Version of Internal Claim Type Text | 4 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
11 | TICL005 | Internal Claim Type: Permitted Subclaim Type | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
12 | TICL009 | Internal Claim Type: Permitted Cause of Claim | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
13 | TICL011T | Generation of Internal Claim Type Text | 4 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
14 | TICL027 | Internal Claim Type: Permitted Subclaim Complexity | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
15 | TICL043 | Internal Claim Type: Permitted Claim Item Rejection Reason | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
16 | TICL045 | Internal Claim Type: Permitted Manual Task/Log Entry | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
17 | TICL046 | Internal Claim Type: Permitted Manual Claim Document | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
18 | TICL047 | Internal Claim Type: Permitted Claim Closure Reason | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
19 | TICL048 | Internal Claim Type: Method of Settlement | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
20 | TICL049 | Internal Claim Type: Permitted Damage Category | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
21 | TICL050 | Internal Claim Type: Permitted Damage Descriptor | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
22 | TICL051 | Internal Claim Type: Permitted Damage Severity | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
23 | TICL052 | Internal Claim Type: Permitted Document and Other Categories | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
24 | TICL053 | Internal Claim Type: Permitted Reserve Type | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
25 | TICL056 | Internal Claim Type: Permitted Benefit Type | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
26 | TICL057 | Internal Claim Type: Determination of Payment Reason Group | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
27 | TICL058 | Internal Claim Type: Permitted Manual Coverage Referral | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
28 | TICL061 | Internal Claim Type: Facts Capture - Question Sequence | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
29 | TICL062 | Policy Product - Internal Claim Type - Determination | 3 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
30 | TICL076 | Internal Claim Type: Permitted Object Type | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
31 | TICL083 | Internal Claim Type: Limit and Deductible | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
32 | TICL084 | Internal Claim Type: Permitted Reason for Creating ClmItmGp | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
33 | TICL100 | Internal Claim Type - Permitted Coverage Type | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
34 | TICL132 | Internal Claim Type: Permitted Roles for Interruptions | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
35 | TICL133 | Internal Claim Type: Permitted Interruption Reasons | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
36 | TICL142 | Permitted Claim Item Grouping Category | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
37 | TICL143 | Permitted Types of Claim Item Grouping Category | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
38 | TICL160T | Generation of Benefit Type Tree - Text | 4 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
39 | TICL161 | Version of Benefit Type Tree | 3 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
40 | TICL161T | Version of Benefit Type Tree - Text | 4 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
41 | TICL162 | Benefit Type Tree: Permitted Benefit Type | 3 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
42 | TICL163 | Benefit Type Tree: Limit and Deductible | 3 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
43 | TICL164 | Benefit Type Tree: Permitted Object Type | 3 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
44 | TICL165 | Benefit Type Tree: Definition of Payment Reason Group | 3 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
45 | TICL167 | Benefit Type Tree: Sum Insured and Calculation Rules | 3 | GENERAT | Generation of Benefit Type Tree | nvarchar | 5 | 0 | | |
46 | TICL184 | Internal Claim Type: Permitted Specification of Reason | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
47 | TICL187 | Internal Claim Type: Permitted Recovery/Subro Indicator | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
48 | TICL188 | Internal Claim Type: Permitted Accident Indicator | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
49 | TICL189 | FS-CM Subclaim Type: Permitted Benef./Services/Fees Catalogs | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
50 | TICL191 | FS-CM Permitted Document Types for Claim Type/Subclaim Type | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
51 | TICL320T | Policy Product Generation Text | 4 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
52 | TICL321 | Policy Product Version | 3 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
53 | TICL321T | Policy Product Version Text | 4 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
54 | TICL323 | Policy Product: Permitted Coverage Type | 3 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |
55 | TICL345 | Office Integration Business Object Cat. -> Corresp.Templates | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
56 | TICL371 | Internal Claim Type: Permitted Diagnosis Catalogs | 3 | GENERAT | Generation of Internal Claim Type | nvarchar | 5 | 0 | | |
TOPFinancial Services Localization |
57 | /GSINS/OLR_AG2PP | Accounting Groups to Policy Products | 3 | GENERAT | Policy Product Generation | nvarchar | 5 | 0 | | |