Skip to main content
All CollectionsData and SecurityAdvanced Data Questions
Removing your data from Student CRM: What Student data is available?
Removing your data from Student CRM: What Student data is available?

What data you can take out of the system

Steph Stevens avatar
Written by Steph Stevens
Updated over a week ago

Please note this article refers to permanently removing your data from Student CRM. Please see this article if you want to export a small amount of data for use offline.

Your student data is stored in Student CRM in a particular format (complex). Returning your student data to you (as a simple CSV file) imposes certain limitations, so not all fields and values can be included. What we provide is a data file of Students and a data file of Logs. Both data files are in CSV format with a header record in the first row.

The Student data file contains the very latest values in the Student Database and includes the following fields:

Student_establishment_name, Student_id, Student_title, Student_first_name, Student_middle_name, Student_last_name, Student_email_address, Student_telephone_number, Student_mobile_number, Student_address_1, Student_address_2, Student_address_3, Student_town, Student_county, Student_postcode, Student_country_name, Student_date_of_birth, Student_gender, Student_ucas_applicant_ref, Student_nationality_name, Student_created, Student_modified, Student_mis_code, Student_year_of_entry, Student_opt_in_email, Student_opt_in_sms, Student_opt_in_postal, Student_opt_in_phone, Student_course_name, Student_course_aim, Student_course_ucas_code, Student_source, Student_occupation, Student_level_name, Student_faculty_name.

The Logs data file contains all activities logged against each student, ie: ‘requested a prospectus on (date)’, etc, and includes the following fields:

Log_id, Log_establishment_name, Log_module_name, Log_module_occurrence_name, Log_user_name, Log_student_id, Log_log_entry, Log_created, Log_modified

Did this answer your question?