Table

milestonecourses

Upcoming change — not yet released. The behavior described below relies on a BI Connector 2 update that has not shipped yet.

statusgroupRedshift

All tables

milestonecourses

Upcoming change — not yet released. The behavior described below relies on a BI Connector 2 update that has not shipped yet.

Full schema

View all columns and table relationships (SchemaSpy)

Status group

Yes, this table includes a statusgroup column. See Status Group for details.A milestonecourses row's statusgroup reflects both its own state (the deleted and archived columns on the row) and its parent milestone's state. If the parent milestone has statusgroup = 'd' or 'i', the child row inherits that status even when the child's own deleted or archived is false.

Column details

For columns that appear across many tables (id, companyid, createdat, updatedat, statusgroup), see Common Columns. The columns below are specific to milestonecourses.

milestoneid: id of the parent milestone. Joins to milestones.id.

requirement: how this course or course group contributes toward milestone completion. Values are configured per-milestone in the learning-path setup and typically describe whether the course is required, optional, or counts toward a credit or completion threshold.

contentgrouping, courseid, and coursegroupid

A milestonecourses row points to either a single course or a course group. contentgrouping indicates which:

course: the row targets a single course. courseid is set (joins to courses.id) and coursegroupid is null.
courseGroup: the row targets a course group. coursegroupid is set (joins to coursegroups.id) and courseid is null.

To resolve the target content for any milestonecourses row, branch on contentgrouping and use the corresponding id.

Sample query

select
  t.milestoneid,
  t.contentgrouping,
  t.courseid,
  t.coursegroupid,
  t.requirement
from milestonecourses as t
where t.statusgroup = 'a'
limit 100