| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCanada |
| 1 | T5K1A | Absence type reason relevant to ROE (Canada) | 6 | ROERS | Reason code for issuing a ROE | nvarchar | 2 | 0 | | |
| 2 | T5K1E | Event reason relevant to ROE (Canada) | 4 | ROERS | Reason code for issuing a ROE | nvarchar | 2 | 0 | | |
| 3 | T5K1M | Master data reason relevant to ROE | 4 | ROERS | Reason code for issuing a ROE | nvarchar | 2 | 0 | | |
| 4 | T5K1R | Reason code for issuing a ROE (Canada) | 2 | ROERS | Reason code for issuing a ROE | nvarchar | 2 | 0 | | |
| 5 | T5K2R | Reason code text for issuing a ROE (CA) | 3 | ROERS | Reason code for issuing a ROE | nvarchar | 2 | 0 | | |
| 6 | T5KSN | ROE Serial Number | 9 | ROERS | Reason code for issuing a ROE | nvarchar | 2 | 0 | | |
