Survey Data Export | HelioCampus Assessment Management Knowledge Base

Survey Data Export Samples

dw_fact_survey_response.csv

survey_response_id,survey_instance_id,survey_question_map_id,survey_question_map_metric_id,metric_id,term_id,partial_term_id,question_id,question_type_id,question_option_id,value,weight,weighted_value,replaced_course_section_id,parent_course_section_id,course_section_id,course_id,course_version_uuid,subject_code,department_id,college_id,institution_id,response_object_id,clo_id,faculty_id,clo_question_criteria,survey_form_entry_id,survey_schedule_id,survey_template_id,text_response,instructor_only
"1452","4","14",,,"1",,"3","9","7","1",,,"22",,"22","23","E9B5D786-4F5E-4B6F-864AD8DEA24F60D6","NRS","5","6","1",,,,"0","193","4","3",,
"2042","4","14",,,"1",,"3","9","7","1",,,"22",,"22","23","E9B5D786-4F5E-4B6F-864AD8DEA24F60D6","NRS","5","6","1",,,,"0","195","4","3",,
"654","4","14",,,"1",,"3","9","8","2",,,"22",,"22","23","E9B5D786-4F5E-4B6F-864AD8DEA24F60D6","NRS","5","6","1",,,,"0","192","4","3",,

dw_survey_question.csv

survey_instance_id,term_id,survey_schedule_id,survey_template_id,course_section_template_id,course_template_id,department_template_id,college_template_id,institution_template_id,survey_type_id,survey_section_id,survey_question_map_id,survey_question_map_metric_id,weight,metric_id,metric_total_weight,metric_success_value,question_id,clo_question_criteria,question_type_id,question_type_code,survey_instance_section_id,replaced_course_section_id,parent_course_section_id,course_section_id,partial_term_id,course_id,course_version_uuid,subject_code,department_id,college_id,institution_id,section_sort_order,question_map_sort_order,question_order,publicly_visible,response_object_id,clo_id,faculty_id,instructor_only
"4","1","4","3",,,,,,"1","5","14",,,,,,"3","0","9","MCSA","20","22",,"22",,"23","E9B5D786-4F5E-4B6F-864AD8DEA24F60D6","NRS","5","6","1","1","1","1001",,,,,
"4","1","4","3",,,,,,"1","5","14",,,,,,"3","0","9","MCSA","17","11",,"11",,"42","5CF76EEA-B660-434D-BDCCD32DCAAC4094","ENG","3","4","1","1","1","1001",,,,,
"4","1","4","3",,,,,,"1","5","21",,,,,,"10","0","11","TEXT","48","190",,"190",,"42","5CF76EEA-B660-434D-BDCCD32DCAAC4094","ENG","3","4","1","1","7","1007",,,,,

dw_fact_survey_form.csv

form_id,completed_by_user_id,survey_instance_id,is_active,completed_for_user_id,form_type_code,is_available,survey_form_entry_id,submitted_flag,submitted_by_id,submitted_date,survey_instance_section_id,replaced_course_section_id,parent_course_section_id,course_section_id,term_id,partial_term_id,course_id,course_version_uuid,subject_code,department_id,college_id,institution_id
"584","18023","4","t",,"COURSEEVAL","t","584","f",,,"49","199",,"199","1",,"43","5A0B446E-4362-4407-B7583559351297FE","ENG","3","4","1"
"582","18022","4","t",,"COURSEEVAL","t","582","f",,,"49","199",,"199","1",,"43","5A0B446E-4362-4407-B7583559351297FE","ENG","3","4","1"
"579","18021","4","t",,"COURSEEVAL","t","579","f",,,"49","199",,"199","1",,"43","5A0B446E-4362-4407-B7583559351297FE","ENG","3","4","1"

dw_survey_hierarchy.csv

survey_instance_id,status,term_id,activation_date,start_date,end_date,results_available_date,survey_schedule_id,schedule_name,schedule_status,schedule_modifier,schedule_version_uuid,survey_template_id,survey_template_name,survey_type_id,survey_type_name,survey_type_code,survey_type_description
"6","completed","2","2019-02-18 00:00:00-05","2019-02-18 00:00:00-05","2021-06-08 23:59:00-04","2021-06-09 00:00:00-04","6","Institution End of Term Course Evaluation","completed","End","91A0B1C7-9E08-4592-A43019DF0B91B8CD","3","Institution End of Term Course Evaluation","1","Student Course Evaluation","STUCRS","Student Course Evaluation"
"4","completed","1","2019-02-14 00:00:00-05","2018-10-02 00:00:00-04","2022-02-02 23:59:00-05","2022-02-03 00:00:00-05","4","Institution End of Term Course Evaluation","completed","End","2068FFCB-1C49-4624-B95D5A098417A1E1","3","Institution End of Term Course Evaluation","1","Student Course Evaluation","STUCRS","Student Course Evaluation"
"5","completed","1","2019-02-14 00:00:00-05","2018-10-02 00:00:00-04","2019-01-04 23:59:00-05","2019-01-05 00:00:00-05","5","Nursing Middle of Term Course Evaluation","completed","Middle","99ECE026-8CBD-4880-BD3215C7C3591118","17","Nursing Middle of Term Course Evaluation","1","Student Course Evaluation","STUCRS","Student Course Evaluation"

Survey Data Export Table Details

dw_fact_survey_response: The dw_fact_survey_response model is a comprehensive database that collects and organizes survey responses from various educational institutions. It includes details like the survey ID, question ID, course ID, department ID, and the response value, among others. This model can be used to analyze patterns in survey responses, such as common answers to specific questions or correlations between responses and specific courses or departments. This information can be used to improve course content, teaching methods, or overall student satisfaction.
dw_fact_survey_form: The dw_fact_survey_form model is a reference tool that organizes data related to educational surveys. It connects information about the survey, the course, and the institution, such as the user who completed the survey, the course section, and the college. This model can be used to analyze patterns in survey completion, course participation, and institutional trends. For example, it can help identify which courses have the highest survey completion rates or which institutions have the most active users.
dw_survey_question: The dw_survey_question model is a comprehensive database that stores information about various aspects of surveys conducted in an educational setting. It includes details about the survey itself, the course, department, college, and institution it's associated with, the type of question asked, and the responses received. This model can be used to analyze survey data, identify trends, and make informed decisions about course content, teaching methods, and overall educational strategies. It can also help in understanding the effectiveness of different question types and their impact on the survey results.
dw_survey_hierarchy: The dw_survey_hierarchy model is a tool that organizes survey data. It groups information about each survey instance, schedule, template, and type. This includes details like the survey's start and end dates, its status, and its type. This model can be used to track the lifecycle of different surveys, from activation to completion. It can also help identify patterns, such as common survey types or schedules.
question: Contains question code, description including question_type_id.
question_option: Contains question_id and question's description-value definition.
question_type: Describes how a question is displayed like Multi-Choice, Drop-Down, Text, True-False, sort_oder.