There is a distinction between a learner’s age at the start of their programme(PersonalInformation_AgeAtStart, available in the Users table in OData) and the age displayed on the ILR page. These are calculated differently.
ILR page - Age on 31 Aug of the year programme started
- This age is based on the learner’s age as of 31st August of the funding year in which their Learning Start Date falls.
- The Learning Start Date comes from the ILR aims (specifically, from the most recent programme aim, or, if not available, the most recent non-programme aim).
- This calculation is not directly available in OData and must be calculated manually (please see details below)
OData - PersonalInformation_AgeAtStart [Users table]
- This is a simplified calculation of the learner’s age based on the current programme's start date (from the Programme Details page) and the Date of Birth.
- It does not factor in the 31st August cut-off used in ILR calculations.
These age values can be calculated using power query in Excel or Power BI:
- ILR Age can be derived using the fields UserPersonalDetails_Dob and UserILRSummary_ProgrammeStartDate from the OData Users table.
- Age at Start is already available in the Users table as the field PersonalInformation_AgeAtStart, which is calculated using UserPersonalDetails_Dob and UserProgram_StartDate.