item_bank_id

ID of the Item Bank that this item belongs to.

item_bank_name

Name of the Item Bank that this item belongs to.

item_bank_level

The level the Item Bank applies to. Its potential values are section and question.

assessment_run_id

The ID of the assessment run (i.e specific test). Each assessment has a unique assessment_run_id.

This ID is a combination of a set of questions, a specific time when this assessment is run, and a group of users that are taking this test.

withdrawn

Binary variable that indicates whether the student has withdrawn from the test, or not. Possible values are TRUE and FALSE.

question_set_title

The title of the question set.

question_set_content_item_id

The ID of the question set used for this assessment.

question_set_content_revision_id

The revision ID of the question set used for this assessment.

assessment_start_time

Timestamp of assessment run’s start time.

This is not the individual start time for each test taker, often all test takers who took the same assessment have the same assessment_start_time.

assessment_end_time

Timestamp of assessment run’s end time.

This is not the individual end time for each test taker, often all test takers who took the same assessment have the same assessment_end_time.

item_lifecycle_state

Not applicable for CTT test analysis

item_status

Not applicable for CTT test analysis

section_metadata

Custom fields metadata of the section as set by the user.

section_order

The order of the section in the question set as specified in the QTI.

question_content_item_id

The unique ID for the question

question_content_revision_id

The ID of the question revision.

measure_id

ID for the measure

question_title

The title of the question.

question_type

The type of the question (e.g. multiple choice)

question_automatic_score

The score of the question automatically calculated by the platform. The question_automatic_score should be the sum of all interaction_automatic_scores that belong to that question.

If the question has only one interaction, question_max_score and interaction_max_score should be the same.

question_manual_score

If is_manually_scored is set to true, question_automatic_score will be null and question manual score should be used.

Must be sorted in the same way as marker_id so that one can infer which marker_id maps to which question_manual_score.

However, currently we don’t get any manual scores, even in the case of questions that should be manually scored, like essays.

feedback

Variable that indicates whether a response was registered or not, and to what degree (answered, unanswered, partially answered, etc.)

Potential values are:

• feedback_wrong

• feedback_correct

• feedback_partially_correct

• feedback_unanswered

• feedback_answered

Note: The feedback variable is on the question level. That means that:

• feedback = feedback_correct when all the interactions inside one question are correct

• feedback = feedback_wrong when all the interactions inside one question are wrong

• feedback = feedback_partially_correct when some of the interactions inside one question are wrong and some are correct

question_duration_seconds

The duration (in seconds) that it took the test taker to complete this specific question.

response_timestamp

Timestamp that identifies when the response was sent to the server.

question_max_score

Theoretical maximum score possible for the question.

question_labels

A list of the user-defined labels associated with the question.

question_metadata

Custom fields metadata associated to the question and set by the end user.

question_order_in_section

The order of the question in the section. If there is only one question in a section, question_order_in_section will be 1. If a question does not belong to a section, question_order_in_section will be null.

interaction_id

ID of the interaction

response_variable_interaction_id

ID for the response variable interaction

interaction_automatic_score

The score of the interaction automatically calculated by the platform.

interaction_max_score

Theoretical maximum score possible for the interaction.

response_text

The text associated with the response that the test taker registered. This can be a word, a sentence or an essay depending on question type.

response_scorable_item_id

The response_variable_response_id associated with the response that this test taker registered (distractor that the test taker selected).

Will be set to null for question types that don’t include possible response options (distractors).

interaction_order_in_question

The order of the interaction within the question

user_id

The user ID of the test taker

global_person_id

Global ID for the person

candidate_org_unit_node_path

Full path stored for each leaf node of organisational unit that test taker belongs to.

Should be sorted so that the same element index maps to the same unit node across candidate_org_unit_node_path and candidate_org_unit_node_path_names.

candidate_org_unit_node_path_names

Names associated with full path ids listed in candidate_org_unit_node_path.

Should be sorted so that the same element index maps to the same unit node across candidate_org_unit_node_path and candidate_org_unit_node_path_names.

row_timestamp

The time of which this record was generated. Upon conflicts the record with the latest row_timestamp will always be used.

Format is yyyy-MM-ddTHH:mm:ssZ