Search

Data Connect data model reference

  • Updated

This feature requires the Data Connect solution. For more information, contact your Customer Success Partner (CSP).

This article describes the tables and columns available in the 360Learning Snowflake database. To query this data, see Access raw learning data with Data Connect.

The 360Learning database is organized into 40+ tables covering users, content, enrollments, and learning activity.

For a visual representation of the entities in the database and their relationships, see the Entity Relationship Diagram (ERD) ↗.

US data hosting limitation: If your data is hosted in the United States, tables marked (Not available for US-hosted clients) are not available in your Data Connect Snowflake instance.

Assessments_outlines

The Assessments_outlines table contains information about the assessment outlines, with one line per assessment.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the assessment outline. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
NAME VARCHAR(16777216) Title of the assessment.
ASSESSOR_INSTRUCTIONS VARCHAR(16777216) Instructions for the assessor.
LEARNER_INSTRUCTIONS VARCHAR(16777216) Instructions for the learner.

Assessments_trackings

The Assessments_trackings table tracks assessment metrics for each user, with one line per user per assessment attempt.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the assessment tracking. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
USER VARCHAR(16777216) Identifier of the user who attempted the assessment. Foreign Key (FK1) [ID > "Users"]
ASSESSMENT_OUTLINE_ID VARCHAR(16777216) Identifier of the assessment outline. FK2 [ID > "Assessments_outlines"]
CONTEXT_TYPE VARCHAR(16777216) Context type of the assessment. For example, if an assessment is made during a path, then the CONTEXT_TYPE is path.
CONTEXT_ID VARCHAR(16777216) Identifier of the context. For example, if an assessment is made during a path, then CONTEXT_ID is the identifier of the path session. FK3 [ID > "Paths_sessions"]
CORRECTED_AT TIMESTAMP_NTZ(9) Correction time, in the format YYYY-MM-DD HH:MI:SS. nullif the assessment has not been corrected yet.
SCORE FLOAT

Score obtained by the user.

nullif the assessment has not been corrected yet or if the assessment is scoreless.
SUCCESS BOOLEAN TRUE if the user passed the assessment, FALSE if the user failed. nullif the assessment has not been corrected yet.
CORRECTED_BY VARCHAR(16777216) Identifier of the user who validated the success of the assessment. nullif the assessment has not been corrected yet. FK4 [ID > "Users"]
ASSESSORS ARRAY List of the assessor's identifiers. FK5 [ID > "Users"]

Audiencebuilders

The Audiencebuilders table contains information of each audience created to automate learner enrollment. Each row in the Audiencebuilders table represents a single created audience.

An audience is a collection of users who share specific criteria. For more information about audiences, see Select a static or a dynamic audience.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the audience. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation date and time of the audience, in the format YYYY-MM-DD HH:MI:SS.
MODIFIED_AT TIMESTAMP_NTZ(9) Modification date and time of the audience, in the format YYYY-MM-DD HH:MI:SS.
EXCLUDED_LEARNER_IDS ARRAY Array of IDs for learners excluded from the filters. Foreign Key 1 (FK1) [ID > "Users"]
FILTERS ARRAY

Criteria that a learner must meet to be included in the audience. Each filter checks a different attribute, such as group membership or custom field. The following fields are included in the filters:

  • uid: A unique identifier for the filter, used to combine filters.
  • attrName: The name of the attribute being checked.
  • type: The category of the attribute being checked. Possible values: certificate-status, group, path-result, user, or user-custom-field.
  • operator: The logical operator for the filter.
ACTIVE BOOLEAN

Determines whether the audience builder rules are being applied.

If set to FALSE, the audience criteria are not being used. This might be set to false if:

  • The session is deleted.
  • The audience builder is not activated for your company.
MODE VARCHAR(16777216)

Audience modes. Possible values:

  • dynamic for audiences that automatically enroll users as soon as they meet the audience criteria, and unenroll them as soon as they cease to meet them.
  • manual for static audiences that enroll only users who meet the audience criteria at the specific moment when the audience is created.

Certificate_outlines

The Certificate_outlines table contains information about certificate templates, with one row per certificate outline.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the certificate outline. Primary Key (PK)
NAME VARCHAR(16777216) Title of the certificate.
GROUP_ID VARCHAR(16777216) ID of the group owning the certificate outline. Foreign Key 1 (FK1) [ID > "Groups"]
CREATED_AT TIMESTAMP_NTZ(9) Timestamp when the certificate outline was created, in the format YYYY-MM-DD HH:MI:SS.
DESCRIPTION VARCHAR(16777216) Description of the certificate.

Certifications

The Certifications table contains information about certificates and their recipients. Each row corresponds to a specific certificate awarded to a specific person. If a person earns the same certificate multiple times, each instance will be recorded as a separate row.

Column Type Definition Keys in the database
ID VARCHAR(16777216) ID of the table. Primary Key (PK)
NAME VARCHAR(16777216) Name of the certificate.
DESCRIPTION VARCHAR(16777216) Description of the certificate.
CERTIFICATION_AUTHORITY VARCHAR(16777216) Organization or authority that issued the certificate, as chosen by the user who created the certificate.
CONTEXT VARIANT

Context indicates where the certificate was obtained:

  • In a path: The context will include the pathId, sessionId, and enrollmentId.
  • In a program: The context will include the sessionId and templateId.
UID VARCHAR(16777216) Unique identifier generated for each certification.
IMAGE VARCHAR(16777216) ID of the image that is displayed in the certificate.
CREATED_AT TIMESTAMP_NTZ(9) Timestamp matching the delivery_at date. For imported certificates, reflects the date the certificate was imported instead.
DELIVERY_AT TIMESTAMP_NTZ(9) Date the certificate was issued.
EXPIRY_AT TIMESTAMP_NTZ(9) Expiration date of the certificate.
LEARNER_ID VARCHAR(16777216) User who received the certificate Foreign Key 1 (FK1) [ID > "Users"]
CERTIFICATE_OUTLINE_ID VARCHAR(16777216) ID of the certificate outline template used. Populated for path certifications. Join with the Certificate_outlines table. FK2 [ID > "Certificate_outlines"]

Challenges

The Challenges table contains information about mobile challenges, with one row per challenge. stores information about mobile challenges, with one row per challenge. It documents the creation, duration, and associated groups for each challenge.

Column Type Definition Keys in the database
ID VARCHAR(16777216) ID of the table. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Date and time where the challenge was created.
COURSE_ID VARCHAR(16777216) ID of the course where the challenge is located. Foreign Key 1 (FK1) [ID > "Courses"]
CREATOR_ID VARCHAR(16777216) ID of the challenge creator. FK2 [ID > "Users"]
END_DATE TIMESTAMP_NTZ(9) Date and time the challenge ends.
GROUP_ID VARCHAR(16777216) ID of the group where the challenge was created. FK3 [ID > "Groups"]
IS_FINISHED BOOLEAN

TRUE if the challenge is finished.

FALSE otherwise.
MESSAGE VARCHAR(16777216) Message of the challenge.
SELECTED_GROUP_IDS ARRAY List of IDs for all groups that have been chosen to participate in the challenge.

Challenge_users_cores

The Challenge_users_cores table tracks user participation and scores for each challenge. It has one row for each user-challenge combination.

(Make sure to use the exact name Challenge_users_cores, not Challenge_users_scores, even though this is really about scores.)

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the table. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Date and time the user-challenge record was created.
ATTEMPT_ID VARCHAR(16777216) ID of the user's attempt on the challenge. Foreign Key 1 (FK1) [ID > "Courses_trackings"]
CHALLENGE_ID VARCHAR(16777216) ID of the challenge being played. FK2 [ID > "Challenges"]
GROUP_ID VARCHAR(16777216) ID for the specific group a user belongs to, which is used to play the challenge. FK3 [ID > "Groups"]
USER_ID VARCHAR(16777216) ID of the user who played the challenge. FK4 [ID > "Users"]
CURRENT_SCORE INTEGER User's current score for the challenge.
DETAILED_SCORES ARRAY A list containing the user's previous scores for this challenge.

