Excluded Aims in PICSWeb QAR Calculations

There are many reasons why an aim would be excluded from the Achievement Rate calculations. The table below lists the reasons for exclusion, how they are calculated and which Achievement Rate reports they apply to.

Exclusion Reason

Calculation

App Prog aim

App Comp aims

E&T

Tship Prog aim

Tship Comp aim

Exclusion Reason

Calculation

App Prog aim

App Comp aims

E&T

Tship Prog aim

Tship Comp aim

Aim is on a planned break and is not an Overdue Planned Break.

  • Aim End date is not blank

  • Completion Status = 6: Learner has temporarily withdrawn from the aim due to an agreed break in learning

  • Aim ended in the report year or the previous year, or has a corresponding restarted aim (and therefore isn’t overdue)

  • For Timely Achievement Rates, the Actual End date must be no later than 90 days after the Planned End date

Apprenticeship Standard Programme Aim at EPA

  • Programme Type is 25: Apprenticeship Standard

  • Aim End Date is set, and is on or after 1st August 2019

  • Aim Achievement Date is blank

  • Aim Completion Status is 1: Continuing

  • Aim Outcome is 8: Not Yet Known

Aim has transferred to a different provider as a result of a merger

  • Aim Withdrawal Reason = 47: Learner has transferred to another provider due to merger

  • For Timely Achievement Rates, the Actual End date must be no later than 90 days after the Planned End date

Aim has transferred to another aim at the same provider

  • Aim Completion Status = 3: Withdrawn

  • Aim Withdrawal Reason = 40: Learner has transferred to a new learning aim with the same provider

  • A corresponding aim with the same ULN and UKPRN exists starting within 120 of the aim end date.

  • For Timely Achievement Rates, the Actual End date must be no later than 90 days after the Planned End date

Aim has transferred to a new provider forced by ESFA intervention or to support a specific government strategy

  • Aim Completion Status = 3: Withdrawn

  • Aim Withdrawal Reason = 7 or 41

  • For Timely Achievement Rates, the Actual End date must be no later than 90 days after the Planned End date

Aim has transferred to a new provider forced by ESFA intervention

  • Aim Completion Status = 3: Withdrawn

  • Aim Withdrawal Reason = 7

  • For Timely Achievement Rates, the Actual End date must be no later than 90 days after the Planned End date

Employer Ownership Pilot

Aim has an LDM FAM with code 351

Aim withdrawn before the qualifying start period.

The ESFA QAR only excludes restarted aims where the aim is a transfer from a different provider, and a previously ended aim can be found within the national ILR data for a different UKPRN. However as PICS is unable to access data for other providers, the Episode Start Type field is used to determine if the aim is a transfer from another provider, and is thus excluded.

  • Aim is not an Apprenticeship Trailblazers (Programme Type = 25 and Funding Model = 81)

  • Actual End date is not blank

  • Completion Status = 3: Withdrawn

  • The aim does not have a RES FAM, or the Episode Start Type is Transfer

  • Does not apply to Apprenticeship Trailblazers (Programme Type 25 and Funding Model 81)

  • The number of days in learning (number of days between Aim Start Date and Aim End Date) does not reach the qualifying period. This is based on the expected duration (number of days between Aim Start Date and Aim Planned End Date):

    • For aims where the expected duration is 168 days or more, the qualifying period is 42 days.

    • For aims where the expected duration is between 14 and 167 days, the qualifying period is 14 days.

    • For aims where the expected duration is 13 days or less, there is no qualifying period and aims are not excluded.

Unfunded (FM99) aim

Aim Funding Model = 99: Non Funded

Seasonal Worker Pilot

Aim has an LDM FAM with code 348

Apprenticeship Standard aim starting before LARS effective-from date

  • Aim Programme Type = 25: Apprenticeship Standard

  • Aim Start Date is before the earliest Effective From date in the LARS for the Apprenticeship Standard Code

Trailblazer with no contribution recorded

  • Aim Programme Type = 25: Apprenticeship Standard

  • Aim Funding Model = 81: Other Adult

  • The sum of all exported PMR payment records is zero. This includes any deductions.

Community Learning aim

Aim Funding Model = 10: Community Learning

ESF aim

Aim Funding Model = 70: ESF

Flexible Learning Fund

Aim has an LDM FAM with code 360

Learning Technologies Pilot aim

Aim has an LDM FAM with code 332, 337 or 341

Innovation Code aim

Aim Reference is ZINN0001 - 6, or Z0004474 - 7833

Unemployed learner claiming Universal Credit or JSA or ESA

  • Aim End Date is not blank

  • Completion Status is not 1: Continuing

  • Outcome is not 1: Achieved

  • Employment Outcome is 1 or 2.

  • An Employment Status record exists matching the following criteria:

    • Status Date is before the Aim Start Date

    • Employment Status Code is 11 or 12

  • The Employment Status record valid on the Aim Start Date matches the following criteria:

    • A BSI Employment Status Monitoring record exists with code 1 or 2, or

    • A BSI Employment Status Monitoring record exists with code 4, the Employment Status Code is 11 and a LOU Employment Status Monitoring record exists.

Key Skills aim

Aim Type code in the LARS for this learning aim reference is 1327

Non-regulated ESOL funding aim

  • Aim has an LDM FAM with code 360

  • Aim Reference is Z0004294 - 4341

OLASS aim

Aim has an LDM FAM with code 034

Supported Internship

Aim Reference is Z0002347

Tutorial Support and Complementary Studies aim

Aim Reference is CMISC001 or XESF0001

Unitisation qualification

Aim Type code in the LARS for this learning aim reference is 8008 or 8009

Work Experience or Placement aim

Aim Reference is Z0007834 - 38 or ZWRKX001 - 9

14 or 15 year old directly funded learner

Aim has an LDM FAM with code 320 or 321

Age at 31st August in year of start is not 16 or older

The learner’s age on 31st August on the academic year of the Aim Start Date is 15 or less.

Non-funded aim

Advanced Learning Loan aims are included in QARs

  • Aim Funding Model = 99: Non-funded

  • Aim does not have an ADL FAM with code 1

Programme Aim

Aim Type = 1: Programme Aim

Component Aim (Aim Type 3)

Aim Type = 3: Component aim within a programme

Traineeship learner who cannot continue their learning as they have started work

  • Aim End Date is not blank

  • Programme Type = 24: Traineeship

  • Aim Type = 3: Component aim within a programme

  • Completion Status is not 1: Continuing

  • Outcome is not 1 or 7

  • A Destination and Progression record exists for this Learner Reference Number with the following criteria:

    • Outcome Start Date is before the Aim Planned End Date

    • Outcome Type/Code is EDU2, EDU4, EDU5, EMP1, EMP3, EMP4