Back to C14054

# AP student record 2014/15

## Student Support Number

Typefield
Short nameSSN
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, providers and SLC. The SSN is unique to each funded instance of engagement.

Applicable toEngland
Coverage

Compulsory for all student instances for either designated courses or where designation is held at provider level, and the instance is in receipt of SLC funds. Not required for all student instances submitted for UNISTATS.

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.

Calculation of Checksum

The algorithm for calculating the checksum is as follows:

For positions 1 to 4 of the SSN:

• Convert each character to a number using the following values:
A=0, B=1, C=2, D=3, E=4, F=5, G=6, H=7, J=8, K=9, L=10, M=11, N=12, P=13, R=14, S=15, T=16, U=17, V=18, W=19, X=20, Y=21
• Multiply each number by the weighting factor, which is 14 minus the position (i.e. 13 for position 1, 12 for position 2 etc)

For positions 5 to 12 of the SSN:

• Multiply each value for positions 5 to 12 by the weighting factor, which is 14 minus the position (i.e. 9 for position 5, 8 for position 6 etc)

Calculate the check character:

• Divide the sum of the calculated values for positions 1 to 12 by 23 to get a remainder (i.e. if summed value was 475 then the remainder would be 15)
• Subtract this remainder from 23 and convert this value to a character using the following values:
1=A, 2=B, 3=C, 4=D, 5=E, 6=F, 7=G, 8=H, 9=J, 10=K, 11=L, 12=M, 13=N, 14=P, 15=R, 16=S, 17=T, 18=U, 19=V, 20=W, 21=X, 22=Y, 23=Z
• This is the check character, so if validating a captured SSN this should match position 13 of the SSN.

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.

3. Positions: 1 2 3 4
Weighting factor: 13 12 11 10

(W=19*13=247), (A=0*12=0), (D=3*11=33), (M=11*10=110)

4. For positions 5 to 12 (46891352) multiply the number by the weighting factor.

5. Positions: 5 6 7 8 9 10 11 12
Weighting factor: 9 8 7 6 5 4 3 2

(4*9=36), (6*8=48), (8*7=56), (9*6=54), (1*5=5), (3*4=12), (5*3=15), (2*2=4)

6. Sum the calculated values for positions 1 to 12.
7. (247+0+33+110+36+48+56+54+5+12+15+4=620)

8. Divide this number by 23 to get a remainder.
9. (620/23=26 with a remainder of 22)

10. Subtract the remainder from 23 and convert this value to a character.
11. (23-22=1=A)

This is the check character and this matches position 13 of the SSN.

Examples

For example

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 length13
Minimum occurrences0
Maximum occurrences1
Schema components
Element: SSN
Data type: SSNType
OwnerSLC
Version1.2
Date modified2014-10-30
Change management notesCoverage statement rephrased to include providers who hold blanket designation, rather than course-specific designation.

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