Guidance

ILR data: check that it meets standards and quality requirements

Provider data self assessment toolkit (PDSAT) and reports to help FE providers make accurate and complete ILR data returns.

Documents

Provider data self-assessment toolkit (PDSAT) user guide: version 17

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (eg a screen reader) and need a version of this document in a more accessible format, please email info@sfa.bis.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Provider data self-assessment toolkit (PDSAT) release notes: version 17

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (eg a screen reader) and need a version of this document in a more accessible format, please email info@sfa.bis.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

User guide: reviewing PDSAT reports - version 16

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (eg a screen reader) and need a version of this document in a more accessible format, please email info@sfa.bis.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Provider data self-assessment toolkit (DSAT) user guide: version 16

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (eg a screen reader) and need a version of this document in a more accessible format, please email info@sfa.bis.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Individualised Learner Record (ILR) 2013 to 2014 data completeness assessments

This file may not be suitable for users of assistive technology. Request an accessible format.

If you use assistive technology (eg a screen reader) and need a version of this document in a more accessible format, please email info@sfa.bis.gov.uk. Please tell us what format you need. It will help us if you say what assistive technology you use.

Detail

Colleges, training organisations, local authorities and employers (further education providers) can use a number of reports and tools to test the integrity of Individualised Learner Record (ILR) data and to prepare for audit.

Reviewing PDSAT reports: user guide

The user guide will help users of PDSAT v15 to perform detailed reviews of the suite of PDSAT reports for 2014 to 2015. The guide explains how the Provider Financial Management and Assurance (PFMA) team reviews all of the PDSAT reports so it will be of use to providers in preparing for a PFMA assurance review, as well as part of their routine ILR data checking procedures.

Provider data self assessment toolkit (PDSAT): version 17

PDSAT version 17 is for analysing learner and learning data from the 2016 to 2017 funding year. It interrogates Individualised Learner Record (ILR) data and produces reports on this data, so that providers can identify and investigate potential anomalies in the ILR data.

PDSAT version 17 will only process 2016 to 2017 ILR data for full returns. It has been designed to:

  • give providers a toolkit to analyse ILR data
  • assist auditors in the audit of providers’ ILR data for 2016 to 2017

We do not require providers to use PDSAT, although you may find it useful in your routine data cleansing and helpful when preparing for assurance visits.

PDSAT version 17 has been designed to process data that has been validated through the FIS. It is recommended that all ILR errors and warnings are reviewed and corrected before the ILR file is processed in PDSAT.

This initial version of PDSAT version 17 uses ILR XML data files. Reports run from PDSAT using an ILR XML data file will not include funding.

In addition, any non-validated records will also appear in the reports and funding may be incorrectly indicated for these records.

As in previous years, updates will be made to PDSAT v17 later in the year to accept FIS input, allow annotations and add the sampler functionality.

We are aware that in this initial release, the export process is running slowly for very large reports. This is expected to be resolved in future updates.

PDSAT download

PDSAT v17 is downloaded from the link below.

All future updates to PDSAT v17 will install automatically if the user has an internet connection that allows connection to the SFA website.

Download PDSAT v17

Installation

  • Select the download link above to begin downloading PDSAT v17.
  • Your browser will offer you a choice of whether to “Run” or “Save” the download. Select “Run”.
  • A message box will display, asking if you wish to install PDSAT. Select “Install” to install PDSAT.
  • If you do not have the necessary prerequisite software for PDSAT, you will be asked to select “Install” up to three times. If you do not have administrator rights, you will need an administrator to accept installation of the prerequisites. Please note, PDSAT will not run if the prerequisite software is not installed.
  • Once the installation is complete, the PDSAT opening screen will appear and will begin the initial set-up.
  • A PDSAT shortcut will be created on your desktop and in your start menu, which you can use to start PDSAT in any future sessions.

If you have any problems running PDSAT, or have any queries please contact the PDSAT helpdesk.

Provider data self assessment toolkit (PDSAT): version 16

PDSAT version 16 is for analysing learner and learning data from the 2015 to 2016 funding year. It interrogates Individualised Learner Record (ILR) data and produces reports on this data, so that providers can identify and investigate potential anomalies in the ILR data.

PDSAT version 16 will only process 2015 to 2016 ILR data for full returns. It has been designed to:

  • give providers a toolkit to analyse ILR data
  • assist auditors in the audit of providers’ ILR data for 2015 to 2016

We do not require providers to use PDSAT, although you may find it useful in your routine data cleansing and helpful when preparing for assurance visits.

PDSAT version 16 has been designed to process data that has been validated through the FIS. It is recommended that all ILR errors and warnings are reviewed and corrected before the ILR file is processed in PDSAT.

This initial version of PDSAT version 16 uses ILR XML data files. Reports run from PDSAT using an ILR XML data file will not include funding but will instead provide an indication whether funding could be expected, under column headers “Funding Flag (SFA)” or “Funding Flag (EFA)” where applicable.

Please be aware that this is an indication for funding only and may not always match with funding shown through FIS.

In addition, any non-validated records will also appear in the reports and funding may be incorrectly indicated for these records.

An update to allow PDSAT v16 to accept the FIS input (Access database) was released on Tuesday, 27 October 2015.

PDSAT download

There is a 32 bit version and a 64 bit version of PDSAT:

  • the 32 bit version is compatible with any machine running a 32 bit version of Microsoft Access 2007, 2010 or 2013.
  • the 64 bit version should be used with a 64 bit version of Access 2010 or Access 2013.

Find out which version of Access you are running.

If you have any problems running PDSAT, or have any queries please contact the PDSAT helpdesk.