Classroom_attendancesheets

The Classroom_attendancesheets table tracks attendance sheets for classroom slots, with one row per attendance sheet.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the attendance sheet. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
CLASSROOMSLOT_ID VARCHAR(16777216) Identifier of the classroom slot this sheet belongs to. Foreign Key 1 (FK1) [ID > "Classroomslots"]
STATUS VARCHAR(16777216) Status of the attendance sheet. Possible values: closed, signed, open, adjustment.

Classroom_learnerattendances

The Classroom_learnerattendances table tracks the attendance status of each learner for classroom slots, with one row per learner per attendance sheet.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the learner attendance record. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
ATTENDANCE_SHEET_ID VARCHAR(16777216) Identifier of the attendance sheet this record belongs to. Foreign Key 1 (FK1) [ID > "Classroom_attendancesheets"]
LEARNER_ID VARCHAR(16777216) Identifier of the learner. FK2 [ID > "Users"]
LEARNER_SIGNATURE_AT TIMESTAMP_NTZ(9) Timestamp when the learner signed the attendance sheet, in the format YYYY-MM-DD HH:MI:SS. null if the learner has not signed.
TRAINER_ID VARCHAR(16777216) Identifier of the trainer who records the attendance. FK3 [ID > "Users"]
TRAINER_SIGNATURE_AT TIMESTAMP_NTZ(9) Timestamp when the trainer signed the attendance sheet, in the format YYYY-MM-DD HH:MI:SS. null if the trainer has not signed.
HAS_ATTENDED BOOLEAN TRUE if the learner attended the classroom session.

Classrooms

The Classrooms table contains information about classrooms, with one line per classroom.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the classroom. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
NAME VARCHAR(16777216) Title of the classroom.
MEDIAS VARCHAR Media attached to a classroom.
IS_VIRTUAL BOOLEAN TRUE if the classroom is virtual, FALSEif the classroom is on-site.
MODIFIED_AT TIMESTAMP_NTZ(9) Timestamp when the classroom was last modified, in the format YYYY-MM-DD HH:MI:SS.
MESSAGE VARCHAR(16777216) Description of the classroom.
TRAINING_OBJECTIVE VARCHAR(16777216) Objective of the classroom.

Classroomslots

The Classroomslots table contains information about the classroom slots, with one line per classroom slot.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the classroom slot. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
START_DATE TIMESTAMP_NTZ(9) Start date and time, in the format YYYY-MM-DD HH:MI:SS.
END_DATE TIMESTAMP_NTZ(9) End date and time, in the format YYYY-MM-DD HH:MI:SS.
CLASSROOM VARCHAR(16777216) Identifier of the classroom. Foreign Key 1 (FK1) [ID > "Classrooms"]
NAME VARCHAR(16777216) Name of the classroom.
IS_VIRTUAL BOOLEAN TRUE if the classroom is virtual, FALSE if the classroom is on-site.
LOCATION VARCHAR(16777216) Location of the classroom.
TRAINERS ARRAY List of trainers identifiers. FK2 [ID > "Users"]
REPORTED_DURATION NUMBER(38,0) Number of hours (as integer) for the reported duration of the classroom slot.
ATTENDANCESHEETS_STATUS ARRAY

List of IDs and statuses of attendance sheets. Possible values for status:

  • closed: A sheet is initially in this status.
  • signed: A sheet is in this status when signed with check-in closed.
  • open: A sheet is in this status when opened for check-in.
  • adjustment: a sheet is in this status when opened for adjustment.
MAX_CAPACITY INTEGER Maximum classroom slot capacity.
CONTEXT_TYPE VARCHAR(16777216)

Type of context.

  • For slots within a path, CONTEXT_TYPE will be set to path.
  • For slots within a program, CONTEXT_TYPE will be set to program.
CONTEXT_ID VARCHAR(16777216) Identifier of the context associated with the classroom slot. For slots within a path, CONTEXT_ID will contain the path session ID. FK3 [ID > "Paths_sessions"]
MODIFIED_AT TIMESTAMP_NTZ(9) Timestamp when the classroom slot was last modified, in the format YYYY-MM-DD HH:MI:SS.

Classrooms_trackings

The Classrooms_trackings table tracks classroom participation, with one line per classroom per user.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the classroom tracking. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
USER VARCHAR(16777216) Identifier of the user who participated in the classroom. Foreign Key (FK1) [ID > "Users"]
CLASSROOMSLOT VARCHAR(16777216) Identifier of the classroom slot. FK2 [ID > "Classroomslots"]
CLASSROOM VARCHAR(16777216) Identifier of the classroom. FK3 [ID > "Classrooms"]
HAS_ATTENDED BOOLEAN TRUE if the user has attended the classroom. FALSE if the user was absent. nullif the user is registered to a classroom slot for which the attendance was not filled.
ATTENDANCE_STATUS VARCHAR(16777216)
  • attended if the learner was added to the attendance list.
  • missed if the learner was not added to the attendance list (and at least one other learner was added to the list).
  • registered if the learner is registered to a classroom slot for which attendance was not filled.
CONTEXT_TYPE VARCHAR(16777216)

Context type in which the classroom took place. For example, if a classroom is part of a path, then the CONTEXT_TYPE is path. Possible values:

  • path
  • program (soon deprecated)
CONTEXT_ID VARCHAR(16777216) Identifier of the context in which the classroom took place. For example, if a classroom is part of a path, then CONTEXT_ID is the identifier of the path session. FK4 [ID > "Paths_sessions"]
END_DATE TIMESTAMP_NTZ(9) End date and time, in the format YYYY-MM-DD HH:MI:SS.
REPORTED_DURATION NUMBER(38,0) Number of hours (as integer) for the reported duration of the classroom slot.
RSVP_GOING BOOLEAN
  • TRUE if the learner accepted the invitation.
  • FALSE if the learner declined the invitation.
  • null if the learner did not respond to the invitation.
MODIFIED_AT TIMESTAMP_NTZ(9) Timestamp when the registration was last modified, in the format YYYY-MM-DD HH:MI:SS.

Coaching_submissioncriteria

The Coaching_submissioncriteria table captures feedback and grade on criteria for submissions made by learners on open questions.

This table is only available with the 360Learning Coaching solution.

Column Type Definition Keys in the database
ID VARCHAR(16777216) NOT NULL Identifier of the criterion in the submission Primary Key (PK)
CRITERION_ID VARCHAR(16777216) ID of the criterion
OPEN_RESPONSE_SUBMISSION_ID VARCHAR(16777216) ID of the response submission Foreign Key 1 [ID > "Openresponsesubmissions"]
GRADE NUMBER(38,0) Grade for the submission
FEEDBACK VARIANT Feedback for the submission
CRITERIA_TITLE VARCHAR(16777216) Title for the criterion

Coaching_submissiongeneralfeedbacks

The Coaching_submissiongeneralfeedbacks table contains the feedback provided by correctors on open questions submissions made by learners.

This table is only available with the 360Learning Coaching solution.

Column Type Definition Keys in the database
ID VARCHAR(16777216) NOT NULL ID of the feedback Primary Key (PK)
FEEDBACK VARIANT Feedback for the submission
OPEN_RESPONSE_SUBMISSION_ID VARCHAR(16777216) ID of the response submission Foreign Key 1 [ID > "Openresponsesubmissions"]

