| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ICL_CPROCDOC | Internal Claim Type: Manual Claim Document per CIG Category | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
TOPClaims Management |
2 | ICLPROCURE | Claim Item Groupings | 12 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
3 | ICL_CBENTPFIND | Benefit Type Determination | 4 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
4 | ICL_CITEM_RFCHCK | Item: Data Set Relevance for Extensive Required Field Check | 2 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
5 | ICL_CPROC_RFCHCK | Claim Item Grouping: Data Set Relevant for Ext.RqrdFld Check | 2 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
6 | ICSPROCURE | Claim Item Groupings | 12 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
7 | TICL052 | Internal Claim Type: Permitted Document and Other Categories | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
8 | TICL084 | Internal Claim Type: Permitted Reason for Creating ClmItmGp | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
9 | TICL138 | Claim Item Grouping Category | 2 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
10 | TICL138T | Claim Item Grouping Category | 3 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
11 | TICL142 | Permitted Claim Item Grouping Category | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
12 | TICL143 | Permitted Types of Claim Item Grouping Category | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
13 | TICL184 | Internal Claim Type: Permitted Specification of Reason | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
14 | TICL187 | Internal Claim Type: Permitted Recovery/Subro Indicator | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
15 | TICL188 | Internal Claim Type: Permitted Accident Indicator | 6 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |
16 | TICL197 | Navigation Tree Note Dependent on PDOCCAT | 2 | PDOCCAT | Claim Item Grouping Category | nvarchar | 2 | 0 | | |