| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLACTIVITY | Tasks in Claim | 18 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
2 | ICLALDD | Assign Archive Link Document to Claim Subobject | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
3 | ICLCLAIMA | Claim-Claim Object Assignment | 4 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
4 | ICLDENTAL | Dental Diagnosis and Dental Treatment | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
5 | ICLDIAGNOSIS | Diagnoses Made | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
6 | ICLDOC | Document to be Sent in Claim | 17 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
7 | ICLEACTIVITY | Tasks in Claim Bundle | 17 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
8 | ICLEALDD | Assignment of Archive Link Document to Claim Bundle | 4 | SUBOBJCAT | Category of a Claim Bundle Subobject | nvarchar | 2 | 0 | | |
9 | ICLEXPLANATION | Profile of Boolean Expressions of a BRF Run | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
10 | ICLITEMDD | Damaged Object - Damage Descriptor - Assignment | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
11 | ICLPARTOCC | Participant Occurrence | 4 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
12 | ICLPROFILE | Profile of True Predicates of a BRF Run | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
13 | ICLREF | Coverage Referral in Claim | 13 | SUBOBJCAT | Object Category of Triggering Sub-Óbject | nvarchar | 2 | 0 | | |
14 | ICLTEXT | Short Texts in Claim | 4 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
15 | ICLTOUCH | Claims Objects Selected for Processing | 8 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
16 | ICLVISION | Vision Findings | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
17 | ICSACTIVITY | Activity in the Claim | 18 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
18 | ICSALDD | Assign Archive Link Document to Claim Subobject | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
19 | ICSCLAIMA | Claim - Claim Subobject Assignment | 4 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
20 | ICSDENTAL | Tooth Notation | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
21 | ICSDIAGNOSIS | Diagnoses | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
22 | ICSDOC | Document in Claim | 17 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
23 | ICSEACTIVITY | Task in Claim Bundle Shadow Table | 17 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
24 | ICSEALDD | Assign Archive Link Document to Claim Subobject | 4 | SUBOBJCAT | Category of a Claim Bundle Subobject | nvarchar | 2 | 0 | | |
25 | ICSITEMDD | Damaged Object - Damage Descriptor - Assignment | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
26 | ICSPARTOCC | Claim Participant Occurrence | 4 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
27 | ICSREF | Coverage Referral in Claim | 13 | SUBOBJCAT | Object Category of Triggering Sub-Óbject | nvarchar | 2 | 0 | | |
28 | ICSTEXT | Short Texts in Claim | 4 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
29 | ICSVISION | Eyeglass Prescription | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
30 | TICL013 | Claims Management Subobject Category | 3 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
31 | TICL013T | Claims Management Subobject Category Text | 4 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
32 | TICL031 | Claim Document | 8 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
33 | TICL089 | Permitted Text ID | 2 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
34 | TICL089T | Permitted Text ID - Texts | 3 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
35 | TICL094 | Node Category of Navigation Tree | 10 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
36 | TICL106 | Assignment Data Set - Claim Subobject Category | 5 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
37 | TICL192 | Claim Subobjects Created by FCODE | 3 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |
38 | TICL306 | Participant Role (Display Information) | 6 | SUBOBJCAT | Standard Subobject Category for Partipant Role | nvarchar | 2 | 0 | | |
39 | TICL309 | Permitted Subobj.Types per Role (Man.Creation in Clm) | 3 | SUBOBJCAT | Claim Subobject Category | nvarchar | 2 | 0 | | |