| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClaims Management |
| 1 | ICLCCEVENT | Claim Bundle | 39 | CHREASONSBR | Change Reason for Status of Collective Subrogation/Recovery | nvarchar | 2 | 0 | | |
| 2 | ICLEBULKSBR | Coll.Subro/Recovery Settlement | 15 | CHREASONSBR | Transferred Change Reason for Settlement in Coll.Subro/Rcvry | nvarchar | 2 | 0 | | |
| 3 | ICSCCEVENT | Shadow Table Claim Bundle | 39 | CHREASONSBR | Change Reason for Status of Collective Subrogation/Recovery | nvarchar | 2 | 0 | | |
| 4 | ICSEBULKSBR | Shadow Table Collective Subrogation/Recovery Settlement | 15 | CHREASONSBR | Transferred Change Reason for Settlement in Coll.Subro/Rcvry | nvarchar | 2 | 0 | | |
| 5 | TICL175 | Change Reason for Status of (Collective) Subrogation | 2 | CHREASONSBR | Change Reason for Status of Collective Subrogation/Recovery | nvarchar | 2 | 0 | | |
| 6 | TICL175T | Reason for Changing Status of (Collective) Subrogation: Text | 3 | CHREASONSBR | Change Reason for Status of Collective Subrogation/Recovery | nvarchar | 2 | 0 | | |
