IMPORTANT ILR UPDATE!
 
We may have started the new funding year 2017 - 2018 but 2016 - 2017 ILR's are required to be submitted until 19th October 2017.

ILR Transition Period
 
I’ve made his post to help you prepare your ILR's during this year end / start transition period.

As you are aware we are transitioning from one funding year to the next and to be fair it isn't a simple process!

There are several very important aspects to factor in at this time of year which won't phase you if you are up to speed with the ILR Specification and Provider Support documentation.

However, if you aren't then I will explain what you need to know.

There is a crossover of ILR's during the transition from 2016-2017 funding year to the new, 2017-2018.

This process is followed each year with maybe only a few slight variations.

---

Main Rules
 
•    The data cut off for each funding year is always 31st July!
 
•    This means that the data you submit in R12, R13 & R14 MUST NOT include completion or achievements dates if these
      fall after 31st July.
 
•    These learners are classed as continuing, even if they complete in the first week of August, their ILR data must be submitted
      for the remainder of the new funding year.

The Return Schedules:

2016 – 2017 Schedule

2017 - 2018 Schedule

---

Basically for two months you have to submit two ILR's to cover the end of 2016 – 2017 and the start of 2017 - 2018.

The main requirements:

1.    Prepare two ILR's for submission.
 
2.    Be aware of the two different ILR submission dates.
 
3.    ILR XML structure changes.
 
4.    NO Completion data after 31st July 2017 in R13 & R14.
 
5.    Continuing learners across funding years.

---

 

September Returns

9th September R01 - first return for 2017 - 2018.

14th September R13 - penultimate return 2016 - 2017.

 

---

What are ILR's R13 & R14 Used For?
 
Essentially you have until 19th October 2017 to make sure all of your 2016 - 2017 ILR data is correct and up to date.

You must return correct learner information including:

•    Withdrawn

•    Completions in year

•    On Learning Break

•    On Programme

•    Including those transferred to another programme or provider.

Failure to do so could cause funding claw backs, funding withdrawal and ultimately you run the risk of having your ESFA contracts cancelled due to the inability to manage your data correctly.

---

 

October Returns

5th October R02 - second return for 2017 - 2018.

19th October R14 - final return of 2016 - 2017.

 

---

Using the ESFA’s Learner Input Tool

This transition period is a tricky prospect, especially if you are using the ESFA’s Learner input tools!

There is no getting around this so here’s the gist of what’s in store for you!

To continue submitting R13 & R14 2016 – 2017 ILR’s you will use the setup you have now;

•    2016 - 2017 ILR Learner Entry tool

•    ILR learner entry 2016 to 2017 user guide

•    FIS with 2016 – 2017 data set.

For submitting 2017 – 2018 ILR’s you will need to have:

•    2017 -2018 ILR Learner Entry Tool

•    ILR Learner Entry Tool 2017 – 2018 user guide

•   Update FIS with 2017 – 2018 data set

Each year the two funding years will almost certainly require a different XML schema so you have to make sure your ILR’s validate against the correct funding year data sets.

Again, you will need to make sure your R12, R13 & R14 MUST NOT include completion or achievement dates if these fall after 31st July.

But YOU MUST include these in your 2017 – 2018 ILR’s.

You will need to use both ILR Learner Entry tools and both data sets in FIS to validate the next 4 ILR submissions!

You will be able to import your 2016 – 2017 ILR into the 2017 – 2018 Learner Entry tool and modify the data there.

Then export in the new funding year format and validate in FIS against the 2017 – 2018 data set!

---

Important FIS Information!

You will need to make sure you update the ESFA'S Funding Information System (FIS) to include the new funding year data set.

1. Import 2016 - 2017 ILR

2. Run FIS validation

3. Check any errors against the 2016 - 2017 Validation Rules Spreadsheet.

You will also need to switch between data sets when validating your ILR's in different funding years

1. Change data set  to 2017 - 2018

2. Import 2017 - 2018 ILR

3. Run FIS validation

4. Check any errors against the 2017 - 2018 Validation Rules Spreadsheet.

Make sure you upload the ILR's to the Hub before the deadlines to avoid any problems.

---

Take The Easy Option and Let Athena MIS Manage it for You!

Athena Manages the Changes!
 
You don't have to think about:

•    the different XML schema
 
•    changing data formats
 
•    data cut off period
 
