Improving Access to Psychological Therapies Data Set Intermediate Database
Improving Access to Psychological Therapies (IAPT) Data Set submissions must be made using the latest IAPT Intermediate Database (IDB).
The structure of the IDB must not be altered in any way, and will be validated upon receipt of the submission to the SDCS Cloud. All tables must be present, even if some are not appropriate to the submission (based on the activity that has taken place). All fields listed in each table must also be present and field types must be exactly as specified.
The data items required to populate the IDB should be extracted directly from the appropriate local information systems, such as a clinical system or Patient Administration System.
Read more on our Intermediate Database (IDB) guidance pages.
Releases of this item
IAPTMasterIDB_2.1_v1.2.zip
This release is useable from May 2022.
Included are changes to reflect the capture of Gender, Medical History and amendments to align with the NHS Data Model and Dictionary. See the included production log for details.
This release supercedes the previous release of the IDB and resolves the issue of entered text being padded with spaces up to the maximum field length.
Use this release for all 2.1 submissions going forward.
IAPT 2.1 submissions start from May 2022 for April 2022 reporting period data.
Providers must continue to use the IAPT v2.0 IDB (IAPTMasterIDB_2.0_v7.accdb.zip) for any submissions of IAPT v2.0 data, with the final collection in the IAPT v2.0 format currently expected to be for the March 2022 reporting period.
IAPTMasterIDB_2.1_v1.1.zip preview 1
There is an issue with this release.
This release stores entered text with padded spaces up to the maximum field length. This does not affect the structure or population of the IDB, but could impact downstream processing after submission to NHS Digital.
A new release is now available that contains identical table and field names, field types and sizes – the only difference is that entered text is not stored with padded spaces up to the maximum field length.
This is an internal change to the IDB concerning the physical storage of data after entry. All Provider/Supplier processes and systems that have been developed to populate this release should not be affected and will work with the new release.
IAPTMasterIDB_2.0_v7.accdb.zip
This release is useable from 1 October 2020.
IAPT 2.0 submissions start from 1 October 2020 for September 2020 reporting period data.