ILR Derived variables

2023_to_2024_ILR_Funding_Reports_V1_.pdf (publishing.service.gov.uk)

Pages 20 to 28.

Hi Ben, 

Thanks for your quick reply, but I can't see the answer to my question there.  Funding Line Type is not a field in the ILR file, and I would like to know what processing takes place with other fields in order to derive the value in Funding Line Type.  

If you're looking for a technical specification, I'm not personally aware of such a document having been published, but I'm more than happy to be educated on the matter if others know better. I think what I've linked should broadly service your needs though, as it does set out the basic logic for each funding line, if not the exact formula they use to calculate it, which I agree would be lovely. 

For instance, P95 refers to the funding line 19+ Apprenticeship (Employer on App Service), the logic for which would presumably be something along the lines of; 

• Is the start date greater than or equal to 1 May 2017? 
• Does start date minus date of birth mean the lea? 
• Is the funding model 36? 
• Is the contract type set to ACT1? 

If all of those are marked as yes or 1, the funding line type would be set as 19+ Apprenticeship (Employer on App Service). 

Apologies if this is not what you're asking.