Selecting Create in the ILR Exports page will open a window where you can create a new ILR Export file. In this window, you can specify the following details:
UKPRN – If your setup involves multiple providers, you can specify which provider the export is for by choosing the corresponding UKPRN.
Optional Export Filters
These options will control which learners are included in the export file. If any of these fields are left blank, no restrictions on that entity will be applied.
Sites – Here you can limit the export to only learners linked to specific Sites. Selecting the field will open a drop-down menu where you can search for the relevant site. Selecting a site will add it to the field. You can remove a site by selecting the X icon.
Subcontractors – Here you can limit the export to only learners placed at specific Subcontractors. Selecting the field will open a drop-down menu where you can search for the relevant subcontractor. Selecting an organisation will add it to the field. You can remove an organisation by selecting the X icon.
Contracts – Here you can limit the export to only learners placed at specific Contracts. Selecting the field will open a drop-down menu where you can search for the relevant contract. Selecting an organisation will add it to the field. You can remove a contract by selecting the X icon. Be aware that if the Include in ILR Exports field is set to No in the ILR tab in the Contract Summary no learners linked to that contract will be included, whether it has been named in this field or not.
Tags – Here you can limit the export to only learners with specific Tags. Selecting the field will open a drop-down menu where you can search for the relevant tag. Selecting a tag will add it to the field. You can remove a tag by selecting the X icon.
Provider Monitoring Values
In the next section you can choose up to six additional monitoring values to include for each learner and learning aim in the export file.
These values are divided into two fields for Learner Provider Monitoring A-B, which display an additional field for each learner, and Learning Delivery Provider Monitoring A-D, which display an additional field for each learning aim. The first two drop-down menus in the Provider Monitoring Values section represent the A and B fields for both Learner and Learning Delivery values. Therefore, six additional values are represented here by the four drop-down menus.
The option you choose in the drop-down menu controls what value is displayed in that field in the export file. If you choose As Entered, any values entered in the provider monitoring fields for learners and learning aims will be used to populate the export file. These fields are found in the following locations:
For Learners, in the ILR Learner tab in the ILR Summary.
For Learning Aims, in the ILR Data tab in the Learning Aim Summary.
You can also choose to override any of these fields to display a value from elsewhere in PICS. The following options are available:
Provider ID
PICS Identifier
Site Code
Qualification Plan Code
Main Officer Code
Main Tag
Once you have made the necessary specifications, select Create. Once the message below has been displayed, the export process will start in the background. You can continue to use PICSWeb as normal while this is happening.
Once the export is complete, you will receive an email informing you that the export file has been produced successfully. It will be available to download in the Export List, with a status of Generated.
If you download the same export file more than once, your browser may adjust the file name with a suffix to make it unique. For example, if the original download is named:
ILR-12345678-2021-20210128-163543-01
The second time you download that file it will be renamed:
ILR-12345678-2021-20210128-163543-01[1]
You will need to remove the [1] suffix from the file name manually to make it acceptable for upload to Submit Learner Data or FIS.