RAA Candidates with Applications Import Specification in PICSWeb
Due to changes in the RAA reports, the RAA import in PICSWeb only accepts the report from the version of RAA web site that the Apprenticeship Service released in April 2022. The older RAA web site is being deprecated by the AS.
For this import to work, you will first need to activate the PICSWeb Recruit an Apprentice (RAA) Integration.
Unlike the other import specifications in this section, you do not need to build your own spreadsheet to import into PICSWeb, as this import uses the output file from the RAA report.
The report contains details about the Candidate, Employer, and Vacancy. These are imported into PICS as Applicants, Organisations and Vacancies with a Vacancy Application record linked.
The import attempts to prevent multiple imports of the same file from creating duplicates. The tables below show which fields for each record type are used to look for matching records.
Applicant Data
The following fields are used to create an applicant from the RAA report:
Applicant field | Used for matching |
|---|---|
Candidate_Name | Yes |
Applicant_Id | Yes |
Address_Line1 |
|
Address_Line2 |
|
Address_Line3 |
|
Address_Line4 |
|
Postcode |
|
Date_Of_Birth |
|
| |
Telephone |
|
Organisation Data
The following fields are used to create an organisation from the RAA report:
Organisation field | Used for matching |
|---|---|
Employer | Yes |
Vacancy_Postcode | Yes |
Vacancy Data
The following fields are used to create a vacancy from the RAA report:
Vacancy field | Used for matching |
|---|---|
Vacancy_Reference_Number | Yes |
Vacancy_Title |
|
Vacancy_Closing_Date |
|
Application Data
The following fields are used to create an application from the RAA report:
Application field | Used for matching |
|---|---|
Application_Date |
|
Example File
The format in cell A1 and row 7 must be in the exact same format as the example for PICSWeb to recognise the file.
The file below is an example of a valid RAA import CSV.