Courses

The Courses table contains information about the courses, with one line per course.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the course row. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
NAME VARCHAR(16777216) Name of the course.
TAGS ARRAY List of tags identified for the course. Foreign Key 1 (FK1) [ID > "Tags"]
IS_SCORM BOOLEAN TRUE if the course is SCORM. FALSE otherwise.
CO_AUTHORS ARRAY List of the co-authors identifiers. FK2 [ID > "Users"]
AUTHOR VARCHAR(16777216) Identifier of the course’s main author. FK3 [ID > "Users"]
DESCRIPTION VARCHAR(16777216) Description of the course.
TYPE VARCHAR(16777216)

Course type. Possible values:

  • standardLearningContent (for SCORM courses)
  • external (for courses from external content providers)
  • native (for courses created on the 360Learning platform)
MODIFIED_AT TIMESTAMP_NTZ(9) Last modification time of course, in the format YYYY-MM-DD HH:MI:SS.
SOURCE_LANG VARCHAR(16777216) The source language of the course.
COURSE_DURATION NUMBER(38,0) The estimated duration of the course.
EXTERNAL_CONTENT VARCHAR(16777216)

If the course is from an external content provider, the following information is displayed:

  • catalogId
  • externalPlatform
  • launchUrl
  • catalogName, when available
  • logoUrl, when available

nullif the course is not part of an external context provider.
IS_ARCHIVED BOOLEAN TRUE if the course is archived, FALSE otherwise.
DELETED_AT TIMESTAMP_NTZ(9) Deletion date (if applicable)
OWNER_GROUP VARCHAR(16777216) ID of the group owning the course FK 4 [ID > "Groups"]
ELEMENTS ARRAY List of activities included in the course.
TRANSLATIONS_LANGS ARRAY Array of objects, each detailing the language code (lang), publication status (boolean published), and assigned translators for a specific course translation.
TRANSLATIONS ARRAY Array of objects, each representing the course translated into a specific language. Each object includes the translated name, description, and content.
IS_TRANSLATION_PUBLISHED BOOLEAN TRUE if the translated version of the course is published, FALSE otherwise.
PRESENTATION_TYPE VARCHAR(16777216)

Type of presentation.

Possible values for internal courses:

  • singlePage : Activities are presented in one continuous, scrolling view.
  • slideshow: Activities are played individually in a fixed sequence.

Always null for external courses
SOCIAL_DISCUSSION_DISABLED BOOLEAN TRUE if the forum and reactions are disabled, null otherwise.
CUSTOMFIELDS ARRAY

Array of custom field values configured at the company level and filled for this course. Each element contains:

  • customFieldId: ID of the field definition
  • name: field label
  • value: field value

NULL if no custom fields are defined or filled for this course.

Courses_generated_with_ai

The Courses_generated_with_ai table lists courses generated using AI features, with one row per course for each AI feature used. A course may appear multiple times if multiple AI features were applied during its creation.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the row. Primary Key (PK)
FEATURE VARCHAR(16777216)

AI feature used to create the course. Possible values:
COURSE VARCHAR(16777216) Identifier of the course. Foreign Key 1 (FK1) [ID > "Courses"]
COURSE_CREATED_DATE TIMESTAMP_NTZ(9) Creation date of the course.
IS_DELETED_WITHIN_24HRS BOOLEAN TRUE if the course is deleted within 24 hours, FALSE otherwise.
FIRST_GENERATED_DATE TIMESTAMP_NTZ(9) Date and time of the first use of the AI feature for the course. For example, if the Qgen feature is used to generate multiple questions, the FIRST_GENERATED_DATE will indicate when the AI feature was first used in the course to create a question.

Courses_trackings

The Courses_trackings table tracks the users' attempts on courses, with one line per user per course attempt.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the course tracking. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
COURSE VARCHAR(16777216) Identifier of the course. Foreign Key 1 (FK1) [ID > "Courses"]
USER VARCHAR(16777216) Identifier of the user. FK2 [ID > "Users"]
SCORE FLOAT Score of the user on the attempt.
RESULT VARCHAR(16777216)

Result of the user on the attempt. Possible values:

  • success
  • retry
  • failed
  • wait
  • null
PROGRESS NUMBER(38,0) Completion rate of the user on the attempt.
TIME_SPENT NUMBER(37,1) Time spent by the user on the attempt, in minutes.
LAST_ACCESSED_AT TIMESTAMP_NTZ(9) Last time the user accessed the course, in the format YYYY-MM-DD HH:MI:SS.
ACCESS_DATES ARRAY Dates and times in which the user has accessed a course, in the format YYYY-MM-DD HH:MI:SS.
COMPLETED_AT TIMESTAMP_NTZ(9) Date and time in which the user has completed the course, in the format YYYY-MM-DD HH:MI:SS.
CONTEXT_TYPE VARCHAR(16777216) Context in which the course was played. For example, if a course is played in the context of a path, then the CONTEXT_TYPE is path.
CONTEXT_ID VARCHAR(16777216) Identifier of the path session in which the course was played. FK3 [ID > "Paths_sessions"]
LANG VARCHAR(16777216) Language the learner is playing the course in.
IS_CURRENT_VERSION BOOLEAN TRUE if the course was played on the latest version.
FALSE if the course was played on a previous version.
DEVICE VARCHAR(16777216)

Device used on the attempt creation. Possible values:

  • android
  • ios
  • web
ENROLLMENT_ID VARCHAR(16777216)

ID of the enrollment that will enable to fetch info about the enrollment (self-assigned vs assigned, enrollment time).

One ID is assigned per learner enrolled in a path session.

 [ENROLLMENT_ID > "Paths_trackings"]
SUBSET_ELEMENTS ARRAY

List of activities of the course played during an attempt.

  • For eSTD courses: This array is always empty.

  • For SCORM courses: Maximum 1 item in the array.

  • For other native and external attempts: Array may contain multiple items.

Each item in the list is an object containing:

  • _id (string, required): The ID of the activity.

  • collection (string, required): The type of the activity. The value is determined by the course type:

    • Native course: medias, polls, questions, or sheets.

    • External course: Always externalContents.

    • SCORM course: Always medias.

  • name (string, optional): The display title of the activity. May be present for external attempts (externalContents) or native attempts with medias collections.

  • downloaded (boolean, optional): TRUE if the activity was downloaded, omitted (null) if not. Present only for native attempts, for any collection.
OFFLINE BOOLEAN

Connectivity source.

TRUE if the attempt was played offline.

FALSE or undefined if the attempt was played online.

Daily_metrics

The Daily_metrics table contains general information on the users who logged into the platform each day, with one line per day.

Column Type Definition Keys in the database
DATE TIMESTAMP_NTZ(9) Date, in the format YYYY-MM-DD. Primary Key (PK)
LOGGED_IN_USERS ARRAY Identifiers of the users that logged in this day. Foreign Key (FK1) [ID > "Users"]

External_contents

The External_contents table stores information about all external learning content integrated with 360Learning, with one row per external content.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Unique identifier for the external content within 360Learning. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Date and time when the external content record was created, in the format YYYY-MM-DD HH:MI:SS.
EXTERNAL_ID VARCHAR(16777216) Identifier for the external content as provided by the external platform.
EXTERNAL_PLATFORM VARCHAR(16777216) Name of the external platform where the content originates.
TITLE VARCHAR(16777216) Title of the external content.
CONTENT_TYPE VARCHAR(16777216)

Type of the external content. Possible values:

  • article
  • assessment
  • audiobook
  • book
  • certificate
  • channel
  • course
  • curriculum
  • interactive
  • journey
  • labs
  • linkedContent
  • mooc
  • null
  • podcast
  • program
  • roleplay
  • specialization
  • topvoice
  • video

