XELSP01_1.4.2
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Expected length of study programme | XELSP01 | 1.4.2 | 1 | Char |
Valid entries
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
Contact Liaison by email or on +44 (0)1242 388 531.