Trying to work out the total apprenticeship cohort for 17/18 all learners that will be included is there a particular way to do this MIS and interim QAR differ so I want a definite list I can check through to confirm the final number.
I have tried looking at occupancy lists and planned and actual end dates.
You do this for Apprenticeships as per Appendix B of the ILR Specification (Migration rules)
Simply select all learner records, programme where the apprenticeship programme is continuing (Aim type = 1, Learning planned end date >= 1 August 2016 and Learning actual end date is null).
And All learner records, where the apprenticeship programme aim is recorded as on a break (Completion status = 6) or the outcome is unknown (Outcome = 8) and Learning planned end date >= 1 August 2016.
You should be able to do simply this from your MI system.
You could leave out the Learning planned end date, but you should identify if any earler than 1 Aug 2016 are in learning.
The QAR uses data from the last 5 years
We base the overall QAR on the hybrid end year. The hybrid end year is the latter of:
the actual end year of an apprenticeship
the planned end year of an apprenticeship
the reporting year
The reporting year is included to capture those overdue continuing learning aims, overdue planned breaks or late completions recorded in the following academic year (up to R04).
You would have to exclude those who are not funded etc.
I do not know if you can replicate this simply from your MI system