Skip to main content

Analytics & Data

Tables

The full breadth of Redshift tables exposed by the NRT BI Connector. Each table page documents its purpose, status-group support, related platform docs, and a sample query. Full column schemas live in SchemaSpy.

74 tablesRedshiftSchemaSpy

Browse tables

Reference for every BI Connector table, mirrored from the production documentation. Use statusgroup to filter for active, inactive, or deleted records — see the per-table notes below.

Showing 74 of 74 tables

assignmentsubmissions

Each row represents a single learner submission to a graded assignment, including grade, comment count, and license context.

statusgroup
awards

Each row represents a credit or recognition granted to a user for completing an activity or interacting with a catalog item, including amount and resource context.

statusgroup
awardtypes

Each row represents an award type, a configurable category of recognition (such as a badge or credit type) used to label and group individual awards. Award types include display settings like label, plural label, icon, and whether to show on the learner dashboard or not.

bundles

Each row represents a sellable bundle product with title, identifiers, pricing, and lifecycle fields.

statusgroup
bundletags

Each row links a tag to a bundle. Join to tags for labels.

statusgroup
certificatefields

Each row represents a name-value pair for a custom or template-driven field on an issued certificate.

statusgroup
certificatefieldsblocks

Each row represents a field definition configured in a certificate-field block, including label, type, slug, and display settings.

certificates

Each row represents an issued credential for a user on a course, learning path, or external resource, including issue and expiration dates, the template that generated it, and recertification state.

statusgroup
certificatetemplatelabels

Each row represents a single label positioned on a certificate template: the placement (x, y), styling (font size, color, alignment), and which certificate field's value is rendered there. A template typically has many labels (one for the learner's name, one for the course title, one for the issue date, one for the unique identifier, and so on).

statusgroup
certificatetemplates

Each row represents a single certificate template. A certificate template is the configuration used to generate certificates when a learner completes a course or learning path. A template defines the title, expiration rules, recertification behavior, visual asset, and any conditional targeting for a specific user audience. Issued certificates in the certificates table reference the template they were generated from.

statusgroup
clientcourses

Each row links a course to a client, representing which courses are included in each client's catalog or allocation.

statusgroup
clients

Each row represents a client account with name, slug, balances, and lifecycle flags.

statusgroup
clienttags

Each row links a tag to a client for segmentation or reporting.

statusgroup
comments

Each row represents a discussion post or reply on a course or other commentable content, including threading and moderation fields.

statusgroup
companies

Each row represents a tenant site with subdomain, branding names, organization link, and status.

statusgroup
competencyassessmentattempts

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

statusgroup
competencyassessmentresponses

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

statusgroup
competencyassessments

Each row represents a competency assessment definition with title and metadata, scoped to a company.

statusgroup
courseactions

Each row represents a time-stamped learning event in a course (such as a view or progress milestone) with user and license context.

statusgroup
coursecustomfields

Each row represents a label-value pair for custom metadata on an individual course offering.

statusgroup
coursefeedbackresponses

Each row represents a learner feedback submission for a course, including the response payload and dismissal state.

coursegroupcustomfields

Each row represents a custom metadata field on a course group, with one row per field per group.

statusgroup
coursegroups

Each row represents a catalog grouping for courses, including titles, descriptions, and merchandising metadata.

statusgroup
coursegrouptags

Each row links a tag to a course group for discovery and reporting.

statusgroup
courses

Each row represents an individual course offering with pricing, enrollment windows, seats, progress aggregates, and linkage to a course group.

statusgroup
creditactions

Each row represents a ledger line for a credit movement, including amounts, initiators, and source/target accounts.

creditbatches

Each row represents a named batch of prepaid credit with balances and expiry dates.

statusgroup
discountgroups

Each row represents a named group used to organize discounts or promotions.

statusgroup
discountgrouptags

Each row links a tag to a discount group for segmentation.

statusgroup
forums

Each row represents a course- or client-scoped collaboration forum with related settings.

statusgroup
learningpathactions

Each row represents an event along a learner's path through a program, including milestones, timing, and due dates.

statusgroup
learningpaths

