New Quizzes - Classic Quizzes DAP schema crosswalk

Classic and New Quizzes Dataset Schema Connections

New Quizzes employs the Classic Quizzes DAP schema to ensure a smooth transition for customers, with minimal structural changes necessary to reflect product differences. The Following table outlines these structural changes when compared to the Classic Quizzes DAP Schema.

Classic Quizzes Table	New Quizzes Table
Assessment_question_banks	Same fields
Assessment_questions	Field not available: item_id Keys not available in question_data: regrade_option, answers
Assignments	Same fields
Assignment_override_students	Same fields
Quiz_groups	Not available in New Quizzes
Quiz_questions	Includes all attempts (not just final). Field not available: item_id Added field: is_authoritative_result. Keys not available in question_data: regrade_option, answers
Quiz_submissions	Fields not available: submission_id, quiz_version, temporary_user_code, manually_unlocked, score_before_regrade, kept_score submission_data redesigned for usability (includes interaction type and detailed scoring).
Quizzes	Fields not available: assignment_id, unpublished_question_count, question_count, require_lockdown_browser, require_lockdown_browser_monitor, require_lockdown_browser_for_results