Groups

The Groups table contains general information on the groups in the platform, with one line per group.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the group. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
OWNER VARCHAR(16777216) Identifier of the group owner. Foreign Key (FK1) [ID > "Users"]
NAME VARCHAR(16777216) Group name.
ADMINS ARRAY List of the group admins identifiers. FK2 [ID > "Users"]
AUTHORS ARRAY List of the group editors identifiers. FK3 [ID > "Users"]
COACHES ARRAY List of group coaches. FK4 [ID > "Users"]
PARENT_ID VARCHAR(16777216) Identifier of the parent group. FK5 [ID > "Groups"]
USERS ARRAY List of the learners identifiers. FK6 [ID > "Users"]
CATALOG_COURSES ARRAY List of identifiers for the courses included in the group catalog. FK7 [ID > "Courses"]
CATALOG_PSESSIONS ARRAY List of identifiers for the program sessions included in the group catalog. FK8 [ID > "Program_sessions"]
CATALOG_PATH_SESS ARRAY List of identifiers for the paths sessions included in the group catalog. FK9 [ID > "Paths_sessions"]
COACHES_PTEMPLATES ARRAY List of identifiers for the programs shared in the group library. FK10 [ID > "Programs"]
COACHES_COURSES ARRAY List of identifiers for the courses shared in the group library. FK11 [ID > "Courses"]
COACHES_PATHS ARRAY List of identifiers for the paths shared in the group library. FK12 [ID > "Paths"]

Learningneeds

The Learningneeds table contains information about the learning needs, with one line per learning need.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the learning need. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
NAME VARCHAR(16777216) Name of the learning need.
STATUS VARCHAR(16777216)

Status of the learning need. Possible values:

  • new
  • alreadyExists
  • discarded
  • exploring
  • done
  • projectOngoing
VOLUNTEERS ARRAY List of the volunteers' identifiers. Foreign Key (FK1) [ID > "Users"]
EXPERTS ARRAY List of the experts' identifiers. FK2 [ID > "Users"]
GROUP VARCHAR(16777216) Group identifier. FK3 [ID > "Groups"]
ANSWERS ARRAY List of answers.
DELETED_AT TIMESTAMP_NTZ(9) Deletion date, if applicable.
DECLARED_BY VARCHAR(16777216) Identifier of the user who declared the learning need. FK4 [ID > "Users"]

Mails

The Mails table contains one row per email notification sent from the platform.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier for each email record within the Mails table. Primary Key (PK)
TIMESTAMP TIMESTAMP_NTZ(9) Timestamp when the mail was sent, in the format YYYY-MM-DD HH:MI:SS.
STATUS VARCHAR(16777216) Delivery status of the mail.
MESSAGE_ID VARCHAR(16777216) Message ID of the mail. Used to join with mail events.
ERROR VARCHAR(16777216) Error message if the mail failed to send.
MAIL_TYPE VARCHAR(16777216) Type of the mail.
USER_EMAIL VARCHAR(16777216) Email address of the recipient user.
USER_ID VARCHAR(16777216) ID of the recipient user. Foreign Key 1 (FK1) [ID > "Users"]
MAIL_FROM VARCHAR(16777216) Sender email address.
MAIL_TO VARCHAR(16777216) Recipient email address.
SUBJECT VARCHAR(16777216) Subject of the mail.
BODY VARCHAR(16777216) HTML body of the mail. Href links are anonymized.
ATTACHMENTS ARRAY List of attachments in the mail.
HAS_ATTACHMENTS BOOLEAN TRUE if the mail has attachments, FALSE otherwise.
IS_SENT BOOLEAN TRUE if the mail has been sent.
IS_DELIVERED BOOLEAN TRUE if the mail has been delivered to the recipient.
IS_OPENED BOOLEAN TRUE if the mail has been opened by the recipient.
IS_COMPLAINT BOOLEAN TRUE if the recipient filed a spam complaint.
BOUNCE_TYPE VARCHAR(16777216) Type of bounce if the mail bounced. For example: Permanent, Transient. null if the mail did not bounce.
BOUNCE_SUBTYPE VARCHAR(16777216) Subtype of bounce providing more detail on the bounce reason. null if the mail did not bounce.

Medias

The Medias table contains details about any item uploaded and stored on the platform, with one row per media.

Column Type Definition Keys in the database
ID VARCHAR(16777216) ID of the media Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Timestamp indicating when the media was created.
AUTHOR_ID VARCHAR(16777216) ID of the user who uploaded the media. Foreign Key 1 [ID > "Users"]
TYPE VARCHAR(16777216)

Type of the media. Possible values:

  • attachment
  • video
  • slide
  • image
  • pdf
NAME VARCHAR(16777216) Name of the media.

Openresponsesubmissions

The Openresponsesubmissions table contains the responses provided by learners on open questions.

Column Type Definition Keys in the database
ID VARCHAR(16777216) NOT NULL ID of the open response submission Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
RESPONSE_ID VARCHAR(16777216) ID of the response associated with the submission Foreign Key 1 [ID > "Responses"]
STATUS VARCHAR(16777216) Status of the submission (toAssess, success, failure, toRetry)
TEXT VARCHAR(16777216) Text inside the submission
CORRECTED_AT TIMESTAMP_NTZ(9) Time when the submission was corrected
MEDIAS ARRAY Array of media IDs attached to the submission
CORRECTED_BY VARCHAR(16777216) ID of the user who corrected the submission Foreign Key [ID > "Users"]

Paths

The Paths table contains one line per path, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the path. Primary Key
NAME VARCHAR(16777216) Name of the path.
AUTHOR VARCHAR(16777216) Identifier of the path’s main author. Foreign Key (FK1) [ID > "Users"]
CO_AUTHORS ARRAY List of the co-authors identifiers. FK2 [ID > "Users"]
DESCRIPTION VARCHAR(16777216) Path description.
SOURCE_LANG VARCHAR(16777216) Source language of the path.
MODIFIED_AT TIMESTAMP_NTZ(9) Last time the path was modified, in the format YYYY-MM-DD HH:MI:SS.
OWNER_GROUP VARCHAR(16777216) Identifier of the group that owns the path. FK3 [ID > "Groups"]
DURATION NUMBER(38,0) Estimated duration of the path, in hours.
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
TAGS ARRAY List of the tags identifiers. FK4 [ID > "Tags"]
STEPS ARRAY List of the steps’s identifiers. FK5 [ID > "Paths" OR "Courses" OR "Assessments_outlines" OR "Classrooms"]
ADDITIONAL_INFORMATION VARCHAR(16777216) Content of the additional information field in the path.
IS_CHILD_PATH BOOLEAN TRUE if the path is a step within a path, FALSE otherwise.
HAS_CERTIFICATE BOOLEAN TRUE if the path has a certificate, FALSE otherwise.
CERTIFICATE_OUTLINE_ID VARCHAR(16777216) ID of the certificate outline (template) associated with the path. null if the path has no certificate. FK [ID > "Certificate_outlines"]
ARCHIVED_AT TIMESTAMP_NTZ(9) Date and hour when the path was archived.
MANDATORY_OR_REPLAY BOOLEAN

Mandatory replay toggle.

  • TRUE when learners must complete the courses within the path session, even if they have already completed the courses elsewhere.
  • FALSE otherwise.

Paths_groupenrollments

The Paths_groupenrollments table contains one line per group enrollment.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the group enrollment object. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
PATH_ID VARCHAR(16777216) Identifier of the path. FK1 [ID > "Paths"]
SESSION_ID VARCHAR(16777216) ID of the related path session (if exists). FK2 [ID > "Paths_sessions"]
GROUP_ID VARCHAR(16777216) Identifier of the enrolled group. FK3 [ID > "Groups"]

