| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClaims Management |
| 1 | ICLCCEVENT | Claim Bundle | 38 | CCSBRTYPE | Subrogation Claim Type in Subrogation | nvarchar | 2 | 0 | | |
| 2 | ICLEBULKSBR | Coll.Subro/Recovery Settlement | 9 | CCSBRTYPE | Subrogation Claim Type Settlement Collective Subro/Recovery | nvarchar | 2 | 0 | | |
| 3 | ICSCCEVENT | Shadow Table Claim Bundle | 38 | CCSBRTYPE | Subrogation Claim Type in Subrogation | nvarchar | 2 | 0 | | |
| 4 | ICSEBULKSBR | Shadow Table Collective Subrogation/Recovery Settlement | 9 | CCSBRTYPE | Subrogation Claim Type Settlement Collective Subro/Recovery | nvarchar | 2 | 0 | | |
| 5 | TICL174 | Subrogation Claim Type in Subrogation (To Be Deleted) | 3 | CCSBRTYPE | Subrogation Claim Type in Subrogation | nvarchar | 2 | 0 | | |
| 6 | TICL174T | Subrogation Claim Type in Subrogation (Text) | 4 | CCSBRTYPE | Subrogation Claim Type in Subrogation | nvarchar | 2 | 0 | | |
| 7 | TICL177 | Subrogation Claim Type in Subrogation | 4 | CCSBRTYPE | Subrogation Claim Type in Subrogation | nvarchar | 2 | 0 | | |
| 8 | TICL177T | Subrogation Claim Type in Subrogation (Text) | 5 | CCSBRTYPE | Subrogation Claim Type in Subrogation | nvarchar | 2 | 0 | | |
