GetResultListByAssessment

Assessment_ID

This is the assessment ID of the assessment whose result details are required

String

N

Result_ID

The result ID of the result

String

Assessment_ID

The assessment ID of the assessment that generated the result

String

Write_Answer_Data

This indicates whether answer data is written to the repository database for the result (if it is, it will be in the table A_Answer )

Boolean

Participant

This is the name of the participant who took the assessment that generated the result

String

Member_Group

If the participant who took the assessment that generated the result belonged to a group when they took the assessment, this is the name of the group

String

Participant_Details

The general details of the participant who took the assessment that generated the result

String

Hostname

Hostname of participant (if available) at the start of the session.

String

IP_Address

IP address of participant (if available) at the start of the session.

String

Still_Going

This indicates whether or not the assessment that generated the result is still active

Boolean

Status

0 - Started, 1 - Running, 2 - Finished, 3 - Expired, 4 - Timed out, 5 - Quit

Short

Feedback

0 - No feedback given

1 - Some feedback given

Short

Number_Sections

The number of question blocks in the assessment that generated the result for which replies have been received

Short

Max_Score

The maximum score of all questions answered in the question blocks in the assessment that generated the result

Integer

Total_Score

The participant's actual score for all questions answered in the question blocks in the assessment that generated the result

Integer

Special_1 to 10

These parameters contain information specific to the outcome of the question that generated the result

String

Time_Taken

The time taken, in seconds, between the start and end of the assessment that generated the result (zero if the assessment is still active)

Integer

Score_Band_Title

The title of assessment outcome at end of the assessment that generated the result

String

Score_Band_Number

The number of assessment outcome defined in the assessment that generated the result

Integer

Percentage_Score

The percentage score achieved by the participant for the assessment that generated the result

Short

Schedule_Name

The name of the schedule that the result was generated through, or blank if the assessment was not scheduled

String

Monitored

Indicates whether or not the result came from a monitored schedule or assessment

Boolean

Monitor_Name

If Monitored is set, this is the name of the user (or proctor) performing assessment monitoring

String

TopicScoringList

Topic_ID

The Topic_ID for the topic associated with the result

String

Topic_Name

The full name of the topic associated with the result

String

Description

A short description of the topic associated with the result

String

Percentage_Score

The percentage score for the topic associated with the result

Double

Actual_Score

The actual score for the topic associated with the result

Integer

Maximum_Score

The maximum score for the topic associated with the result

Integer

Num_Questions

The number of questions from the topic associated with the result

Integer

When_Started

Date when the result was first written to the database

String

Session_Last_Modified

This is the date when the assessment to which the result applies was last modified

String

When_Finished

The date when the assessment that generated the result finished, or when last updated if it is still going

String