Paths_sessions

The Paths_sessions table contains one line per path session, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the path session. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
NAME VARCHAR(16777216) Path session name.
START_DATE TIMESTAMP_NTZ(9) Start date of the path session.
END_DATE TIMESTAMP_NTZ(9) End date of the path session.
PATH VARCHAR(16777216) Identifier of the path. Foreign Key (FK1) [ID > "Paths"]
INSTRUCTORS ARRAY List of the co-instructors' identifiers. FK2 [ID > "Users"]
MAIN_INSTRUCTOR VARCHAR(16777216) Main instructor identifier. FK3 [ID > "Users"]
OWNER_GROUP VARCHAR(16777216) Identifier of the group that owns the path session. FK4 [ID > "Groups"]
AUDIENCE_BUILDER_ID VARCHAR Identifier of the audience builder that is implemented within the path session. FK5 [ID > "Audiencebuilders"]
WAITLIST_IDS ARRAY List of user IDs that are in the waitlist of the path session. FK6 [ID > "Users"]
MODIFIED_AT TIMESTAMP_NTZ(9) Last time the path session was modified, in the format YYYY-MM-DD HH:MI:SS.
ADDITIONAL_INFORMATION VARCHAR(16777216) Additional information from the Build your training settings.

Paths_trackings

The Paths_trackings table tracks the paths' participation, with one line per user per path attempt.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the path tracking. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
DUE_DATE TIMESTAMP_NTZ(9)

Date by which a learner is expected to complete the path for a given session. It is calculated as the earliest of two dates:

  • The session end date.
  • The latest step due date among all path steps (where each step’s due date is calculated individually based on the learner’s enrollment date and the step’s relative due date)
USER VARCHAR(16777216) Identifier of the user. Foreign Key (FK1) [ID > "Users"]
PATH_ID VARCHAR(16777216) Identifier of the path. FK2 [ID > "Paths"]
PATH_SESSION VARCHAR(16777216) Identifier of the path session. FK3 [ID > "Paths_sessions"]
SCORE NUMBER(38,0) Average of the score of all steps in the path.
PROGRESS NUMBER(38,0) Percentage (in integer number) of the completion rate of the learner in the path.
LEARNER_STATUS VARCHAR(16777216)

Status of the learner on the path. Possible values:

  • awaitingCorrection
  • onTime
  • late
  • completed
RESULT VARCHAR(16777216)

Result of the learner in the path. Possible values:

  • successful
  • retake
  • failed
  • null
ENROLLMENT_ID VARCHAR(16777216)

ID of the enrollment that will enable to fetch info about the enrollment (self-assigned vs assigned, enrollment time).

One ID is assigned per learner enrolled in a path session.

 [ENROLLMENT_ID > "Courses_trackings"]
ENROLLED BOOLEAN
  • TRUE if the learner is still enrolled in the path session
  • FALSE if they were unenrolled
IS_SELF_ENROLLED BOOLEAN
  • TRUE if the user self-enrolled in the path.
  • FALSE if they were enrolled by someone else.
IS_LATEST_ENROLLMENT BOOLEAN
  • TRUE if this attempt is the user’s latest enrollment in the path.
  • FALSE otherwise.
ENROLLED_AT TIMESTAMP_NTZ(9) Time of the learner enrollment in the path, in the format YYYY-MM-DD HH:MI:SS.
TIME_SPENT NUMBER(38,0) Time spent by the learner in the path, in minutes.
COMPLETED_AT TIMESTAMP_NTZ(9) Time when the learner completed the path, in the format YYYY-MM-DD HH:MI:SS.
HAS_CERTIFICATE BOOLEAN
  • TRUE if the learner was granted a certificate
  • FALSE if the learner was not granted a certificate when completing the path.
STEPS ARRAY A list of objects tracking detailed information about the learner’s progress, status, score, and timing for each step within the path.

Paths_userenrollments

The Paths_userenrollments tracks the enrollments of users into a path session, with 1 line per path user enrollment.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the path user enrollment. Primary Key (PK)
PATH_ID VARCHAR(16777216) Identifier of the path. Foreign Key (FK1) [ID > "Paths"]
USER_ID VARCHAR(16777216) Identifier of the user who is enrolled. FK2 [ID > "Users"]
ARCHIVED_AT TIMESTAMP_NTZ(9) Date at which the path user enrollment has been archived (if applicable).
SESSION_ID VARCHAR(16777216) Identifier of the path session. FK3 [ID > "Paths_sessions"]
IS_SELF_ENROLLED BOOLEAN TRUE if the user enrolled themselves, FALSE otherwise.

Polls

This table stores all the opinion questions available on the platform. Each row corresponds to a single opinion question.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the opinion question. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Timestamp when the opinion question was created.
AUTHOR_ID VARCHAR(16777216) ID of the question author. FK1 [ID > "Users"]
ANSWERS ARRAY Answers to the opinion question.
NAME VARCHAR(16777216) Name of the opinion question.
QTYPE VARCHAR(16777216)

Type of the opinion question. Possible values:

  • questionPollMC: Multiple choice.
  • questionPollOpen: Open question.
  • questionPollSC: Single choice question.

Posts

The Posts table contains one line per post, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the post. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
AUTHOR VARCHAR(16777216) Identifier of the writer of the post. Foreign Key (FK1) [ID > "Users"]
TARGET_ID VARCHAR(16777216) Identifier of the context in which the post was published. FK2 [ID > "Courses" OR "Paths" OR "Groups"]
TARGET_TYPE VARCHAR(16777216)

The context type of the post. Possible values:

  • medias
  • questions
  • programSessions
  • posts
  • polls
  • responses
  • courses
  • sheets
  • pages
GROUP VARCHAR(16777216)

Identifier of the group where the post was published.

nullif the post was not made in the context of a group.

 FK3 [ID > "Groups"]
COURSE_ID VARCHAR(16777216) Identifier of the course where the post was published. FK4 [ID > "Courses"]
COMMENT VARCHAR(16777216) Post message.
DETECTED_LANG VARCHAR(16777216) Detected language of the post (fr, en, de…)

Product_discoveries (Available upon request to CS only)

The Product_discoveries table contains feature requests your organization created, filtered by client. One row per feedback.

Table name in the database: datasharing__product_discoveries

Column Type Definition Keys in the database
PK_INTERNAL VARCHAR(16777216) Internal primary key. Primary Key (PK)
DISCOVERY_ID VARCHAR(16777216) Identifier of the feature request.
VISIBILITY_ID VARCHAR(16777216) Identifier used to apply the visibility rule in Data Connect.
TITLE VARCHAR(16777216) Title of the discovery.
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
STATE VARCHAR(16777216) Current state of the discovery. Possible values: New, In the Roadmap, Done, Archived.
REQUESTER_NAME VARCHAR(16777216) Name of the requester.
REQUESTER_MAIL VARCHAR(16777216) Email of the requester.
DISCOVERY_DUE_DATE ARRAY Due date of the discovery (feature request). An array capturing all due dates if the discovery is related to several features.

Programs

The Programs table contains one line per program template, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the program template. Primary Key (PK)
NAME VARCHAR(16777216) Name of the program template.
AUTHOR VARCHAR(16777216) Identifier of the program template author. Foreign Key (FK1) [ID > "Users"]
DESCRIPTION VARCHAR(16777216) Description of the program template.
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
MODIFIED_AT TIMESTAMP_NTZ(9) Last modification time, in the format YYYY-MM-DD HH:MI:SS.
OWNER_GROUP VARCHAR(16777216) Identifier of the group that owns the program template. FK2 [ID > "Groups"]
DURATION NUMBER(38,0) Estimated duration of the program, in hours.
IS_DELETED BOOLEAN TRUE if the program template is deleted, FALSE otherwise.
TAGS ARRAY List of the tags’ identifiers associated with the program template. FK3 [ID > "Tags"]
MODULES ARRAY List of the modules’ identifiers. FK4 [ID > "Courses"]
IS_ARCHIVED BOOLEAN TRUE if the program template is archived, FALSE otherwise.

