Table

competencyassessmentresponses

Each row represents one question within a competency assessment attempt, including question text, answer, and correctness.

statusgroupRedshift

All tables

competencyassessmentresponses

Each row represents one question within a competency assessment attempt, including question text, answer, and correctness.

Full schema

View all columns and table relationships (SchemaSpy)

Status group

Yes, this table includes a statusgroup column. See Status Group for details.

Platform Documentation

Creating and Using Adaptive Learning Paths

Sample query

select
  t.userid,
  t.competencyassessmentid,
  t.competencyassessmentattemptid,
  t.questionid,
  t.question
from competencyassessmentresponses as t
limit 100