| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_B2E_C | Benefit Type to Wage Type for External Transfers | 3 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
2 | /GSINS/INH_B2W_C | Benefit Type to Wage Type for Payments | 3 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
3 | /GSINS/INH_DUMMY | Dummy Table for External Deductions | 9 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
4 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 8 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
TOPClaims Management |
5 | ICLCCEVPAY | Claim Bundle - Payment Sum | 4 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
6 | ICLDRGITEM | DRG Item | 10 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
7 | ICLITEM | Claim Item | 13 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
8 | ICLPAYI | Claim Payment Item | 13 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
9 | ICLPOLBF | Benefit Types in Policy Snapshot | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
10 | ICLPOLL | Limit and Deductible in Policy Snapshot | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
11 | ICLPOLS | Sums Insured and Calculations in Policy Snapshot | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
12 | ICLSERVCAT | FS-CM: Benefits/Services/Fees Catalogs | 23 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
13 | ICL_CA_BENTPGRP | Assignment of Benefit Types to Benefit Type Groups | 2 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
14 | ICL_CBENPRWAIV | Maintenance: Premium Exemption for Benefit Type | 2 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
15 | ICL_CBENTYPX | Maintenance: Benefit Type Attributes | 3 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
16 | ICL_CPRBENTYP | Maintenance: Certain Benefit Types | 2 | BENTYPE | Benefit Type Premium Arrears | nvarchar | 10 | 0 | | |
17 | ICL_CPRCBENTYP | Maintenance: Benefit Type for Premium Credit | 2 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
18 | ICL_CTAXBENTYP | Maintenance: Assignment of Tax Type to Benefit Type | 2 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
19 | ICL_TAXBENTYP | Maintenance: Benefit Type for Tax | 2 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
20 | ICSCCEVPAY | Claim Bundle - Payment Sum | 4 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
21 | ICSDRGITEM | DRG Item | 10 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
22 | ICSITEM | Claim Item | 13 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
23 | ICSPAYI | Payment Item | 13 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
24 | ICSPOLBF | Benefit Types in Policy Snapshot (Shadow Table) | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
25 | ICSPOLL | Limit and Deductible in Policy Snapshot | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
26 | ICSPOLS | Sums Insured and Calculations in Policy Snapshot | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
27 | TICL055 | Benefit Type | 2 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
28 | TICL055T | Benefit Type Text | 3 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
29 | TICL056 | Internal Claim Type: Permitted Benefit Type | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
30 | TICL057 | Internal Claim Type: Determination of Payment Reason Group | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
31 | TICL076 | Internal Claim Type: Permitted Object Type | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
32 | TICL083 | Internal Claim Type: Limit and Deductible | 6 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
33 | TICL100 | Internal Claim Type - Permitted Coverage Type | 7 | BENTYPE | Benefit Type for Control of Permitted Benefit Types | nvarchar | 10 | 0 | | |
34 | TICL162 | Benefit Type Tree: Permitted Benefit Type | 5 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
35 | TICL163 | Benefit Type Tree: Limit and Deductible | 5 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
36 | TICL164 | Benefit Type Tree: Permitted Object Type | 5 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
37 | TICL165 | Benefit Type Tree: Definition of Payment Reason Group | 5 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
38 | TICL166 | Dependent Benefit Types | 4 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |
39 | TICL167 | Benefit Type Tree: Sum Insured and Calculation Rules | 5 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | |