MA CSV Spec

## CSV Specification

### Columns

* Applicant Reference => applicant_reference (Required)
* First Name => first_name (Required)
* Last Name => last_name (Required)
* Email => email (Required)
* Stage => stage (Required)
  * Applied (Survey 1)
  * Screen
  * Selection
  * Rejected (Survey 2)
  * Offered
  * Hired (Survey 2)
  * Opted Out (Survey 2)
* Location => location
* Department => department
* Job Title => job_title
* Job Family => job_family
  * Accountancy & Finance
  * Administrative/Clerical
  * Construction & Skilled Trades
  * Consultancy
  * Creative/Design
  * Customer Service/Client Care
  * Editorial/Writing/Publishing
  * Engineering
  * Food Services/Hospitality
  * Graduate
  * HR & Recruitment
* Source => source
  * Recruitment Website
  * Newspaper
  * Professional Magazine
  * Word of Mouth
  * Job Centre
  * Job Fair
  * Other
* Date Applied => date_applied (YYYY-MM-DD format, defaults to the current day if absent)
* Client's internal stage => client_stage
* Hiring manager => hiring_manager
* Recruiter => recruiter
* Unmapped location => client_location
* Unmapped job family => client_job_family
* Unmapped source => client_source
* University => university

An Applicant Reference must be provided in the CSV, even if it is the email address.

The value in the Stage, Job Family and Source columns must exactly match one of the options in the lists provided.

Location, Department and Job Title save whatever value is provided in the CSV, so it is essential that these values are from a concise set else the drop-down filters will become huge and unhelpful.

We record the date of each state change.