cache_paper_stats

Purpose: Holds statistics of the performance of a paper. Used in the Performance Summary reports.

FieldTypePurpose
paperIDmediumint(8) unsignedID of the paper
cachedint(10) unsignedUnix timestamp when the data was cached.
max_markdecimal(10,5)Maximum student mark on the paper.
max_percentdecimal(10,5)Maximum student percentage on the paper.
min_markdecimal(10,5)Minimum student mark on the paper.
min_percentdecimal(10,5)Minimum student percentage on the paper.
q1decimal(10,5)Quartile 1 percentage.
q2decimal(10,5)Quartile 2 percentage.
q3decimal(10,5)Quartile 3 percentage.
mean_markdecimal(10,5)Mean student mark on the paper.
mean_percentdecimal(10,5)Mean student percentage on the paper.
stdev_markdecimal(10,5)Standard deviation mark.
stdev_percentdecimal(10,5)Standard deviation percentage.

See also: Marks Caching