Table

scormattempts

Each row represents a SCORM package attempt with completion status, scores, and progress for a user on a topic.

statusgroupRedshift

Each row represents a SCORM package attempt with completion status, scores, and progress for a user on a topic.

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.courseid,
  t.userid,
  t.topicid,
  t.topictype,
  t.completionstatus
from scormattempts as t
limit 100