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)¶