| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | PA0616 | HR Master Record: Infotype 0616 | 43 | RESACT | HESA: Active in the 1996/2001 Research Assessment Exercise | nvarchar | 1 | 0 | | |
| 2 | PAPBSGB_HESA_P | HESA: Archive table for NISR Person table | 27 | RESACT | HESA: Active in 2001 Research Assessment Exercise | nvarchar | 1 | 0 | | |
| 3 | T5GPBSH_RAE | HESA: Acitve in 1996 Research Assessment Exercise | 2 | RESACT | HESA: Active in the 1996 Research Assessment Exercise | nvarchar | 1 | 0 | | |
| 4 | T5GPBSH_RAE2 | HESA: Active in 2001 and 2008 Research Assessment Exercise | 2 | RESACT | HESA: Active in 2001 Research Assessment Exercise | nvarchar | 1 | 0 | | |
| 5 | T5GPBSH_RAET | HESA: Acitve in 1996 Research Assessment Exercise | 3 | RESACT | HESA: Active in the 1996 Research Assessment Exercise | nvarchar | 1 | 0 | | |
