How to Import Historical FDS Responses

Tawnya -

What data do I need to import FDS responses?

  • Student email
    • The student must exist in Handshake in order to add a first destination response
  • Education level name
  • Employment category name
    • Continuing Education
    • Military
    • Not Seeking
    • Still Looking
    • Volunteering
    • Working

We can help you map this, but Handshake’s options are:

  • 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
    • Other
    • Taking a gap year
    • Taking time off
    • Traveling
  • If Still Looking - Seeking Option Name
    • Continuing Education
    • Employment

Things to consider about importing FDS data

  • Are you planning to report to NACE?
    • If so, we may need additional data from you outside of what is required for imports.
  • Are you importing data in the middle of a collection cycle?
    • If so, we will want to make sure that you can run the reports that you need for each graduating group.
  • Would you like to import data outside of what you see here?
    • At this time, we can’t import fields outside of those listed here.

 

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 importing responses afterward. 

 

All potential fields that you can import - Sample FDS Import CSV

 

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



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