Skip to main content

HESA Student Record 2007/08 - Teacher Reference Number

Back to C07051

HESA Student Record 2007/08

All Fields

Teacher Reference Number


return to field list
Short nameTREFNO
Typefield
Description

This field holds the reference number allocated to each student prior to course completion for the training of teachers.

Applicable toEngland Scotland Wales
Coverage

Compulsory for instances at institutions in England, Wales or Scotland where Course.TTCID = 1 or 8 and QualificationsAwarded.OUTCOME = 1 and QualificationsAwarded.QUAL = H11 or I11 and Instance.REDUCEDI = 00 or 04

Base data typexs:string
Field length9
Part of
Minimum occurrences0
Maximum occurrences1
Related fields
Reason required

To link with teaching career information; used by the TDA, and GTCW in Wales.

Notes

This number will stay with the teacher throughout their career within the teaching profession.

For institutions in Scotland, the reference number required is the six digit number allocated to each student prior to course completion of pre-service courses for the training of teachers. The first 2 digits denote the expected year of qualification (the last 2 digits of the year).

For institutions in England and Wales the reference number required is the Teacher Reference Number (formerly known as a DfES number). The number is allocated by the GTCE when details of a trainee are entered onto their system and the trainee's record created. The number allocated is a seven digit number.

Overseas students not allocated a teacher reference number should be coded 999999999.

A relevant qualification in QualificationsAwarded.QUAL would be code H11 'First degree with honours leading to QTS/registration with a GTC', I11 'Ordinary (non-honours) first degree leading to QTS/registration with a GTC', M71 'Post-Graduate Certificate in Education or Professional Graduate Diploma in Education' or H71 'Professional Graduate Certificate in Education'.

A code H11 or I11 in QualificationsAwarded.QUAL would generate an error if Instance.TREFNO is blank; codes M71 or H71 in QualificationsAwarded.QUAL would generate a warning if Instance.TREFNO is blank.

OwnerThe Teaching Councils
Version1.4
Date modified2008-05-30
Change management notesBusiness rules 1 and 3 amended to restrict to England and Wales, and new rules 4 and 5 added for Scotland
Business rules
1(Error)

Instance.TREFNO must exist for institutions in England or Wales where the corresponding (QualificationsAwarded.OUTCOME = 1 and QualificationsAwarded.QUAL = H11 or I11) and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04

2(Error)

Instance.TREFNO must not exist for institutions in Northern Ireland

3(Warning)

Instance.TREFNO must exist for institutions in England or Wales where the corresponding (QualificationsAwarded.OUTCOME = 1 and QualificationsAwarded.QUAL = M71 or H71) and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04

4(Error)

Instance.TREFNO must exist for institutions in Scotland where QualificationsAwarded.QUAL = H11 or I11 and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04

5(Warning)

Instance.TREFNO must exist for institutions in Scotland where QualificationsAwarded.QUAL = M71 or H71 and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04

Schema components
Element: TREFNO

Contact Liaison by email or on +44 (0)1242 388 531.