A_TopicScore

TABLE A_TopicScore

Records in A_TopicScore are created automatically when a participant completes an assessment. They contain topic-specific scoring and score-band information.

Primary Key: Result_ID int NOT NULL

Refers to the associated result, see A_Result.Result_ID.

Primary Key: Topic_ID int NOT NULL

Refers to the associated topic, see Q_Topic_Ex.Topic_ID.

Percentage_Score float

Although stored as a float in the data model percentage scores are rounded to integers using the same method as A_Result.Percentage_Score.

Actual_Score int

Calcualted in the same way as A_Result.Total_Score but counting only questions that are in the associated topic. Experimental questions do not contribute to the value.

Maximum_Score int

Calcualted in the same way as A_Result.Max_Score but counting only questions that are in the associated topic. Experimental questions do not contribute to the value.

Score_Band_Name varchar(200)

The name of the topic scoreband that applies to this score.

Num_Questions int
Topic varchar(1020) NOT NULL
Description varchar(1020)