•    transferring continuing learners

Athena MIS manages all this for you!

---

---

 

Get Our Updates!

* Indicates required

 

 

 

    

 

 

 

Creating ILR's for Validation

If you are choosing to create your ILR's using the SFA's tools then this information is for you!

 I've been doing some research and thought I would share this information as it will come in handy for when you become a lead provider.

If you plan on using an MI system then Step 1 won't be relevant to you but you may find the rest useful.

---

 

Downloads

ILR Learner Entry Tool:
ILR Entry application for 2016 - 2017 or  The Hub to select other funding years.

Rule Violation Spreadsheet:
ILR Validation Rules 2016 - 17 spreadsheet.

The FIS:
FIS software application.

The Hub:
Data returns overview: December 2015 document.

 

---

Step 1 - ILR Learner Entry

To create a correctly structured XML document you will either need to use an ILR compliant MI system or the SFA's ILR Learner Entry tool.

If you have several people inputting data you will need to amalgamate all the individually exported XML files to make one XML file prior to import into The Hub.

NOTE: The ILR Learner Entry tool does not validate your data!

Example:

You will have to be super careful when inputting data items such as post codes, as there are strict rules regarding formatting.

You must have a space between the two the two parts of the post code and as this is a mandatory field it cannot be left blank.

If a postcode is unknown or does not apply then ZZ99 9ZZ must be input.

If the format is incorrect then this will throw validation errors in the FIS and stops the validation process from continuing.

All these type of rules can be found in the various SFA funding rules: 2016 to 2017 and ILR specification, validation rules and appendices 2016 to 2017 documentation.

Start by:

1. Data input into ILR Learner Entry tool.

2. If you have lots of people helping to input this information you will end up with several exported XML files.

3. Export your ILR data and validate each individual file in the FIS.

4. FIS - To start with I would suggest:

    a) Import and Validate an ILR submission
    b) Export Rule Violation Summary Report as PDF.

---

Step 2 - Fix Rule Violation Errors

I would recommend that you download the ILR Validation Rules 2016 - 17 spreadsheet so you can find any error codes listed in the Rule Violation Report.

Fix any errors in the ILR Learner Entry tool before re exporting the ILR and running it through the FIS again.

This could be a very repetitive process so it's best to validate each file individually before you amalgamate them.

---

Step 3 - Amalgamating ILR's in the FIS

When you installed the Funding Information System (FIS) on your PC an ILR folder was created too.

This is the default location for all the exports you request from the FIS.

I would suggest the following:

1. Open FIS - select your DataSet and Reference options.

2. Click the Amalgamate check box and nothing else.

3. Click Execute - this allows you to add the individual XML files one at a time.

4. Once ALL of the XML files are added click the Import button.

5. The FIS will amalgamate all the individual files into one XML file.

9. The completed XML file will be automatically exported to the ILR folder.

NEXT:

1. Uncheck Amalgamate and check all the other items you need

Again, to start with I would suggest:

    a) Import and Validate an ILR submission
    b) Rule Violation Summary Report as PDF

2. Click Execute

3. Browse to the ILR folder and select the newly amalgamated ILR XML file

4. Click Import

5. Your data will be validated and a report of any errors will be generated as a PDF. This will be exported to the ILR folder.

---

Step 4 - Import ILR into The HUB

The Data returns overview: December 2015 document gives you step by step instructions on how to complete the process.

"Each provider should have a single super user... Super users manage access for their users and give them responsibilities within their organisation in the Hub. This allows a super user to restrict what the organisation’s users can view."

For future reference here some links to get you started:

Information Management Services: Self Registration

The Hub: guide to user roles

The Hub: guide to the contracts and finances area

---

 Athena MIS & RAIL - ILR Creation for Lead providers and Subcontractors

We have worked really hard to make ILR creation as easy as possible in Athena MIS & Rail and have developed two types of ILR files:

•    individulal ILR for subcontractors to return to lead providers
•    complete ILR, in XML format, for lead providers to submit to The Hub.

With just a click of a button the ILR spreadsheet or XML document is exported straight from Athena MIS & RAIL.

Watch the videos on how to create an ILR spreadsheet for your lead provider, or, a complete ILR in XML format for submission to The Hub.

You can also subscribe to our You Tube channel to receive notification of new videos.

---

 

Get Our Updates!

* Indicates required

 

 

 

    

---