Skip to main content

XELSP01_1.4.2

Back to C17051

Field description Field abbreviation Field version Field length Field type
Expected length of study programme XELSP01 1.4.2 1 Char

Valid entries

Code Label
1 <5 weeks
2 =>5 weeks and <24 weeks
3 =>24 weeks and <=1 year
4 >1 year and <=2 years
5 >2 years and <=3 years
6 >3 years and <=4 years
7 >4 years and <=5 years
8 >5 years and <=6 years
9 >6 years and <20 years
A Not known or expected length of study programme is greater or equal to 20 years

Dependent fields

  • XMODE01
  • XQMODE01

Depend upon fields

  • UNITLGTH
  • SPLENGTH

Additional information

This field is derived using Expected length of study programme (Instance.SPLENGTH) and Units of length (Instance.UNITLGTH) by converting the study programme length into weeks using the following method:

Instance.UNITLGTH = 1 (Years)
Weeks = 52*Instance.SPLENGTH

Instance.UNITLGTH = 2 (Months)
Years = INT(Instance.SPLENGTH /12)
Mths = MOD(Instance.SPLENGTH,12)
Weeks = (Years*52) + (Mths*4)

Instance.UNITLGTH = 3 (Weeks)
Weeks = Instance.SPLENGTH

Instance.UNITLGTH = 4 (Days)
Weeks = INT(Instance.SPLENGTH / 5)

Instance.UNITLGTH = 5 (Hours)
Weeks = 1

then grouping is as follows:
1 <5 weeks
2 =>5 weeks and <24 weeks
3 =>24 weeks and <=52 weeks
4 >52 weeks and <=104 weeks
5 >104 weeks and <=156 weeks
6 >156 weeks and <=208 weeks
7 >208 weeks and <=260 weeks
8 >260 weeks and <=312 weeks
9 >312 weeks and <1040 weeks
A Not known or >=1040 weeks (i.e. 20 years)

Where only one or neither of SPLENGTH or UNITLGTH is supplied, provision has been made to derive this to 'Not known'. This is only possible in the Student record for certain reduced returns.

Technical Specification

Instance. UNITLGTH Instance. SPLENGTH WEEKS (internal value) XELSP01
9 or null A
not null null A
otherwise (and Instance. SPLENGTH not null) otherwise (and Instance. UNITLGTH not null) <5 1
=>5 and <24 2
=>24 and <=52 3
>52 and <=104 4
>104 and <=156 5
>156 and <=208 6
>208 and <=260 7
>260 and <=312 8
>312 and <1040 9
>=1040 A

Revision history

Date Version Notes
2014-10-16 1.4.2 Additional information text amended to allow for the use of this field in the Cyy054 AP Student record.
2013-09-30 1.4.1 Technical specification amended to state that where Instance.UNITLGTH is either null or '9', the associated XELSP01 value derives to A, regardless of the value in Instance.SPLENGTH. This aligns the specification with the function.
2013-01-09 1.3.6 Minor amendment to Additional information in order to clarify the circumstances and reduced records for which null values in SPLENGTH and UNITLGTH derive to 'Not known'
2012-02-09 1.3.5 Valid entry: Minor text amendment: 'years' added to Valid entry A label 'Not known or expected length of study programme is greater or equal to 20 years'
2010-04-09 1.3.4 Minor text amendments, with addition of text for reduced records 06 and 07. Technical specification text changes and re-ordering, but no change to function
2009-07-16 1.3.3 Minor text edits to Additional information
2009-03-18 1.3.2 Format amended. Colons removed from valid entries. Field type added. No change to technical specification
2008-10-10 1.3.1 Amended to allow for only one of SPLENGTH or UNITLGTH to be supplied for reduced records 03 and 04
2008-01-26 1.2.1 Amends to for Cyy051
1998-12-17 1.1.2 Error in program code. Code modified
1998-12-01 1.1.3 Error in program code. Code modified
1998-10-26 1.1.1 Created
1994-01-01 1.1.4 Error in program code. Code modified

Contact Liaison by email or on 01242 211144.