Importing Historical FDS Responses

Liz Gehret -

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:

  • Continuing Education
  • Military
  • Not Seeking
  • Still Looking
  • Volunteering
  • Working

*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:

  • High School
  • Associates
  • Certificate
  • Advanced Certificate
  • Bachelors
  • Masters
  • Doctorate
  • Postdoctoral Studies

*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:

  • Entrepreneur
  • Faculty Non-Tenure
  • Faculty Tenure
  • Fellowship
  • Freelancer
  • Organization
  • Other
  • Temporary/Contract Work Assignment
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:

  • Air Force
  • Army
  • Coast Guard
  • Marine Corps
  • Navy

not_seeking_option_name

Required if 'Not Seeking' option is selected under first_destination_response_type_name, with one of the following options:

  • Other
  • Taking a gap year
  • Taking time off
  • Traveling
seeking_option_name

Required if 'Still Looking' option is selected under first_destination_response_type_name, with one of the following options:

  • Continuing Education
  • Employment
 pay_schedule_name

 Options:

  • Hourly Wage
  • Annual Salary
  • Monthly Stipend

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:

  • Full-Time
  • Part-Time
  • Seasonal

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.
  • in_progress
  • submitted
  • unsubmitted

*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:

  • Accounting
  • Actuary
  • Administration
  • Advertising, Media & PR
  • Architecture & Planning
  • Business Development
  • Community & Social Services
  • Construction / Contracting
  • Consulting
  • Counseling
  • Customer/Technical Support
  • Data & Analytics
  • Design / Art
  • Education / Teaching / Training
  • Engineering - Civil / Mechanical / Other
  • Engineering - Web / Software
  • Entrepreneurship
  • Environmental / Sustainability Mgmt
  • Finance
  • Fundraising & Event Management
  • General Management
  • Healthcare Services
  • Hotel / Restaurant / Hospitality
  • Human Resources
  • Information Technology
  • Legal
  • Logistics & Supply Chain
  • Marketing - Brand Management
  • Marketing - General
  • Military & Protective Services
  • Operations / Production
  • Other
  • Political Organizing / Lobbying
  • Product / Project Management
  • Purchasing
  • Quality Assurance
  • Real Estate
  • Research
  • Sales
  • Veterinary / Animal Care
  • Writing / Editing

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
Enlisted
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:

  • Accounting
  • Advertising, PR & Marketing
  • Aerospace
  • Animal & Wildlife
  • Architecture and Planning
  • Automotive
  • Biotech & Life Sciences
  • Civil Engineering
  • Commercial Banking & Credit
  • Computer Networking
  • Construction
  • CPG - Consumer Packaged Goods
  • Defense
  • Design
  • Electronic & Computer Hardware
  • Environmental Services
  • Farming, Ranching and Fishing
  • Fashion
  • Food & Beverage
  • Forestry
  • Government - Local, State & Federal
  • Healthcare
  • Higher Education
  • Hotels & Accommodation
  • Human Resources
  • Insurance
  • Interior Design
  • International Affairs
  • Internet & Software
  • Investment Banking
  • Investment / Portfolio Management
  • Journalism, Media & Publishing
  • K-12 Education
  • Legal & Law Enforcement
  • Management Consulting
  • Manufacturing - Other
  • Medical Devices
  • Movies, TV, Music
  • Natural Resources
  • NGO
  • Non-Profit - Other
  • Oil & Gas
  • Other Agriculture
  • Other Education
  • Other Industries
  • Performing and Fine Arts
  • Pharmaceuticals
  • Politics
  • Real Estate
  • Religious Work
  • Research
  • Restaurants & Food Service
  • Retail Stores
  • Scientific and Technical Consulting
  • Social Assistance
  • Sports & Leisure
  • Telecommunications
  • Tourism
  • Transportation & Logistics
  • Utilities and Renewable Energy
  • Veterinary
  • Wholesale Trade

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:

  • High School
  • Associates
  • Certificate
  • Advanced Certificate
  • Bachelors
  • Masters
  • Doctorate
  • Postdoctoral Studies

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 this example file as a reference guide for your FDS responses.

Was this article helpful?
1 out of 4 found this helpful
Have more questions? Submit a request