| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | ICLPARTSP_EXT | External Services Extension | 15 | XMANUAL | Manual Selection | nvarchar | 1 | 0 | | |
| 2 | ICSPARTSP_EXT | External Services Extension | 15 | XMANUAL | Manual Selection | nvarchar | 1 | 0 | | |
| TOPClaims Management |
| 3 | ICLACTIVITY | Tasks in Claim | 12 | XMANUAL | Activity Set Manually | nvarchar | 1 | 0 | | |
| 4 | ICLDOC | Document to be Sent in Claim | 11 | XMANUAL | Flag: Document entered manually | nvarchar | 1 | 0 | | |
| 5 | ICLEACTIVITY | Tasks in Claim Bundle | 11 | XMANUAL | Activity Set Manually | nvarchar | 1 | 0 | | |
| 6 | ICLPARTOCC | Participant Occurrence | 11 | XMANUAL | Flag: Manual Entry? (NOT USED) | nvarchar | 1 | 0 | | |
| 7 | ICLPARTSP | Participant: Vendor | 16 | XMANUAL | Manual Selection | nvarchar | 1 | 0 | | |
| 8 | ICLREF | Coverage Referral in Claim | 12 | XMANUAL | Flag: Coverage referral set manually? | nvarchar | 1 | 0 | | |
| 9 | ICSACTIVITY | Activity in the Claim | 12 | XMANUAL | Activity Set Manually | nvarchar | 1 | 0 | | |
| 10 | ICSDOC | Document in Claim | 11 | XMANUAL | Flag: Document entered manually | nvarchar | 1 | 0 | | |
| 11 | ICSEACTIVITY | Task in Claim Bundle Shadow Table | 11 | XMANUAL | Activity Set Manually | nvarchar | 1 | 0 | | |
| 12 | ICSPARTOCC | Claim Participant Occurrence | 11 | XMANUAL | Flag: Manual Entry? (NOT USED) | nvarchar | 1 | 0 | | |
| 13 | ICSPARTSP | Claim Participant: Vendor | 16 | XMANUAL | Manual Selection | nvarchar | 1 | 0 | | |
| 14 | ICSREF | Coverage Referral in Claim | 12 | XMANUAL | Flag: Coverage referral set manually? | nvarchar | 1 | 0 | | |