Program_sessions

The Program_sessions table contains one line per program session, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the program session. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
NAME VARCHAR(16777216) Name of the program session.
DESCRIPTION VARCHAR(16777216) Description of the program session.
START_DATE TIMESTAMP_NTZ(9) Session start date, in the format YYYY-MM-DD HH:MI:SS.
END_DATE TIMESTAMP_NTZ(9) Session end date, in the format YYYY-MM-DD HH:MI:SS.
USERS_PROGRESS VARIANT

Array of users and their associated progress in the program session.

The possible values for the associated progress are:

  • success
  • failure
  • percentage of completion
AUTHOR VARCHAR(16777216) Author of the program session. Foreign Key 1 (FK1) [ID > "Users"]
GROUPS ARRAY List of groups assigned to the program session. FK2 [ID > "Groups"]
TUTORS ARRAY List of instructors of the program sessions. FK3 [ID > "Users"]
TAGS ARRAY List of tags associated with the program session. FK4 [ID > "Tags"]
LANG VARCHAR(16777216) Language of the program session.
DELETED BOOLEAN TRUE if the program session was deleted, FALSE otherwise.
PROGRAM_DURATION NUMBER(38,0) Theoretical duration of the program, in hours.
MODIFIED_AT TIMESTAMP_NTZ(9) Date of last modification of the program session.
PROGRAM_TEMPLATE_ID VARCHAR(16777216) Identifier of the program template. FK5 [ID > "Programs"]
MODULES ARRAY List of course identifiers. FK6 [ID > "Courses"]
OPEN_USERS ARRAY

List of user identifiers for those who self-enrolled in the program session.

null if no users have self-enrolled.

 FK7 [ID > "Users"]

Programs_trackings

The Programs_trackings table tracks the program participation for each user, with one line per user per program session.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the program tracking. Primary Key (PK)
USER_ID VARCHAR(16777216) Identifier of the user. Foreign Key (FK1) [ID > "Users"]
PROGRAM_TEMPLATE_ID VARCHAR(16777216) Identifier of the program template. FK2 [ID > "Programs"]
PROGRAM_SESSION_ID VARCHAR(16777216) Identifier of the program session. FK3 [ID > "Program_sessions"]
SCORE NUMBER(38,0) Average of the scores in all the program steps.
PROGRESS NUMBER(38,0) Completion rate of the user in the program.
RESULT VARCHAR(16777216)

Result of the user in the program. Possible values:

  • success
  • failure
  • null
ENROLLED BOOLEAN Always equal to TRUE.
IS_SELF_ENROLLED BOOLEAN

TRUE if the user self-enrolled in the program.

FALSE if the user was enrolled in the program by someone else.
TIME_SPENT NUMBER(38,0) Time spent by the learner in the program, in minutes.
COMPLETED_AT TIMESTAMP_NTZ(9) Time when the learner completed the path, in the format YYYY-MM-DD HH:MI:SS.
HAS_CERTIFICATE BOOLEAN

TRUE if the learner was granted a certificate.

FALSE if the learner was not granted a certificate upon program completion.

Projects

The Projects table contains one line per project, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the project. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
COMPLETED_AT TIMESTAMP_NTZ(9) Completiontime, in the format YYYY-MM-DD HH:MI:SS.
NAME VARCHAR(16777216) Name of the project.
GROUP VARCHAR(16777216) Identifier of the group the project belongs to. Foreign Key (FK1) [ID > "Groups"]

Questions

The Questions table stores all the questions available on the platform. Each row corresponds to a single question.

Column Type Definition Keys in the database
ID VARCHAR(16777216) ID of the question. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Timestamp when the question was created.
AUTHOR_ID VARCHAR(16777216) ID of the person who created the question. Foreign Key (FK1) [ID > "Users"]
NAME VARCHAR(16777216) Name of the question.
ANSWERS ARRAY

A list of potential responses defined by the author. Content varies by QTYPE.

  • This field is null for almost all question types except questionMC and questionSingleSelection.

  • For questionMC and questionSingleSelection: Each object represents a single choice and contains:

    • label(string, required): The text of the answer option displayed to the learner.

    • valid (boolean, optional): Indicates whether this option is correct (true) or not. If omitted, the answer is incorrect.
QTYPE VARCHAR(16777216)

Type of the question. Possible values:

  • questionTF: True/False

  • questionSingleSelection: Single selection

  • questionMC: Multiple choice

  • questionOrder: Ordered question

  • questionLinker: Linker

  • questionArea: Pick-a-point

  • questionGap: Fill in the blank

  • questionOpen: Open question

  • questionVideoPitch: Video pitch

  • questionScreencastDemo: Screencast Demo

Reactions

The Reactions table contains one line per reaction, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the reaction. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
AUTHOR_ID VARCHAR(16777216) Identifier of the user who reacted. Foreign Key (FK1) [ID > "Users"]
GROUP_ID VARCHAR(16777216) Identifier of the group the reaction belongs to. FK2 [ID > "Groups"]
COURSE_ID VARCHAR(16777216) Identifier of the course the reaction belongs to. FK3 [ID > "Courses"]
PATH_SESSION_ID VARCHAR(16777216) ID of the related path session (if exists). FK4 [ID > "Paths_sessions"]
TARGET_ID VARCHAR(16777216) Identifier of the target the user reacted to. FK5 [ID > "Courses" OR "Posts"]
COLLECTION VARCHAR(16777216)

Type of the target of the reaction. Possible values:

  • activities
  • courses
  • posts
  • paths
  • comments
  • replies
  • sheets
  • questions
  • medias
ARCHIVED_AT TIMESTAMP_NTZ(9) Time at which the reaction was archived, if applicable. In the format YYYY-MM-DD HH:MI:SS.
TYPE VARCHAR(16777216)

Reaction type. Possible values:

  • like: For "I LIKE IT" reactions.
  • learned: For "I LEARNED SOMETHING" reactions.
  • useful : For "YES, I'LL USE THIS!" responses to "Was this course useful to you?"
  • confused for "I HAVE A QUESTION" reactions.
  • irrelevant: For "I DON'T THINK SO" responses to "Was this course useful to you?"
  • outdated: For "THIS IS OUTDATED" reactions.
TEXT VARCHAR(16777216) Text the learner entered along with the reaction, if any.

Registered_users__monthly

The Registered_users__monthly table captures the number of registered users per month on the platform.

A registered user is a user created on the platform whose profile is not deleted and whose status is no longer “invited.”

Column Type Definition Keys in the database
DATE TIMESTAMP_NTZ(9)

Reporting cut-off date, meaning its value changes based on the current date when the data is processed.

  • For completed months: It's the last day of the month.
  • For the ongoing month: It's the previous date (yesterday).

Primary Key (PK)
MONTH_DATE TIMESTAMP_NTZ(9) Month the data belongs to.
NB_REGISTERED_USERS NUMBER
Count of unique registered user IDs.
REGISTERED_USER_IDS ARRAY List of the registered user IDs.
REGISTERED_USER_MAILS ARRAY List of the registered user mails.

Responses

The Responses table captures the user answers to questions in courses.

