HESA Student Record 2012/13 - Student Support Number
HESA Student Record 2012/13Fields required from institutions in ScotlandStudent Support Number | return to field list |
Type | field | ||||||||||||||||||||||||||||
Short name | SSN | ||||||||||||||||||||||||||||
Description |
This field holds the Student Support Number assigned by Student Support Award Authorities (Northern Ireland Library Boards, Welsh Local Authorities, Student Awards Agency for Scotland (SAAS) and Student Loans Company (SLC)). It is the student identifier that is used in student finance communications between the Student Support Award Authorities, institutions and SLC. The SSN is unique to each funded instance of engagement. | ||||||||||||||||||||||||||||
Applicable to | England Northern Ireland Scotland Wales | ||||||||||||||||||||||||||||
Coverage | All institutions, all students in receipt of statutory student finance except where Course.COURSEAIM ends in 90 or 99. | ||||||||||||||||||||||||||||
Notes |
The SSN is 13 characters long. The first four characters are alpha. The next 8 characters are numeric. The last character, which is a check character, is alpha. Where a student may be in possession of multiple SSNs from different loan providers, the SSN returned in this field should be the one relating to the loan made for the payment of tuition fees. It is not expected that the same SSN will appear in multiple instances unless it is held by a student who has changed course. Calculation of Checksum The algorithm for calculating the checksum is as follows: For positions 1 to 4 of the SSN:
For positions 5 to 12 of the SSN:
Calculate the check character:
Note: characters I, O, Q are not valid characters in the SSN. Z is only valid in position 13. Worked example When the Student Support Number = WADM46891352A 1. Convert the characters to numbers using the values, so W=19, A=0, D=3, M=11. 2. Multiply each number by the weighting factor.
(W=19*13=247), (A=0*12=0), (D=3*11=33), (M=11*10=110) 3. For positions 5 to 12 (46891352) multiply the number by the weighting factor.
(W=19*13=247), (A=0*12=0), (D=3*11=33), (M=11*10=110) 4. Sum the calculated values for positions 1 to 12 (247+0+33+110+36+48+56+54+5+12+15+4=620) 5. Divide this number by 23 to get a remainder. (620/23=26 with a remainder of 22) 6. Subtract the remainder from 23 and convert this value to a character. (23-22=1=A) This is the check character and this matches position 13 of the SSN. | ||||||||||||||||||||||||||||
Examples |
For example Student Support Number = WADM46891352A | ||||||||||||||||||||||||||||
Quality rules |
Quality rules relating to this field are displayed here.
| ||||||||||||||||||||||||||||
Reason required |
To enable robust linking between HESA data and the student finance data held by SLC. | ||||||||||||||||||||||||||||
Part of | |||||||||||||||||||||||||||||
Field length | 13 | ||||||||||||||||||||||||||||
Minimum occurrences | 0 | ||||||||||||||||||||||||||||
Maximum occurrences | 1 | ||||||||||||||||||||||||||||
Schema components |
Element: SSN
Data type: SSNType | ||||||||||||||||||||||||||||
Owner | SLC | ||||||||||||||||||||||||||||
Version | 1.2 | ||||||||||||||||||||||||||||
Date modified | 2013-04-30 | ||||||||||||||||||||||||||||
Change management notes | Guidance amended in Notes to more explicitly state the structure of the SSN. Business rule 1 added to stop SSN being returned for courses not eligible for student support. Business rule 2 added for institutions in England, Northern Ireland and Wales to stop SSN being returned for students who are not eligible to pay home fees. Business rule 3 added to ensure that the SSN is in a valid format. Business rule 4 added to ensure SSN returned for the SLC attendance confirmation (08) reduced return. |
Contact Liaison by email or on +44 (0)1242 388 531.