XFPE01_4.2.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Full person equivalent | XFPE01 | 4.2.1 | 7 | Char |
Valid entries
Dependent fields
- XCAH01
- XCAH02
- XCAH03
Depend upon fields
- COURSEAIM
- TTCID
- SBJCA
Additional information
The datasets tables Cyy051_SJ (for the Student record) and Cyy054_SJ (for the Student Alternative record) are the HECoS subject by full person equivalent (FPE) tables, that hold merged subject data from the appropriate Course and CourseSubject records apportioned using the HESA 'combination splitter' methodology.
XHECOS takes the base fields from the CourseSubject entity for the applicable record and derives its value based on entries in Course.COURSEAIM and Course.TTCID, and additionally weights allocation to education subjects as defined by the methodology.
An additional ‘dummy’ HECOS code (200001 – apportioned teacher training) has been included to allow for assignment of teacher training to a general code where required as part of the apportionment process.
XFPE01 apportions the subjects to a nominal FPE, according to the number of subjects submitted per Course and the weighting allocated to a Course's subjects.
From 2019/20 the underlying subject coding frame has changed from JACS to HECOS.
Technical Specification
The creation of the _SJ tables depends on de-duplication to ensure that all Courses are unique, and that Instances contain a COURSEID submitted on Course (i.e. that exception checks that test for de-duplication and Course linkage have run, and have not been switched).
Both tables hold the CourseSubject data apportioned using the field CourseSubject.SBJPCNT.
For the purposes of this specification, ‘Teacher Training’ subject codes are defined as:
(100507) adult education teaching
(100510) early years teaching
(100509) higher education teaching
(100511) primary teaching
(101246) professional practice in education
(100512) secondary teaching
(101087) special needs teaching
(101085) specialist teaching
(100513) teaching English as a foreign language
Where percentages result in decimals then truncate to 3dp.
Where subject percentages are scaled up/down then the sum of the calculation should exactly equal 100 for PGCE or 50 for non PGCE, in order to achieve this, round up/down the percentage relating to the lowest HECOS code.
Cyy051_SJ
For each InstanceKEY linked to a course where the CourseSubject entity exists, create a record in the _SJ table with a total FPE of 100.000.
Join Instance to Course to CourseSubject where:
Instance.UKPRN=Course.UKPRN and
Instance.COURSEID=Course.COURSEID and
Course.UKPRN=CourseSubject.UKPRN and
Course.COURSEID=CourseSubject.COURSEID
For each completed CourseSubject entity create a record containing the fields from that entity, plus Instance.InstanceKEY, Instance.COURSEID, XFPE01, XHECOS, XCAH01, XCAH02 and XCAH03 calculated as per the specification, following the 'combination splitter' methodology below.
Cyy054_SJ
For each InstanceKEY on the Instance_End table for the collection, which can linked to a course where the CourseSubject entity exists, create a record in the _SJ table with a total FPE of 100.000.
Join Instance_End to Course to CourseSubject where:
Instance_End.UKPRN=Course.UKPRN and
Instance_End.COURSEID=Course.COURSEID and
Course.UKPRN=CourseSubject.UKPRN and
Course.COURSEID=CourseSubject.COURSEID
For each completed CourseSubject entity create a record containing the fields from that entity, plus Instance_End.InstanceKEY, Instance_End.COURSEID, UKPRN, XFPE01, XHECOS, XCAH01,XCAH02, XCAH03 and XUHN01 calculated as per the specification, following the 'combination splitter' methodology below.
i) The course being followed is a PGCE (level H or M)
If the course being followed is a PGCE (indicated by Course.COURSEAIM = H71 or M71 and Course.TTCID = 1, 2 or Q) then 100% FPE is allocated to teacher training subject code(s) as follows:
- If exactly one of the SBJCA contains a teacher training subject code, then use this code and set FPE to 100%
- If more than one of the SBJCA contain teacher training subject codes and there are no non-teacher training subject codes returned, then use all of the returned codes with corresponding percentages.
- If more than one of the SBJCA contain teacher training subject codes and there are also non-teacher training subject codes returned, then use the returned teacher training codes based on the given proportions but scaled up so that they sum to 100% and exclude the non-teacher training subject codes calculated as follows: - For each teacher training subject (SBJPCNT/sum(SBJPCNT for all teacher training subjects))*100
- Otherwise use the default teacher training subject code 200001 set to 100% FPE
- Where sum of subjects is greater than/less than 100, round down/up respectively the subject with the lowest HECOS code so that the sum exactly equals 100.
ii) The course being followed is teacher training and not PGCE
If the course being followed is teacher training (Course.TTCID = 1, 2 or Q) and it is not a PGCE course (indicated by Course.COURSEAIM not H71 or M71) then 50% FPE is allocated to teacher training subject code(s) and the remaining 50% is split across the non-teacher training subjects according to the proportions returned:
- If there are only teacher training subject codes returned in SBJCA, then use these codes with the returned FPE.
- If there are both teacher training and non-teacher training subject codes returned in SBJCA, assign 50% of the FPE to the teacher training subject codes, apportion across the 50% based on the split returned and apply a similar principle for the non-teacher training subject codes, calculated as follows: - For each teacher training subject (SBJPCNT/sum(SBJPCNT for all teacher training subjects))*50
- If there are no teaching training subjects returned, assign 50% to the default teacher training subject code 200001 and for the remaining subjects, apportion across the 50% based on the split returned, calculated as follows: - For each non teacher training subject (SBJPCNT/sum(SBJPCNT for all teacher training subjects))*50
- For each non teacher training subject (SBJPCNT/sum(SBJPCNT for all non teacher training subjects))*50
- Where sum of subjects for each calculation above is greater than/less than 50, round down/up respectively the subject with the lowest HECOS code so that the sum exactly equals 50.
- A detailed example is shown below for this subject combination
- Where sum of subjects is greater than/less than 50, round down/up respectively the subject with the lowest HECOS code so that the sum exactly equals 50.
Example:
Course is teacher training but not PGCE and has 5 subject codes returned, 3 of which are non teacher training and 2 of which are teacher training. Assign 50% to teacher training and 50% to non teacher training as follows:
Non teacher training subjects
SUBJCA1 = 100900 (25%) 25/(25 + 25 + 25) * 50 = 16.666%
SUBJCA2 = 100425 (25%) 25/(25 + 25 + 25) * 50 = 16.666%
SUBJCA3 = 100182 (25%) 25/(25 + 25 + 25) * 50 = 16.668%
Teacher training subjects
SUBJCA4 = 100509 (13%) – 13/(12 + 13) * 50 = 26%
SUBJCA5 = 100507 (12%) – 12/(12 + 13) * 50 = 24%
iii) If the course being followed is not Initial Teacher Training (ITT)
The course being followed is not ITT then use returned SBJCA codes and corresponding percentages.
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.