Column Type Definition Keys in the database
ID VARCHAR(16777216) NOT NULL Identifier of the response Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
AUTHOR_ID VARCHAR(16777216) User ID of the author Foreign Key 1 [ID > "Users"]
COURSE_ID VARCHAR(16777216) ID of the course where the question is located Foreign Key 2 [ID > "Courses"]
ATTEMPT_ID VARCHAR(16777216) ID of the attempt Foreign Key 3 [ID > "Courses_trackings"]
QUESTION_ID VARCHAR(16777216) ID of the question Foreign Key 4 [ID > "Questions"]
QUESTION_TYPE VARCHAR(16777216) Type of the question
IS_SUCCESS BOOLEAN true if the answer to the question is correct, false otherwise.
POLL_ID VARCHAR(16777216) ID of the related poll. Foreign Key 5 [ID > "Polls"]
ANSWER VARIANT Answer submitted by the user. Can be an array, JSON object, or string depending on the question type.

Sheets

The Sheets table contains details about the cheat sheets on the platform, with one row per sheet.

Column Type Definition Keys in the database
ID VARCHAR(16777216) ID of the sheet. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
AUTHOR_ID VARCHAR(16777216) ID of the author who created the sheet. Foreign Key 1 [ID > "Users"]
NAME VARCHAR(16777216) Name of the sheet

Skills_aggregated_users_stats (Not available for US-hosted clients)

This table requires the Skills solution.

Aggregated per-user statistics showing required skills, validation status, and skill gaps for their current jobs.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Primary key combining user ID and company ID. Primary Key (PK)
USER_ID VARCHAR(16777216) Unique user ID. Foreign Key 1 [ID > "Users"]
USER_NAME VARCHAR(16777216) Full name of the user.
GROUP_IDS ARRAY List of group IDs the user belongs to.
MANAGER_IDS ARRAY List of manager IDs associated with the user.
TOTAL_REQUIRED_SKILLS NUMBER Total number of distinct skills required for the user's current jobs.
COUNT_VALIDATED NUMBER Number of required skills that have been validated for the user's current jobs.
COUNT_PENDING_VALIDATION NUMBER Number of required skills pending validation for the user's current jobs.
COUNT_TO_ASSESS NUMBER Number of required skills that need assessment or are not yet possessed for the current jobs.
ASSESSMENT_STATUS VARCHAR(16777216)

Overall assessment status for the user's current jobs. Possible values:

  • toAssess
  • pendingValidation
  • validated
COUNT_NO_TARGET NUMBER Number of required skills without a defined target level.
COUNT_SKILL_GAP NUMBER Number of required skills where the user's skill level is below the target level.
COUNT_NO_GAP NUMBER Number of required skills where the user's skill level meets or exceeds the target level.
SKILL_GAP_STATUS VARCHAR(16777216)

Overall skill gap status for the user's current job. Possible values:

  • skillGap
  • noGap

Skills_job_skills (Not available for US-hosted clients)

This table requires the Skills solution.

The Skills_job_skills table defines the relationship between jobs and the skills required for them, including specific qualification requirements. Each row represents a unique association between a job and a skill.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Unique identifier for this job-skill association, typically a composite of job_id and skill_id. Primary Key (PK)
JOB_ID VARCHAR(16777216) External ID of the job. FK1 [ID > "Skills_jobs"]
SKILL_ID VARCHAR(16777216) External ID of the skill. FK2 [ID > "Skills_skills"]
SKILL_REQUIREMENTS ARRAY(VARCHAR) Array of qualifiers associated with the job, in the format { id: qualifier_id ; type: gte, lte, equal, in, exists; value: value}.

Skills_jobs (Not available for US-hosted clients)

The Skills_jobs table provides a record of jobs and their corresponding details, with one row per job.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Unique identifier for the job. Primary Key (PK)
EXTERNAL_ID VARCHAR(16777216) External ID of the job, as provided by an external system.
NAME VARCHAR(16777216) Name of the job.

Skills_qualifiers (Not available for US-hosted clients)

This table requires the Skills solution.

The Skills_qualifiers table stores information about the qualifiers used to describe skills. Each row in this table represents a unique skill qualifier.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the qualifier. Primary Key (PK)
NAME VARCHAR(16777216) Name of the qualifier
TYPE VARCHAR(16777216) Type of the qualifier.
POSSIBLE_VALUES ARRAY(VARCHAR) Array of IDs representing the possible values for this qualifier. Foreign Key 1 (FK1) [ID > "Skills_qualifiers"]
POSSIBLE_VALUES_NAME ARRAY(VARCHAR) Array of names corresponding to the possible values for this qualifier.

Skills_reviews (Not available for US-hosted clients)

This table requires the Skills solution.

The Skills_reviews table records all review actions performed on skills within the system, with one row per skill review event.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Unique identifier for the review. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Date and time when the review was performed.
ASSESSOR_ID VARCHAR(16777216) Unique ID of the user who performed the review. Foreign Key 1 (FK1) [ID >"Users"]
USER_ID VARCHAR(16777216) Unique ID of the user whose skill was reviewed. FK2 [ID >"Users"]
ACTION_TYPE VARCHAR(16777216)

Type of review action performed. Possible values:

  • skillAdded
  • skillDeleted
  • SkillAssessed
COMMENT VARCHAR(16777216) Text comment associated with the review.
SKILL_ID VARCHAR(16777216) ID of the skills that was reviewed. FK3 [ID > Skills_skills]
QUALIFIERS ARRAY(VARCHAR) Array of qualifier IDs and their associated values.

Skills_skills (Not available for US-hosted clients)

This table requires the Skills solution.

The Skills_skills table stores information about each skill within the system, with one row representing a unique skill, including its hierarchy, associated libraries, and qualification levels.

Column

Type

Definition

Keys in the database
ID

VARCHAR(16777216)

Unique identifier for the skill.

Primary Key (PK)
EXTERNAL_ID

VARCHAR(16777216)

Identifier for the skill from an external system, if applicable.
NAME

VARCHAR(16777216)

Name of the skill.
SUB_SKILLS

ARRAY(VARCHAR)

Array containing the IDs of the direct sub-skills that fall under this skill.
PARENT_SKILLS

ARRAY(VARCHAR)

Array containing the IDs of the direct parent skills to which this skill belongs.
LIBRARY_CONTEXT_ID

VARCHAR(16777216)

ID of the skill library to which this skill belongs.
LIBRARY_CONTEXT_NAME

VARCHAR(16777216)

Name of the skill library to which this skill belongs.
MAIN_LEVEL_NAME

VARCHAR(16777216)

Name of the main qualifier for this skill.
MAIN_LEVEL_MAX

NUMBER

Maximum possible level for the main qualifier (for example, if levels range from 1 to 5, this value is 5).
IS_DELETED

BOOLEAN

• TRUE if the skill is deleted.

• FALSE otherwise.
MAIN_QUALIFIER_ID

VARCHAR(16777216)

ID of the main qualifier associated with this skill.

Foreign Key (FK1) [ID > "Skills_Qualifiers"]
OTHER_QUALIFIERS_ID

ARRAY(VARCHAR)

Array IDs for other qualifiers associated with this skill, excluding the main qualifier.

FK2 [ID > "Skills_Qualifiers"]

Skills_user_jobs (Not available for US-hosted clients)

This table requires the Skills solution.