Each row represents a program definition with pricing, dates, content, and merchandising for a multi-step learning path.

statusgroup
learningpathtags

Each row links a tag to a learning path for discovery and grouped reporting.

statusgroup
lessons

Each row represents a lesson within a course section, including title, slug, and hierarchy keys.

statusgroup
licensecourses

Each row links a course to a license, representing which courses are entitled under each license.

statusgroup
licenses

Each row represents a named license package under a client, optionally parented to another license.

statusgroup
locations

Each row represents a physical or virtual venue for instructor-led training, including address, timezone, and room.

ltiattempts

Each row represents an external-tool assessment attempt linked to a course topic, with score and timing.

meetings

Each row represents a scheduled session tied to a course, including title, time window, location, and instructor information.

statusgroup
milestonecourses

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

statusgroup
milestones

Each row represents a stage inside a learning path with completion criteria descriptions.

statusgroup
onboardingsurveyresponses

Each row represents one question-answer pair from an onboarding survey response, with user and survey linkage.

statusgroup
onboardingsurveys

Each row represents an onboarding survey instance scoped to a client.

statusgroup
organizations

Each row represents a top-level organization entity that can own multiple company sites.

pickablegroups

Each row represents a curated pick list of selectable items with naming and SKU.

statusgroup
pickablegrouptags

Each row links a tag to a pickable group for merchandising filters.

statusgroup
products

Each row represents a generic catalog product with name, slug, and SKU.

statusgroup
producttags

Each row links a tag to a product for catalog segmentation.

statusgroup
purchases

Each row represents a commerce purchase with amounts, tax, discounts, success/failure, user, and product context.

questionchoices

Each row represents an answer option for a quiz question, including correctness, points, and order.

statusgroup
questions

Each row represents a question stem and type for reusable assessment content.

statusgroup
quizattemptresponses

Each row represents a per-question outcome within a quiz attempt, including selected answers, correctness, and question text.

statusgroup
quizattempts

Each row represents a single quiz sitting by a learner, including score, pass/fail, duration, and topic linkage.

statusgroup
redemptioncodegroups

Each row represents a batch of redemption codes with labels and counts of issued vs redeemed.

statusgroup
redemptioncodes

Each row represents an individual redeemable code with redemption state and who redeemed it.

statusgroup
registrationcoderedemptions

Each row represents a single use of a registration code by a user at a point in time.

statusgroup
registrationcodes

Each row represents a shareable code that grants access for a number of days with usage limits.

statusgroup
roles

Each row represents a permission template and password policy for a user type.

statusgroup
scormattemptresponses

Each row represents a SCORM interaction-level detail under an attempt, including prompt, learner response, and result.

statusgroup
scormattempts

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

statusgroup
sectioncompletions

Each row records when a user completed a course section.

sections

Each row represents a course outline section with title, order, and status.

statusgroup
subscriptionpurchases

Each row represents a subscription billing event with amounts, renewals, refunds, disputes, and subscription period metadata.

tags

Each row represents a reusable label for tagging many object types. Dimension for all tag bridge tables.

statusgroup
testimonials

Each row represents a learner rating and written review of a course group, with approval state.

statusgroup
topics

Each row represents an individual learning item inside a lesson (page, video, quiz, SCORM, etc.) with settings such as timers and grading.

statusgroup
userattendedmeetings

Each row records a user's confirmed attendance at a specific meeting instance.

statusgroup
userbundles

Each row represents a bundle a user has purchased or been granted.

statusgroup
usercourseprogresses

Each row represents roll-up progress for a user on a course, including percent complete, time, and views.

statusgroup
usercourses

Each row represents a user's enrollment in a course with status, certificate flags, and due dates.

statusgroup
userlearningpaths

Each row represents a user's assignment to a learning path with status, due dates, and related program identifiers.

statusgroup
userlicenses

Each row represents a license seat allocated to an individual user with role and status.

statusgroup
users

Each row represents a learner or admin profile with contact information, references, balance, role, and activity timestamps.

statusgroup
waitlists

Each row represents a user waiting for access to a full course, including waitlist status and notification flags.