| Warninginfo |
|---|
Due to changes in the RAA reports, the RAA import in PICSWeb is not currently workingonly 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 Candidates with Applications 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.
...
Applicant field | Used for matching | |||
|---|---|---|---|---|
Candidate_Name | YesCANDIDATE ID | |||
Applicant_Id | Yes | |||
Candidate_Address_Line1 | ||||
Candidate_Address_Line2 | ||||
Candidate_Address_Line3 | ||||
Candidate_Address_Line4 | Candidate_Address_Line5 | Candidate_Town | Candidate_County | |
Candidate_Postcode | ||||
Date_Of_Birth | ||||
Gender | Candidate_Email | |||
Candidate_Tel_No | Candidate_Mobile_NoTelephone |
Organisation Data
The following fields are used to create an organisation from the RAA report:
Organisation field | Used for matching | ||||||||
|---|---|---|---|---|---|---|---|---|---|
Employer_Name | Yes | ||||||||
EmployerVacancy_Address_Line1 | Employer_Address_Line2 | Employer_Address_Line3 | Employer_Address_Line4 | Employer_Address_Line5 | Employer_Town | Employer_County | Employer_Postcode | 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 |
|---|---|
Date_Application_MadeDate |
Example File
| Note |
|---|
The format in cell A1 and row 4 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.
| View file | ||
|---|---|---|
|