Learner ILR Aims Report in PICSWeb

Owned by Joe Robson (Unlicensed)
Last updated: Oct 11, 2022
5 min read

The Learner ILR Aims report produces a list of Learning Aims that meet the specified criteria.

Report Options

The following customisation options are available:

  • Learners Report Type – This controls which date is used in the learner record to determine whether aims for that learner will be included. Choosing In Learning Between Dates will include aims for any learners whose programme overlaps with the date range. Choosing Starters Between Dates will include aims for any learners whose Start Date falls within the date range. Choosing Leavers Between Dates will include aims for any learners whose Actual End Date falls within the date range. Choosing Created Between Dates will include aims for any learners whose Created Date falls within the date range.

  • Learners From and To – Here you can specify the date range that will determine the learners whose aims are included in the report. You can either choose a Fixed Date and choose the relevant dates from the calendar date selector, or choose one of the relative values such as Today, Start of Week, Start of Month or others. If you choose a relative value, it is possible to add a positive or negative Offset value, which will adjust the date by the specified number of weeks. For example, choosing End of Week with a +1 Weeks Offset value will run the report from the end of the next week.

  • Report Type – This controls which date is used in the learner aim to determine whether it will be included. For example, choosing Aims Starting Between Dates will include any aims whose Start Date falls within the date range.

  • Qualifications From and To – Here you can specify the date range that will determine whether aims are included in the report. You can either choose a Fixed Date and choose the relevant dates from the calendar date selector, or choose one of the relative values such as Today, Start of Week, Start of Month or others. If you choose a relative value, it is possible to add a positive or negative Offset value, which will adjust the date by the specified number of weeks. For example, choosing End of Week with a +1 Weeks Offset value will run the report from the end of the next week.

  • Only Learner Main Qualification Aims – If this is ticked, the report will only include aims linked to the learner’s main Qualification.

  • Qualification Types – Here you can restrict the report to aims linked to specific qualification types.

  • Qualification – Here you can restrict the report to aims linked to a specific Qualification.

  • Aim Types – Here you can restrict the report to certain aim types. If you leave this field blank, only ILR aims will be included in the report.

  • Aim Version – Here you can restrict the report to either First Version Only or Latest Version Only.

  • Aim Completion Status – Here you can restrict the report to aims with a specific completion status.

  • Aim Outcome – Here you can restrict the report to aims with a specific outcome.

  • Aim ILR Export Status – Here you can restrict the report to aims with a specific export status.

  • Aim can be Exported in Current Year – Here you can restrict the report to aims which either can or cannot be exported in the current ILR year.

  • Learner Tags – Here you can restrict the report to aims for learners with specific Tags. Choosing a tag from the drop-down menu will add it to the field. You can add multiple tags to the field and remove any added ones by selecting the X icon. The following tag options are available:

    • Any – This will restrict the report to learners that have at least one of the specified tags.

    • All – This will restrict the report to learners that have every specified tag.

    • None – This will restrict the report to learners that do not have any of the specified tags.

  • Sites – Here you can restrict the report to aims for learners linked to specific Sites. Choosing a site from the drop-down menu will add it to the field. You can add multiple sites to the field and remove any added ones by selecting the X icon.

  • Qualification Plan – Here you can restrict the report to aims for learners linked to a specific Qualification Plan.

  • Contract – Here you can restrict the report to aims for learners linked to a specific Contract.

  • Programme – Here you can restrict the report to aims for learners enrolled on a specific programme.

  • Funding Organisation – Here you can restrict the report to learners associated with a specific funding organisation. If you leave this field blank, only funding organisations that use the ILR will be included in the report.

  • Episode Past Expected End – If this is ticked, aims for learners that have passed their Expected End Date will be included.

  • Aim Past Expected End – If this is ticked, aims that have passed their Expected End Date will be included.

  • Aim not Ended but Delivery Aim is Ended – If this is ticked, aims that have not yet been ended, even though the corresponding Qualification has been ended, will be included.

  • Aim End Different to Delivery Aim End – If this is ticked, aims where the End Date differs from the End Date for the corresponding qualification will be included.

  • Break-in-Learning – Here you can specify which learners will have their aims included in the report according to their Break-in-Learning status.

  • Learner Export Status – Here you can restrict the report to learners with a specific Export Status.

  • Provider End Code – Here you can restrict the report to aims with a specific provider end code. Choosing a code from the drop-down menu will add it to the field. You can add multiple codes to the field and remove any added ones by selecting the X icon. The following code options are available:

    • Any – This will restrict the report to aims that have at least one of the specified codes.

    • All – This will restrict the report to aims that have every specified code.

    • None – This will restrict the report to aims that do not have any of the specified code.

  • Provider Destination – Here you can restrict the report to aims with a specific provider destination code. Choosing a code from the drop-down menu will add it to the field. You can add multiple codes to the field and remove any added ones by selecting the X icon. The following code options are available:

    • Any – This will restrict the report to aims that have at least one of the specified codes.

    • All – This will restrict the report to aims that have every specified code.

    • None – This will restrict the report to aims that do not have any of the specified code.

  • Learner FAM Type – Here you can restrict the report to aims for learners with a specific Learner Funding and Monitoring (FAM) type set.

  • Learner FAM Value – Here you can restrict the report to aims for learners with a specific Learner Funding and Monitoring (FAM) value as entered in this field.

  • Aims have FAM – Here you can restrict the report to aims with a specific Funding and Monitoring (FAM) type set.

  • Learner has any Aims with HE – If this is ticked, learners with Higher Education (HE) aims will be included in the report.

Report Output

The learner ILR aims report consists of a single sheet listing all matching aims. Along with the aims and learner details, any Optional Fields chosen when building the report will be included as additional columns.