Assignment Submission & Scores Analysis

*Export file fields are listed in alphabetical order

artifact_name

Name of the submitted artifact/file associated with the assignment submission.

assessor_email

Email address of the assessor/scorer associated with the score record. For LMS/Import Scores assignments, this may default to the course Instructor when no scorer exists.

assessor_first_name

First name of the assessor/scorer associated with the score record. For LMS/Import Scores assignments, may default to the course Instructor when no scorer exists.

assessor_last_name

Last name of the assessor/scorer associated with the score record. For LMS/Import Scores assignments, may default to the course instructor when no scorer exists.

assessor_university_id

Institution/university identifier for the assessor (from SIS/identity mapping), if available.

assessor_user_id

User identifier for the assessor/scorer.

assignment_id

Unique identifier of the assignment in LMS context.

assignment_linked

Indicates whether the assignment is linked/mapped to outcomes and/or program context.

assignment_name

Assignment title/name as configured in the course.

assignment_type

Assignment source/type.

college_code

College code from the course hierarchy.

college_id

Unique identifier for the college in the hierarchy.

college_name

College display name.

course_code

Course code (e.g., BIO 101) for the course offering/context.

course_id

Unique identifier for the course entity.

course_learning_objective_code

Code/identifier of the course learning objective associated with the assignment/outcome mapping (if applicable).

course_learning_objective_description

Description/text of the course learning objective associated with the assignment/outcome mapping (if applicable).

course_name

Course name/title.

course_section_code

Course section code.

course_section_id

Unique identifier for the course section.

course_section_name

Course section name.

course_subject_code

Subject/discipline code for the course (e.g., BIO, ENG).

department_code

Department code from the course hierarchy.

department_id

Unique identifier for the department in the hierarchy.

department_name

Department display name.

expected_level

Expected performance level for the mapped outcome (when outcome mappings include an expected level/benchmark).

is_scored

Flag indicating whether the submission has been scored/has score data available (true/false).

is_submitted

Flag indicating whether the student has a recorded submission for the assignment (true/false).

linked_to_program

Flag indicating whether the assignment/outcome mapping is linked to a program (true/false).

overall_score

Overall score value for the student’s assignment.

overall_score_possible

Maximum possible overall score for the assignment (points possible/total possible).

program_code

Program code for the linked program (if the assignment/outcome mapping is program-linked).

program_name

Program name for the linked program (if applicable).

quiz_question_description

Text/description of a quiz question when the assignment includes quiz-question-level scoring detail (if applicable). Null/blank when not applicable.

quiz_question_possible_points

Possible points for the quiz question (if applicable).

quiz_question_value

Points/score earned for the quiz question (if applicable).

rubric_criteria_description

Description of the rubric criterion being reported (if rubric criteria detail exists). Null/blank when not applicable.

rubric_criteria_name

Name/title of the rubric criterion (if applicable).

rubric_criteria_possible_points

Maximum possible points for the rubric criterion (if applicable).

rubric_criteria_value

Numeric/points value earned for the rubric criterion (if applicable).

rubric_criteria_value_name

Selected rubric level/value label for the criterion (e.g., “Meets”, “Exceeds”), if applicable.

rubric_level

Rubric/outcome level achieved used for outcome analysis.

scoring_comment

Comment left by the assessor/scorer for the submission/score (if captured).

student_class_level

Student class level (e.g., Freshman/Sophomore/Junior/Senior/Graduate).

student_degree_code

Degree code for the student’s degree program, if available.

student_degree_name

Degree name for the student’s degree program, if available.

student_email

Student email address.

student_emphasis_code

Student emphasis/concentration code, if available.

student_emphasis_description

Description/name of the student emphasis/concentration, if available.

student_ethnicity

Student ethnicity attribute.

student_first_name

Student first name.

student_gender

Student gender attribute.

student_last_name

Student last name.

student_major_codes

One or more major codes associated with the student. May be delimited/aggregated when multiple majors exist.

student_major_names

One or more major names associated with the student. May be delimited/aggregated when multiple majors exist.

student_outcome_code

Student learning outcome (SLO) code associated with the assignment mapping (if applicable). If multiple outcomes apply, rows may repeat per outcome depending on query design.

student_outcome_description

Description of the student learning outcome associated with the mapping (if applicable).

student_outcome_name

Display name/title of the student learning outcome associated with the mapping (if applicable).

student_university_id

Institution/university identifier for the student, if available.

student_user_id

User identifier for the student.

submitted_date

Date/time the submission was made/recorded (for submitted items). Blank/null when not submitted.

success

Outcome success indicator (e.g., met expected level/threshold) for the mapped outcome analysis, when applicable.

term_code

Academic term code (e.g., 2025FA) for the selected/reporting term context.

term_id

Unique identifier for the academic term.

term_name

Academic term name (e.g., Fall 2025).