Choosing the fields in a data export
What each group of fields in the picker contains, how personal and repeating fields behave and how dates and rows appear in the file.
What each group of fields in the picker contains, how personal and repeating fields behave and how dates and rows appear in the file.
This is for System Admins creating or editing an export under Settings, Compliance, Data Exports. The picker is in the Export fields section of the export. "Creating a data export and setting up delivery" covers the other settings.
The field picker
Fields are grouped in the picker. The column order in the file follows the order in which you tick them, and each column heading is the field label. Tick at least one field: an export with none produces a file with no columns.
- Candidate & application: the standard fields from your application forms. Next to some you will see a page number (for example "Page 2") or the name of a repeating group, which tells apart fields that share a label.
- Custom questions: questions written for individual jobs. Questions with the same wording on different jobs are combined into one field. Display only content such as headings and notes is never offered.
- Onboarding: fields from your onboarding forms. Display only content is left out here too.
- Job: Job Title, Department, Location, Employment Type, Working Pattern, Remote Policy, Salary (Min), Salary (Max), Salary Currency, Salary Period, Job Status, Industry Sector, Number of Positions, Published Date and Closing Date.
- Offer: Offer Status, Offer Type, Salary, Salary Period, Salary Currency, Bonus, Start Date, Holiday Days, Hours Per Week, Notice Period, Signing Status, Sent Date, Expiry Date and Responded Date. If an application has more than one offer, the most recent one is used.
Identity columns such as first name use the candidate's record when an application has no stored answer of its own, so they are not left blank. Where several fields share a label, such as a "Surname" for the candidate and a "Surname" inside an emergency contact group, use the group name or page shown beside each field to pick the right one.
Fields that are no longer available to you
When you edit an export, a field you chose earlier may no longer be offered to you, for example a custom question that your role can no longer see. The picker then shows a notice such as "2 selected fields are not available right now. They stay part of the export unless you remove them." Select Review to list them. To take one out, select Remove beside it, then Confirm. Select Hide to close the list. Saving the export keeps those fields unless you have removed them.
Personal and sensitive fields
Fields that hold personal data carry a PII badge; hover over it to see whether the data is standard or protected. Equality monitoring questions such as gender, ethnicity and disability can be selected and are badged as protected. Every onboarding field is treated as personal data. If a question appears in more than one place and any copy of it is protected, the question is treated as protected.
The badges matter for redaction. Where a candidate came from an agency and has not yet been revealed to you, every badged field for that candidate, including identity columns such as name, is written as [Redacted] in the file instead of the real answer. Job and offer fields are not affected.
Fields that repeat
Some form sections let a candidate add several entries, such as emergency contacts or next of kin. In the export, these fields expand to one column per entry, headed with the field label and an entry number, for example "Next of Kin (1)" and "Next of Kin (2)". The number of columns matches the largest number of entries found on any application in that export. Applications with fewer entries leave the extra cells blank. You tick the field once in the picker and the numbered columns are created when the export runs.
What is in the file
One row per submitted application, oldest first. Unfinished drafts are not included. Candidates who are currently hidden are left out. A file holds at most 50,000 rows. There are no filters on the export screen. You control the content through the fields you select and, for scheduled runs, the schedule options.
In CSV files the six date fields (Published Date, Closing Date, Start Date, Sent Date, Expiry Date, Responded Date) are written as dd/mm/yyyy. In Excel files they are real date cells in the same format, and salary, bonus, holiday days, hours per week and number of positions are number cells.
Date answers on application, custom and onboarding forms depend on how the file is produced. In a Download now file and in a file sent with Send candidate export, they are also written as dd/mm/yyyy, and month only answers as mm/yyyy. In Excel files a plain day answer is a real date cell. A text answer that merely looks like a date stays as typed. In Run now and scheduled runs, date answers are written as stored, in the form yyyy-mm-dd. Every other value is text.
Excel files keep leading zeros in values such as sort codes and account numbers. CSV files opened in Excel do not, so choose Excel (.xlsx) for that kind of data.