Release 4.76 - 23rd July 2024

Apprenticeship learner self-enrolment

We have added a new Introduction page to the learner’s self-enrolment. This will be the first page in the process and will explain to learners what is involved in their self-enrolment, what details they will need to have prepared, and have a link to the ESFA’s privacy notice.

We believe this will help to drive learner engagement with the enrolment process.

Generic intro self-enrolment.PNG

 

 

ILR Specification

In-line with version 4 of the 24/25 ILR specification, we have made the following changes:

  • Added a new option to the existing dropdown list in Learner Delivery > Learner Delivery HE Information > Qualification on Entry (QUALENT):
    • "P55 T Levels"
  • Added a new option to the existing dropdown list in Learner Delivery > Learner Delivery HE Information > Major Source of Tuition (MSTUFEE):
    • 10 = Student Loans Company (SLC)
  • Append text "Valid until 31/07/24" to existing value in dropdown list in Learner Delivery > Learner Delivery HE Information > Major Source of Tuition (MSTUFEE):
    • 2 = English or Welsh LEA award

 

Gateway Review - new Employer questions

We have added two new questions into the Gateway Review for an Employer, these will only be available in new Gateway Reviews. This gives Employers the ability to provide confirmation they are happy with the number of OTJ hours delivered, where the Learner hasn't met the original planned hours. 

  • The new question will be a yes / no, with the wording: "Has the Learner met the original planned off-the-job hours?" 
  • If they answer no, the following yes / no question will be asked:
    • "As the Employer, I confirm I'm happy with the number of hours delivered to this Learner. "

Bug Fixes

  • We have a fixed a bug where some employer contacts were encountering an access denied/forbidden page when attempting to view their learner's learning plans.

 

 

Data Warehouse - release on 24 July @ 14:30

This release, we have added two new tables to the Data Warehouse.

Presentation.[Activity Feedback] has the details of learner feedback on activities with the date, rating and comments given.

Presentation.[Application Qualification] has the learner qualifications entered during enrolment. This includes qualifications copied from LRS searches and attached to the application as well as qualifications entered manually by the learner or trainer.

We've also added [Current EPA Status] to Presentation.[Learning Plan]. This will show if a learner is doing a resit or retake, based on the latest entry in the Presentation.[EPA History].

 

New Fields

Table Name Column Name Description Data Type Column Length
Activity Feedback Dim_Activity_SK Bud Surrogate Key to Dim_Activity int  
Activity Feedback DW_CreationDateTime Metadata: Date and time record was created in the data warehouse (reflects BST during summer time) datetime2  
Activity Feedback DW_LastModifiedDateTime Metadata: Date and time record was last modified in the data warehouse (reflects BST during summer time) datetime2  
Activity Feedback Feedback Comment Any comments given in addition to the rating of the activity nvarchar 255
Activity Feedback Feedback Date Date feedback left date  
Activity Feedback Feedback Rating Code Enumeration of the feedback rating given tinyint  
Activity Feedback Feedback Rating Text Textual description of the feedback rating given varchar 11
Activity Feedback TrainingProviderId Bud TrainingProviderId uniqueidentifier
Application Qualification ApplicationId Metadata: Bud Internal ApplicationId Id uniqueidentifier
Application Qualification ApplicationQualificationId Metadata: Bud Internal Application Qualification Id uniqueidentifier
Application Qualification Award Date Date grade awarded date  
Application Qualification Awarding Body Name of the awarding body nvarchar 255
Application Qualification CreationDateTime Metadata: Record creation time datetime2  
Application Qualification Dim_ApplicationQualification_SK Metadata: Application Qualification Surrogate Key int  
Application Qualification DW_CreationDateTime Metadata: Time when the record was created in the Data Warehouse datetime2  
Application Qualification DW_LastModifiedDateTime Metadata: Time when the record was modified in the Data Warehouse datetime2  
Application Qualification Grade Qualification grade nvarchar 255
Application Qualification LastModifiedDateTime Metadata: Last time record was modified datetime2  
Application Qualification Other Qualification Type Type of qualification if Other is selected nvarchar 255
Application Qualification Qualification Source Learner / Trainer / LRS varchar 50
Application Qualification Qualification Type Type of qualification varchar 50
Application Qualification Subject Name of the qualification nvarchar 255
Application Qualification TrainingProviderId Metadata: Bud Internal Training Provider Id uniqueidentifier
Learning Plan Current EPA Status The current EPA status varchar 30

 

QAR Report

A couple of improvements are being made to the QAR Report:

  • SSAs, levels & Standard names will be derived from the Standard Code using our new IfATE integration, filling a few gaps and inconsistencies.
  • File upload and QAR generation times now respect British Summer Time, instead of GMT all year.