First Destination Recipient data can be uploaded for historical FDS data that you'd like to import from a previous system, or for students whose FDS recipient data needs to be adjusted/updated.
Below are all of the fields that can be included in this job type, along with the required formatting. Note that your formatting needs to match exactly with what is included below! You can reach out to Support if you need assistance with your file formatting, or are having trouble uploading your file.
Available fields for importing a FDS Recipient file
Download an example FDS Recipient CSV file
The fields listed below should be formatted as shown and saved as a CSV. Column headers are case sensitive and should be in all lowercase. If any of your headers differ from the formatting included below, the Importer will not identify it and it will be skipped. We recommend reviewing the example file linked above to ensure correct header formatting.
Required Fields: The column headers marked as required are necessary in the file. The column values marked as 'can't be blank' must contain values. Column values that aren't required can be left blank - this will not erase any existing data in that field.
Optional Fields: You can leave out any headers or values that are not marked as required - this will not erase any existing data in that field.
| Column header | Column value |
|---|---|
| user_id *Required |
The student's Handshake account ID. This is the string of numbers at the end of their account URL. You can use the Insights report linked above to obtain this value for the list of students you'd like to include in your file. |
| first_destination_survey_id *Required |
ID number of the survey you will be importing recipients onto (which can be found at the end of the URL of the survey's main page). If you haven't created this survey yet, please follow the instructions outlined here. |
| internal_status *Required |
Each recipient's account status. Must be one of the following (case sensitive):normal |
| import_identifier *Required |
This is an identifier (of your creation) and is unique to each recipient. The import_identifier can be anything, but it must be unique. Examples of recommended identifiers are as follows: school2020FDSrecipient100 school2020FDSrecipient101 school2020FDSrecipient102 school2020FDSrecipient103 (Similar to what you would do when importing Appointments or Notes) |
| education_level_name | The student's education level. Must be one of the following (case sensitive):Certificate |
| primary_college_name | This is the college that the student belongs to. Only 1 college can be supported in this field. |
| campus_name | This field is only used for institutions that have multiple campuses as part of their Handshake setup (i.e. 'Main', 'East'). If you have multiple campuses on your Handshake system, you can use these here. |
| primary_major_name | This is the student's primary course. Only 1 course can be supported in this field. Note: The formatting for this course must be capital case, with all caps used only for abbreviated program designations (i.e. BS Physics). |
| graduation_date | This is the date when a student is expected to graduate. Please note that it has to be included in the format yyyy-mm-dd, unless otherwise specified in the job! |
| major_names | This is the name of the course(s) that this student has declared. You can upload more than one course for a student by separating each course with a semicolon (i.e. Biology; Chemistry). Note: The formatting for these courses must be capital case, with all caps used only for abbreviated program designations (i.e. BS Physics; BA Art History). |
| gender | The gender of the student. This is a custom field that can include any text you wish to upload. |
| ethnicity | The ethnicity of the student. This is a custom field that can include any text you wish to upload. For best reporting results we suggest using one of the UK Census designations outlined below:Asian or Asian British |