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.
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
Each row represents a single learner submission to a graded assignment, including grade, comment count, and license context.
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.
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.
Each row represents a sellable bundle product with title, identifiers, pricing, and lifecycle fields.
Each row links a tag to a bundle. Join to tags for labels.
Each row represents a name-value pair for a custom or template-driven field on an issued certificate.
Each row represents a field definition configured in a certificate-field block, including label, type, slug, and display settings.
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.
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).
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.
Each row links a course to a client, representing which courses are included in each client's catalog or allocation.
Each row represents a client account with name, slug, balances, and lifecycle flags.
Each row links a tag to a client for segmentation or reporting.
Each row represents a discussion post or reply on a course or other commentable content, including threading and moderation fields.
Each row represents a tenant site with subdomain, branding names, organization link, and status.
Each row represents one attempt by a user on a competency assessment, including scores, pass/fail, and timing.
Each row represents one question within a competency assessment attempt, including question text, answer, and correctness.
Each row represents a competency assessment definition with title and metadata, scoped to a company.
Each row represents a time-stamped learning event in a course (such as a view or progress milestone) with user and license context.
Each row represents a label-value pair for custom metadata on an individual course offering.
Each row represents a learner feedback submission for a course, including the response payload and dismissal state.
Each row represents a custom metadata field on a course group, with one row per field per group.
Each row represents a catalog grouping for courses, including titles, descriptions, and merchandising metadata.
Each row links a tag to a course group for discovery and reporting.
Each row represents an individual course offering with pricing, enrollment windows, seats, progress aggregates, and linkage to a course group.
Each row represents a ledger line for a credit movement, including amounts, initiators, and source/target accounts.
Each row represents a named batch of prepaid credit with balances and expiry dates.
Each row represents a named group used to organize discounts or promotions.
Each row links a tag to a discount group for segmentation.
Each row represents a course- or client-scoped collaboration forum with related settings.
Each row represents an event along a learner's path through a program, including milestones, timing, and due dates.
Each row represents a program definition with pricing, dates, content, and merchandising for a multi-step learning path.
Each row links a tag to a learning path for discovery and grouped reporting.
Each row represents a lesson within a course section, including title, slug, and hierarchy keys.
Each row links a course to a license, representing which courses are entitled under each license.
Each row represents a named license package under a client, optionally parented to another license.
Each row represents a physical or virtual venue for instructor-led training, including address, timezone, and room.
Each row represents an external-tool assessment attempt linked to a course topic, with score and timing.
Each row represents a scheduled session tied to a course, including title, time window, location, and instructor information.
Upcoming change — not yet released. The behavior described below relies on a BI Connector 2 update that has not shipped yet.
Each row represents a stage inside a learning path with completion criteria descriptions.
Each row represents one question-answer pair from an onboarding survey response, with user and survey linkage.
Each row represents an onboarding survey instance scoped to a client.
Each row represents a top-level organization entity that can own multiple company sites.
Each row represents a curated pick list of selectable items with naming and SKU.
Each row links a tag to a pickable group for merchandising filters.
Each row represents a generic catalog product with name, slug, and SKU.
Each row links a tag to a product for catalog segmentation.
Each row represents a commerce purchase with amounts, tax, discounts, success/failure, user, and product context.
Each row represents an answer option for a quiz question, including correctness, points, and order.
Each row represents a question stem and type for reusable assessment content.
Each row represents a per-question outcome within a quiz attempt, including selected answers, correctness, and question text.
Each row represents a single quiz sitting by a learner, including score, pass/fail, duration, and topic linkage.
Each row represents a batch of redemption codes with labels and counts of issued vs redeemed.
Each row represents an individual redeemable code with redemption state and who redeemed it.
Each row represents a single use of a registration code by a user at a point in time.
Each row represents a shareable code that grants access for a number of days with usage limits.
Each row represents a permission template and password policy for a user type.
Each row represents a SCORM interaction-level detail under an attempt, including prompt, learner response, and result.
Each row represents a SCORM package attempt with completion status, scores, and progress for a user on a topic.
Each row records when a user completed a course section.
Each row represents a course outline section with title, order, and status.
Each row represents a subscription billing event with amounts, renewals, refunds, disputes, and subscription period metadata.
Each row represents a reusable label for tagging many object types. Dimension for all tag bridge tables.
Each row represents a learner rating and written review of a course group, with approval state.
Each row represents an individual learning item inside a lesson (page, video, quiz, SCORM, etc.) with settings such as timers and grading.
Each row records a user's confirmed attendance at a specific meeting instance.
Each row represents a bundle a user has purchased or been granted.
Each row represents roll-up progress for a user on a course, including percent complete, time, and views.
Each row represents a user's enrollment in a course with status, certificate flags, and due dates.
Each row represents a user's assignment to a learning path with status, due dates, and related program identifiers.
Each row represents a license seat allocated to an individual user with role and status.
Each row represents a learner or admin profile with contact information, references, balance, role, and activity timestamps.
Each row represents a user waiting for access to a full course, including waitlist status and notification flags.