| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_CPHRR | Claim Payee and HCM Person Relation | 3 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
2 | /GSINS/INH_DUMMY | Dummy Table for External Deductions | 3 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
3 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 3 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
TOPClaims Management |
4 | ICLACTIVITY | Tasks in Claim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
5 | ICLALDD | Assign Archive Link Document to Claim Subobject | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
6 | ICLDOC | Document to be Sent in Claim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
7 | ICLDOCAL | Attachments to Outbound Documents | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
8 | ICLDRGITEM | DRG Item | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
9 | ICLEXPLANATION | Profile of Boolean Expressions of a BRF Run | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
10 | ICLEXPLANATIONC | Values of Expressions per Claim -Explanation (Cluster Table | 5 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
11 | ICLITEM | Claim Item | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
12 | ICLITEMEV | Claim Item Evaluation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
13 | ICLITEMEVA | Claim Item: Actual Cash Value Valuation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
14 | ICLITEMEVB | Claim Item: Daily Rate Valuation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
15 | ICLNOTE | Claim Note | 9 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
16 | ICLPAY | Claim Payment | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
17 | ICLPAYEE | Additional Payee | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
18 | ICLPAYI | Claim Payment Item | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
19 | ICLPROCURE | Claim Item Groupings | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
20 | ICLPROFILE | Profile of True Predicates of a BRF Run | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
21 | ICLREF | Coverage Referral in Claim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
22 | ICLSALV | Salvage | 8 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
23 | ICLSALVI | Salvage Item | 9 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
24 | ICLSUBCL | Subclaim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
25 | ICLSUBCLCL | Obsolete - Internal Claim Types, Contracts of Int.Claim Type | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
26 | ICLSUBCLFRAUD | Result from Check System | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
27 | ICL_SUBROGITEM | Subrogation/Recovery Item | 9 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
28 | ICL_WCMPD | FS-CM: Item Data Workers Compensation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
29 | ICL_WCMPD_SCH | FS-CM: Item Data Workers Compensation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
30 | ICL_WCMPH | Workers Comp - Header Data | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
31 | ICSACTIVITY | Activity in the Claim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
32 | ICSALDD | Assign Archive Link Document to Claim Subobject | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
33 | ICSDOC | Document in Claim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
34 | ICSDOCAL | Attachments to Outbound Correspondence | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
35 | ICSDRGITEM | DRG Item | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
36 | ICSITEM | Claim Item | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
37 | ICSITEMEV | Claim Item Evaluation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
38 | ICSITEMEVA | Claim Item: Actual Cash Value Valuation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
39 | ICSITEMEVB | Claim Item: Daily Rate Valuation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
40 | ICSNOTE | Note | 9 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
41 | ICSPAY | Payment | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
42 | ICSPAYEE | Additional Payee | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
43 | ICSPAYI | Payment Item | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
44 | ICSPROCURE | Claim Item Groupings | 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | |
45 | ICSREF | Coverage Referral in Claim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
46 | ICSSALV | Salvage | 8 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
47 | ICSSALVI | Salvage Item | 9 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
48 | ICSSUBCL | Subclaim | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
49 | ICSSUBCLCL | Internal Claim Types, Contracts of Internal Claim Type | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
50 | ICSSUBCLFRAUD | Result from Claims Check System | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
51 | ICS_SUBROGITEM | Subrogation/Recovery Item: Shadow Table | 9 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
52 | ICS_WCMPD | FS-CM: Item Data Workers Compensation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
53 | ICS_WCMPD_SCH | FS-CM: Scheduled Workers Compensation | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
54 | ICS_WCMPH | Workers Comp - Header Data | 4 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
TOPFinancial Services Localization |
55 | /GSINS/DRIVEPART | Driver participant | 3 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
56 | /GSINS/DRVPRTCPN | Driver participant | 3 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |
57 | /GSINS/VEHCLDOCU | Vehicle documentation | 3 | SUBCLAIM | Subclaim | nvarchar | 3 | 0 | | |