Table

competencyassessmentattempts

Each row represents one attempt by a user on a competency assessment, including scores, pass/fail, and timing.

statusgroupRedshift

Each row represents one attempt by a user on a competency assessment, including scores, pass/fail, and timing.

Full schema

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

Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.

select
  t.answeredcount,
  t.competencyassessmentid,
  t.userid,
  t.grade,
  t.correctanswercount
from competencyassessmentattempts as t
limit 100