Add pension providers and schemes

Overview

Purpose

To add one or more pension provider or scheme to the Pensions Dashboards Programme (PDP) ecosystem through the PDP bulk upload template.

Who completes this step?

• primary business contact
• scheme administrator

Read the full list of roles and responsibilities.

Before you begin

• Ensure you have the regulator number, regulating body and registration code for each pension provider or scheme you want to add.
• Choose the view and PAT refresh endpoints that will be associated with the pension providers and schemes you are adding. All the pension providers and schemes must have the same view and PAT refresh endpoints for this upload. If your View or PAT refresh endpoint URL has not been added to the ecosystem, then you will need to complete the ‘Add additional endpoints’ process (to be published).
• Choose your connection date for each pension provider or scheme. This is the date that your pension provider or scheme will go live. This should be at least 10 working days after you submit the request.
• Prepare evidence of your internal IT service acceptance.
• Format the data exactly as specified in the bulk upload template below.

When registering pension providers or schemes via a CSV upload, you can only use one holdername GUID per pension provider or scheme. If you want to add multiple holdernames in one file upload, you need to use a JSON file. In either scenario, you can add additional holdername GUIDs afterwards. See below for more information on scenarios where you may want to use multiple holdername GUIDs for the same pension provider or scheme.

What you need to do in this step

1. On the connection portal, navigate to the ‘Pension providers and schemes’ tab and click ‘Add pension providers and schemes’.

2. Select the view endpoint URL you want the pension providers and schemes to be associated with.

3. Select the PAT refresh endpoint URL you want the pension providers and schemes to be associated with.

4. Upload your CSV file. Once it has been uploaded, press continue. At this point the data is validated to ensure both that it is correctly formatted and that the regulating body, regulator number and registration code match the information provided by the regulator.

5. Review the results of your upload. You can download the results to see any errors, see below for error examples. You can correct them and replace the file or submit with the pension providers and schemes that have been successfully processed. When you are ready to proceed, select ‘Yes, submit this file’ and click ‘Continue’.

6. You will be taken to a page which confirms that the file has been submitted. Click ‘Continue’.

7. Upload evidence of your internal IT service acceptance. This can be a screenshot or PDF of your internal IT service acceptance (also known as IT change management approval) from your service management tool. This must show that the addition of these schemes does not impact your architecture. You may need to ask your service manager for this. Once you have uploaded your file, click ‘Continue’.

8. Check your answers. You can change your view and PAT refresh endpoints and the file for your internal IT service acceptance. Once you are satisfied with your answers, click ‘Confirm and submit’.

What happens next

We will email you to confirm that we have received your submission.

Your request to add pension providers and schemes will be reviewed by the PDP change and release manager. They may contact your primary business contact (PBC) to discuss changing a connection date. You will be informed of the outcome of your request in 5 working days.

Once approved by PDP, your pension provider or scheme will go live on the requested connection date. Your PBC and scheme admin can track the status of your organisation’s pension provider and scheme records using the table under the ‘Pension provider and Schemes’ header.

If you need to change a connection date, you need to request this via the ‘Scheme data management’ journey in the ‘Pension providers and schemes' tab. Your request will be reviewed by the PDP change and release manager and you will be informed of the outcome within 5 working days

How to format the data in your CSV file

The data in your CSV file must follow the following format.

Structure of each data field

• Regulating body: ‘FCA’ or ‘TPR’. Character limit of 3. No special characters allowed.
• Regulator number: Alphanumeric. No character limit. No special characters allowed.
• Registration code: Alphanumeric.
• Pension provider or scheme name: Alphanumeric. No character limit. Special characters are allowed.
• Holdername: Globally unique identifier (GUID) made up of 36 characters. It uses the characters 0 to 9 and lowercase a to f to create a string of 32 hexadecimal characters grouped as 8-4-4-4-12 and separated by four hyphens.
• Connection year: YYYY. Character limit of 4. No special characters allowed.
• Connection month: MM. Character limit of 2. No special characters allowed.
• Connection day: DD. Character limit of 2. No special characters allowed.

CSV file error messages

If there are errors with your file uploads you will get an error message for each error. These break down into 5 types:

• registration code check error
• holdername error
• holdername duplicate error
• connection date error
• pension provider or scheme name error

Registration code check error

This can appear for the following reasons:

• registration code missing
• registration code incorrect
• regulator number missing
• regulator number incorrect
• regulating body missing
• regulating body incorrect
• the combination of regulating body, regulator number and registration code is incorrect

Holdername error

This can appear for the following reasons:

• the holdername is not correctly formatted as a GUID
• the holdername is missing

Holdername duplicate error

This can appear for the following reason:

• the holdername GUID is not unique within the ecosystem. To resolve, you should change the holdername GUID.

Connection date error

This can appear for the following reasons:

• the connection date is missing
• the connection date is in the past

Pension provider or scheme name error

This can appear for the following reason:

• the pension provider or scheme name is missing

Pension providers and schemes with multiple holdernames GUIDs

You may need to add additional holdername GUIDs to a pension provider or scheme, for example where:

• pension data for a pension provider or scheme is held in 2 locations (that is, at 2 different endpoint URLs)
• the pension provider or scheme is being administered by more than one organisation, and you are connecting both organisations

You can only add one holdername per pension provider or scheme using the bulk upload via CSV method.

You can add multiple holdernames per pension provider or scheme when using a JSON file.

If you have already uploaded pension providers or scheme to the connection portal, you can add additional holdernames to individual records under the ‘Pension providers and schemes’ tab. For more information, see our scheme data management guidance (to be published).

Support