| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_CPHRR | Claim Payee and HCM Person Relation | 11 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
2 | ICL_CPROCDOC | Internal Claim Type: Manual Claim Document per CIG Category | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
3 | TICL600 | Mapping: Condition Fields for Rule Variant | 3 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
TOPClaims Management |
4 | ICLCLAIMB | Exception Table Payment Amount Authorizations | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
5 | ICLINDRESI | Claim-Independent Reserve | 20 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
6 | ICLSUBCL | Subclaim | 19 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
7 | ICL_CBENTPFIND | Benefit Type Determination | 3 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
8 | ICL_CNOTE_CTYPE | Internal Claim Type: Permitted Communication Type | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
9 | ICL_CNOTE_TEMPL1 | Internal Claim Type: Permitted Text Templates | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
10 | ICL_CNOTE_TYPE | Internal Claim Type: Permitted Topic of Claim Note | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
11 | ICL_CRBPCLTYPE | RBP: Assignment of Profile to Claim Type and Subclaim Type | 3 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
12 | ICL_IBNR_RESULT | IBNR Reserves | 33 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
13 | ICSCLAIMB | Exception Table Payment Amount Authorizations | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
14 | ICSSUBCL | Subclaim | 19 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
15 | TICL004 | Subclaim Type | 2 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
16 | TICL004T | Subclaim Type Text | 3 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
17 | TICL005 | Internal Claim Type: Permitted Subclaim Type | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
18 | TICL027 | Internal Claim Type: Permitted Subclaim Complexity | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
19 | TICL043 | Internal Claim Type: Permitted Claim Item Rejection Reason | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
20 | TICL045 | Internal Claim Type: Permitted Manual Task/Log Entry | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
21 | TICL046 | Internal Claim Type: Permitted Manual Claim Document | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
22 | TICL047 | Internal Claim Type: Permitted Claim Closure Reason | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
23 | TICL048 | Internal Claim Type: Method of Settlement | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
24 | TICL049 | Internal Claim Type: Permitted Damage Category | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
25 | TICL050 | Internal Claim Type: Permitted Damage Descriptor | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
26 | TICL052 | Internal Claim Type: Permitted Document and Other Categories | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
27 | TICL053 | Internal Claim Type: Permitted Reserve Type | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
28 | TICL054 | Claim Bundle Type - Claim Type - Assignment | 4 | SUBCLTYPE | Subclaim Type of Subclaims to be Included | nvarchar | 4 | 0 | | |
29 | TICL056 | Internal Claim Type: Permitted Benefit Type | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
30 | TICL057 | Internal Claim Type: Determination of Payment Reason Group | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
31 | TICL058 | Internal Claim Type: Permitted Manual Coverage Referral | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
32 | TICL064 | Subclaim-Screen Sequence Determination | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
33 | TICL076 | Internal Claim Type: Permitted Object Type | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
34 | TICL083 | Internal Claim Type: Limit and Deductible | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
35 | TICL084 | Internal Claim Type: Permitted Reason for Creating ClmItmGp | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
36 | TICL100 | Internal Claim Type - Permitted Coverage Type | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
37 | TICL110 | Amount Authorizations for Payments/Reserves | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
38 | TICL110_RESTYP | Amount Authorizations Reserves (per Reserve Type) | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
39 | TICL142 | Permitted Claim Item Grouping Category | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
40 | TICL143 | Permitted Types of Claim Item Grouping Category | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
41 | TICL184 | Internal Claim Type: Permitted Specification of Reason | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
42 | TICL187 | Internal Claim Type: Permitted Recovery/Subro Indicator | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
43 | TICL188 | Internal Claim Type: Permitted Accident Indicator | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
44 | TICL189 | FS-CM Subclaim Type: Permitted Benef./Services/Fees Catalogs | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
45 | TICL191 | FS-CM Permitted Document Types for Claim Type/Subclaim Type | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
46 | TICL371 | Internal Claim Type: Permitted Diagnosis Catalogs | 5 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
47 | /GSINS/DMG_TYPES | Damage types | 2 | SUBCLTYPE | Subclaim Type | nvarchar | 4 | 0 | | |