The Skills_user_jobs table tracks the association of users with specific jobs and their current status, with one row per user_job assignment.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Unique identifier for this user-job assignment record. Primary Key (PK)
JOB_ID ARRAY(VARCHAR) Array of IDs of the jobs associated with the user. Foreign Key 1 (FK1) [ID > "Skills_jobs"]
USER_ID VARCHAR(16777216) Unique ID of the user associated with the job. FK2 [ID > "Users]
JOB_STATUS ARRAY(VARCHAR)

Array of strings representing the status of each job. Possible values include:

  • Current
  • Past
  • Target

Skills_user_skills (Not available for US-hosted clients)

This table requires the Skills solution.

The Skills_user_skills table tracks the skills possessed by users and their associated details, such as assessment status and qualification levels. Each row represents a unique combination of a user and a skill.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Unique identifier for this user-skill record. This is typically a composite key formed from user_id and skill_id. Primary Key (PK)
USER_ID VARCHAR(16777216) ID of the user associated with this skill. FK2 [ID > "Users"]
SKILL_ID VARCHAR(16777216) ID of the skill being tracked for the user. FK1 [ID> "Skills_skills"]
SKILL_NAME VARCHAR(16777216) Name of the skill.
MAIN_LEVEL NUMBER Value of the main level qualifier for this skill for this user.
ASSESSMENT_STATUS VARCHAR(16777216)

Current assessment status of the skill for the user. Possible values include:

  • pendingValidation
  • Validated
  • toAssess
EXPECTED_LEVEL NUMBER Expected value for the main level qualifier for this skill for the user.
QUALIFIER_VALUES ARRAY Array of objects, where each object: {id: qualifier_name; value: value}

Tags

The Tags table contains one line per tag, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the tag. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
AUTHOR VARCHAR(16777216) Identifier of the user who created the tag in the platform. Foreign Key (FK1) [ID > "Users"]
NAME VARCHAR(16777216) Name of the tag.
EXTERNAL_ID VARCHAR(16777216) External identifier of the tag if it was imported from external content providers.
IS_MAIN BOOLEAN

TRUE if the tag is set as a main tag.

FALSE otherwise.
SOURCE_LANG VARCHAR(16777216) Source language of the tag.
DEFAULT_LANG VARCHAR(16777216) Default language of the tag.
DEFAULT_LANG_NAME VARCHAR(16777216)

Name of the tag in the default language.

This field is null when the name is already in the default language (that is, source_lang matches default_lang).

Training_skills_tags

The Training_skills_tags table contains the mapping between skills and the courses or paths associated with them.

Column Type Definition Keys in the database
ID VARCHAR(16777216) ID of the skill tag associated with the training content (course or path). Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Timestamp when the skill tag was created.
TRAINING_ID VARCHAR(16777216) Internal ID of the course or path associated with the skill tag.
TRAINING_NAME VARCHAR(16777216) Name of the course or path.
TRAINING_EXTERNAL_ID VARCHAR(16777216) External ID of the course or path. [ID > "Paths" / "Courses"]
SKILL_ID VARCHAR(16777216) ID of the skill. FK1 [ID > "Skills_Skills"]
SKILL_NAME VARCHAR(16777216) Name of the skill.
SKILL_INFERENCE_TYPE VARCHAR(16777216)

Methodology for skill attribution. Possible values:

  • MLInferred (AI-generated)
  • explicit (Manually tagged).
TRAINING_TYPE VARCHAR(16777216)

Type of training content. Possible values:

  • course
  • path

User_logins

The User_logins table tracks user connection events, with one line per event.

Data is available only for events that have occurred since March 19, 2025.

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the login record. Primary Key (PK)
DATETIME TIMESTAMP_NTZ(9) Date and time of the user's authentication.
USER_ID VARCHAR(16777216) Identifier of the user who logged in. Foreign Key 1 (FK1) [ID > "Users"]
CONNECTION_METHOD VARCHAR(16777216)

Authentication method used for the login. Possible values:

  • autoLogin: For users automatically logged in when clicking a link in emails.
  • backoffice: For users logged in via the back office system. During an impersonation session, the system uses the USER_ID of the impersonated user for all actions.
  • invitedUser: Access granted to a user who received an invitation.
  • magicLink: Access granted via a unique link sent via email when the user forgot their password.
  • resetPassword: Access granted following a password reset process.
  • selfRegistration: Access granted after a user creates an account through self-registration.
  • impersonation: Access granted via an admin impersonating another user. During an impersonation session, the system uses the USER_ID of the impersonated user for all actions.
  • loginWithPassword: Standard username and password credential-based login.
  • SAML: Access granted via Security Assertion Markup Language (SAML) SSO authentication.
  • JWT: Access granted via JSON Web Token (JWT) SSO authentication.
  • OIDC: Access granted via OpenID Connect (OIDC) SSO authentication
  • other: Default.

Users

The Users table contains one line per user, with the following information:

Column Type Definition Keys in the database
ID VARCHAR(16777216) Identifier of the user. Primary Key (PK)
CREATED_AT TIMESTAMP_NTZ(9) Creation time, in the format YYYY-MM-DD HH:MI:SS.
MAIL VARCHAR(16777216) Email of the user.
FIRST_NAME VARCHAR(16777216) First name of the user.
LAST_NAME VARCHAR(16777216) Last name of the user.
DELETED BOOLEAN
  • TRUE if the user has been deleted from the platform.
  • FALSE otherwise.
MANAGERS ARRAY List of the managers’ identifiers. Foreign Key (FK1) [ID > "Users"]
CUSTOMFIELDS ARRAY List of custom fields added to the user profile.
ADDITIONAL_INFO VARCHAR(16777216) Value of the field Additional information in a user’s profile.
LAST_LOG_IN_AT TIMESTAMP_NTZ(9) Time the user last logged in, in the format YYYY-MM-DD HH:MI:SS.
EXTERNAL_IDS ARRAY List of the user external identifiers.
ARRAY_DELETED_AT ARRAY Array of dates when the user has been deleted.
IS_INVITED BOOLEAN TRUE if the user has been invited into the platform, FALSE otherwise.
LANG VARCHAR(16777216) Language of the user as set in their profile, represented as a two-character language bigram (for example, en, fr, de).
TO_DEACTIVATE_AT TIMESTAMP_NTZ(9) Date by which the user will be deactivated from the platform.
CREATED_FROM VARCHAR(16777216)

Whether the user has been created through self-registration or not. Possible values:

  • null: The user was not created through self-registration.
  • selfRegistration: The user was created through self-registration.
UPDATED_BY_ID VARCHAR(16777216) Identifier of the user who most recently modified the given user. FK2 [ID > "Users"]
FROM_INVITATION_ID VARCHAR(16777216) Identifier of the user who invited the given user to the platform. FK3 [ID > "Users"]
ARRAY_REACTIVATED_AT ARRAY Array of dates when the user has been reactivated.

Users_monthly_activity (Not available for US-hosted clients)

This Users_monthly_activity table stores data about the monthly activity of each user, with one row per user per month.

Column Type Definition Keys in the database
PK VARCHAR(16777216) Identifier of the user's monthly activity record. Primary Key (PK)
DAY_MONTH DATE Date for which the user's activity is observed.
USER_ID VARCHAR(16777216) Unique identifier of the user. Foreign Key 1 (FK1) [ID > "Users"]
IS_ACTIVE_USER BOOLEAN
  • TRUE if the user has logged in at least once during the month.
  • FALSE otherwise.

Note: Our records for active users are complete from February 2023 forward.
IS_ACTIVE_LEARNER BOOLEAN
  • TRUE if the user has launched at least one course during the month and was not the main author or a co-author of the course played.
  • FALSE otherwise.
IS_ACTIVE_AUTHOR BOOLEAN
  • TRUE if the user has created or edited at least one course-related content (course, page, media, sheet, question, post, path) during the month.
  • FALSE otherwise.
HAS_AUTHORING_RIGHT BOOLEAN
  • TRUE if the user is an editor on at least one group, or is a platform admin, or a platform owner.
  • FALSE otherwise.
Check out our blog for more L&D resources.

Was this article helpful?

0 out of 0 found this helpful


Have more questions? Submit a request