What data do I need to import historical FDS responses?
- Student email
- The student must exist in Handshake in order to add a first destination response
- Education level name (one of the following - case sensitive):
- High School
- Associates
- Certificate
- Advanced Certificate
- Bachelors
- Masters
- Doctorate
- Postdoctoral Studies
- Outcome (one of the following - case sensitive):
- Continuing Education
- Military
- Not Seeking
- Still Looking
- Volunteering
- Working
For each response type, you'll need the following information:
- If Working - Employer name, employment category name, and employment type name
- If Continuing Education - School Name
- If Military - Military Branch Name
- If Not Seeking - Not Seeking Option Name (one of the following - case sensitive):
- Other
- Taking a gap year
- Taking time off
- Traveling
- If Still Looking - Seeking Option Name (one of the following - case sensitive):
- Continuing Education
- Employment
Additional Considerations
- When importing responses, please note that importing a Knowledge Response will prevent additional reminder emails from being sent to the student. If you want those emails to be sent, then we advise to wait till after the final reminder email is sent to upload responses.
- Grad Group cannot be included in the import, so we recommend adding students to the correct Grad Group first, then uploading responses afterward.
- At this time, no additional response data can be uploaded outside of the fields listed in this article. If you need to enter in knowledge responses for custom questions, this must be done manually in Handshake.
All available fields that can be uploaded:
|
Field name |
Description |
|
student_email |
Required - this is the current email connected to the student in Handshake *Can’t be blank |
|
first_destination_response_type_name |
Required - one of the following options must be included:
*Can't be blank |
|
email_address |
Required - Personal email address for the student (if you don’t know this you can import their university email address) *Can't be blank |
| import_identifier | Required
This is an identifier (of your creation) and is unique to each student's responses. The import_identifier can be anything, but it has to be unique. Examples of recommended identifiers are as follows: schoolhistoricalFDS100 schoolhistoricalFDS101 schoolhistoricalFDS102 schoolhistoricalFDS103 (Similar to what you would do when importing Appointments or Notes) *Can't be blank *This field has a 250 character limit |
|
education_level_name |
Required - one of the following options must be included:
*Can't be blank |
|
first_destination_survey_id |
Required - ID number of the survey you will be importing data into (which can be found at the end of the URL of the survey's main page). If you haven't created this yet, please follow the instructions outlined here. *Can't be blank |
|
employment_category_name |
Required if 'Working' or 'Volunteering' options are selected under first_destination_response_type_name Enter one of the following options:
|
| employer_name |
Required if 'Working' or 'Volunteering' options are selected under first_destination_response_type_name *This field has a 250 character limit |
|
continuing_education_school_name |
Required if 'Continuing Education' option is selected under first_destination_response_type_name *This field has a 250 character limit |
|
military_branch_name |
Required if 'Military' option is selected under first_destination_response_type_name, with one of the following options:
|
|
not_seeking_option_name |
Required if 'Not Seeking' option is selected under first_destination_response_type_name, with one of the following options:
|
| seeking_option_name |
Required if 'Still Looking' option is selected under first_destination_response_type_name, with one of the following options:
|
| pay_schedule_name |
Required if there is a value under 'Salary' Options:
|
|
primary_major_name |
Requirements: -Must be an existing major under your school settings (under the Major listings tab) |
| graduation_date |
Requirements: -Dates must be in the following formatting: yyyy-mm-dd |
| employment_type_name |
Required if 'Working' option is selected under first_destination_response_type_name, with one of the following options:
|
|
location_name |
The student's location (all string values are accepted). *This field has a 250 character limit |
|
status |
Required - the status of the student's FDS response. (Must be one of the following - case sensitive):
*Can't be blank |
| bonus_amount |
Student's sign-on bonus, if applicable. Requirements: -Must be a numerical value, without any decimals or special characters. |
|
salary |
Student's salary. Requirements: -Must be a numerical value, without any decimals or special characters. |
|
found_through_handshake |
Whether or not the student found this job through Handshake. Requirements: TRUE/FALSE |
|
job_position_name |
The student's job position/title. *This field has a 250 character limit |
|
job_function_name |
The function(s) of the student's job. Must be one of the following options:
|
|
start_date |
Start date of the student's job. Requirements: -Dates must be in the following formatting: yyyy-mm-dd -Must be after offer_date and accept_date |
|
offer_date |
Date that the student was offered their job. Requirements: -Dates must be in the following formatting: yyyy-mm-dd -Must be before accept_date and start_date |
|
accept_date |
Date the student accepted their job offer. Requirements: -Dates must be in the following formatting: yyyy-mm-dd -Must be after offer_date and before start_date |
|
fellowship_name |
If the student received a fellowship, the fellowship's name. Required if 'TRUE' is selected under is_fellowship *This field has a 250 character limit |
|
military_rank_name |
Options: Warrant Officer |
|
continuing_education_major_name |
If the student is pursuing additional education, their relevant major. *This field has a 250 character limit |
|
other_compensation_amount |
Any additional compensation the student is receiving. Requirements: -Must be a numerical value, without any decimals or special characters. |
|
employer_industry_name |
The employer's associated industry for the job the student has accepted. Must be one of the following options:
|
|
specialization |
Student's specialization, if any. *This field has a 250 character limit |
|
is_fellowship |
Whether or not the student accepted a fellowship. Requirements: TRUE/FALSE |
|
continuing_education_education_level_name |
The additional education the student is pursuing, if any. Must be one of the following options:
|
|
other_employment_category_name |
Can include the student's employment category here if it wasn't listed under employment_category_name. *This field has a 250 character limit |
|
employed_during_education |
Whether or not the student was employed during their education at your institution. Requirements: TRUE/FALSE |
|
knowledge_source |
Where you obtained these FDS responses from (i.e. LinkedIn, Family, Phone Call, etc). *This field has a 250 character limit |
|
knowledge_response |
Whether or not these responses were entered on behalf of the student. Requirements: TRUE/FALSE |
|
authorized_to_work_in_us |
Whether or not the student is authorized to work in the U.S. Requirements: TRUE/FALSE |
|
latest_response |
Whether this is the student's latest response/data. Requirements: TRUE/FALSE |
You can also download the attached file below as a reference guide for your FDS responses.