In order to monitor usage, the application creates views that give aggregate counts of assignments.

​
Application Roles

A user must be mapped to one of the following application roles to access assignments:

  • admin

  • editor

  • analyst

  • wvusage

​
Views

​
Assignments per day

View: experimentation.assignments_per_day

FieldDescriptionData Type
date_createdDate the assignment was createdDATE
assignment_countNumber of assignments created in the given dayINT

​
Assignments per experiment

View: experimentation.assignments_per_experiment

FieldDescriptionData Type
experiment_idID of the experimentVARCHAR
experiment_nameName of the experimentVARCHAR
lab_idID of the lab the experiment belongs toVARCHAR
assignment_countNumber of assignments created in the given experimentINT

​
Examples

Get a daily account of assignments for the month of December 2024

USE <application_name>;

SELECT *
FROM experimentation.assignments_per_day
WHERE date_created >= '2024-12-01' AND date_created < '2025-01-01';