| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T7PIQ_GB_CRS_INS | UCAS: Offered Prog. of Study per institution | 3 | INSTITUTION_ID | UCAS: Institution Code | nvarchar | 4 | 0 | | |
| 2 | T7PIQ_GB_INST | UCAS: Institution Codes | 2 | INSTITUTION_ID | UCAS: Institution Code | nvarchar | 4 | 0 | | |
| 3 | T7PIQ_GB_INSTT | UCAS: Institutions text table | 2 | INSTITUTION_ID | UCAS: Institution Code | nvarchar | 4 | 0 | | |
| 4 | T7PIQ_GB_INST_OR | UCAS: Organization of Universities | 2 | INSTITUTION_ID | UCAS: Institution Code | nvarchar | 4 | 0 | | |
| TOPPatient Management |
| 5 | N1TC_BUFFER | Table for Saving Treatment Contract Checks | 2 | INSTITUTION_ID | Institution | nvarchar | 4 | 0 | | |
| 6 | N1TC_BUFFER_PAP | Table of TC Checks for Patients with Provisional Data | 2 | INSTITUTION_ID | Institution | nvarchar | 4 | 0 | | |
| 7 | N1TC_REQUEST | Temporary Treatment Contracts Applied for | 3 | INSTITUTION_ID | Institution | nvarchar | 4 | 0 | | |
| 8 | TN1TC_GLOB_SET | Treatment Contract - General Settings | 2 | INSTITUTION_ID | Institution | nvarchar | 4 | 0 | | |
| 9 | TN1TC_OU_RESP_OU | Treatment Contract - OU Constellations for OU Jurisdiction | 2 | INSTITUTION_ID | Institution | nvarchar | 4 | 0 | | |
| 10 | TN1TC_TIMES_INST | Treatment Authorization - Deadlines for OU Jurisdiction | 2 | INSTITUTION_ID | Institution | nvarchar | 4 | 0 | | |
| 11 | TN1TC_TIMES_OU | Treatment Contract - Deadlines of OU Constellation | 2 | INSTITUTION_ID | Institution | nvarchar | 4 | 0 | | |
