The Skilljar Data Connector provides customers with direct access to learner data. In this article, you'll find tables that are currently supported via the database management system, PostgreSQL. More details can be found in our Data Dictionary PDF (last updated: 02/23/2022).
Note: All database timestamps are in the UTC timezone.
What is a Data Connector?
Skilljar’s Data Connector is a real-time customer-specific PostgreSQL database hosted on Amazon Web Services. A data connector is a process that moves data from one database to another. The process runs on a schedule, takes data from one location, and writes it to a selected destination location.
Accessing a Direct Database with Skilljar's Data Connector
Skilljar’s Data Connector is a customer-specific PostgreSQL database hosted on Amazon Web Services, enabling easy and reliable integrations with any business intelligence tool that can directly access and query data. The integration allows companies to visualize their learning and certification data in new and powerful ways, as well as analyze and combine training data with business intelligence from other areas of the company.
- Granular Data Analytics
- Use Skilljar with your Business Intelligence Tools, like Tableau, Microsoft Power BI, Looker, SAP Crystal Reports, and more.
- Pipe Skilljar Data Into Your Own Data Warehouse
- Run Advanced Custom Queries
- Share Training Data Throughout Your Organization
Common Fields
There are a few common fields on all tables.
Primary ID
Each table has a primary ID field. The ID is an alphanumeric (lowercase) field up to 32 characters long. The value of the ID is unique across all instances of the particular table, but not necessarily globally unique across all IDs within Skilljar.
Naming of the primary ID field is typically the table name suffixed with “_id”.
Created At
The “created_at” field is a datetime indicating when the given row was created within Skilljar.
Updated At
The “updated_at” field is a datetime indicating when the given row was last updated within Skilljar.
Tables and Fields
Full list of tables and fields:
catalog_page_student_group_visibility
course_series_published_courses
published_course_student_group_visibility
quiz_question_response_chosen_answers
student_lesson_session_time_hourly
training_credit_code_student_group
catalog_page
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
catalog_page_id |
char |
varying(32) |
Unique id of the catalog page |
|
domain_id |
char |
varying(32) |
Unique id of the domain on which the catalog page belongs |
|
is_visible |
bool |
Whether or not the catalog page is visible or hidden by default |
|
|
page_title |
char |
varying(500) |
Title of catalog page |
catalog_page_student_group_visibility
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
catalog_page_student_group_visibility_id |
char |
varying(32) |
Unique id of the catalog_page_student_group_visibility |
|
catalog_page_id |
char |
varying(32) |
Unique id of the catalog page on which this relationship belongs |
|
is_visible |
bool |
The visibility relationship of the catalog page with the group: can the group see the catalog page, or is it hidden from the group. |
|
|
student_group_id |
char |
varying(32) |
Unique id of the student group on which this relationship belongs |
certificate
|
Field name |
Format |
Length |
Description |
| created_at | datetime | timestamp of when the object was created | |
| updated_at | datetime | timestamp of when the object was last updated | |
| certificate_id | char | varying(32) | unique id of the certificate |
| code | char | varying(12) | unique code for the certificate used to create a public url |
| completed_at | datetime | timestamp when the certificate was completed | |
| expires_at | datetime | timestamp for when the certificate will expire | |
| url | char | varying(255) | public url to access the certificate |
course
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
course_id |
char |
varying(32) |
unique id of the course |
|
title |
char |
varying(500) |
title of the course |
|
issue_certificate_upon_completion |
bool |
Whether or not a certificate on completion is assigned and active. If True, a certificate will be issued on completion. If False, a certificate completion action is created but is not active. If Null, a certificate completion action is not created. |
course_series
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
course_series_id |
char |
varying(32) |
unique id of the course series |
|
domain_id |
char |
varying(32) |
unique id of the domain on which the course series belongs |
|
title |
char |
varying(500) |
title of the course series |
|
visible_on_catalog |
bool |
whether or not the course series is visible on the catalog page (True/False) |
course_series_published_courses
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
course_series_published_course_id |
char |
varying(32) |
unique id of the course_series_published_course |
|
course_series_id |
char |
varying(32) |
unique id of the course series |
|
published_course_id |
char |
varying(100) |
unique id of the published course in the series |
domain
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
domain_id |
char |
varying(32) |
unique id of the domain |
|
name |
char |
varying(225) |
domain name |
domain_access_code
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
domain_access_code_id |
char |
varying(32) |
unique id of the access code |
|
code |
char |
varying(255) |
value of the access code |
|
use_count |
int |
how many times the access code has been used |
|
|
max_uses |
int |
how many times the access code can be used total |
|
|
is_active |
bool |
whether or not the access code is active and can be used (True/False) |
|
|
domain_access_code_pool_id |
char |
varying(32) |
unique id of the access code pool the access code belongs to |
domain_access_code_pool
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
domain_access_code_pool_id |
char |
varying(32) |
unique id of the access code pool |
|
name |
char |
varying(255) |
the name of the access code pool |
|
domain_id |
char |
varying(32) |
unique id of the domain the access code pool belongs to |
|
channel |
char |
varying(20) |
How the access code pool was created (API, Import, Dashboard, E-Commerce, Unknown) |
|
starts_at |
datetime |
When codes within this pool become active |
|
|
expires_at |
datetime |
When codes within this pool cease to be active |
domain_membership
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
domain_membership_id |
char |
varying(32) |
unique id of the domain membership |
|
is_active |
bool |
whether or not the domain membership is active |
|
|
expires_at |
datetime |
timestamp when the domain membership will expire |
|
|
domain_id |
char |
varying(32) |
unique id of the domain |
|
domain_access_code_id |
char |
varying(32) |
unique id of the access code |
|
student_id |
char |
varying(32) |
unique id of the student |
domain_signup_field
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
domain_signup_field_id |
char |
varying(32) |
unique id of the signup field |
|
label |
char |
varying(100) |
name of the signup field |
|
domain_id |
char |
varying(32) |
unique id of the domain the signup field belongs to |
domain_signup_info
This table represents an individual student’s response of a signup field.
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
domain_signup_info_id |
char |
varying(32) |
unique id of the signup info |
|
value |
char |
varying(100) |
the customer value provided for the signup info |
|
domain_membership_id |
char |
varying(32) |
unique id of the domain membership the signup info belongs to |
|
domain_signup_field_id |
char |
varying(32) |
unique id of the signup field the signup info belongs to |
enrollment
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
enrollment_id |
char |
varying(32) |
unique id for the enrollment |
|
enrolled_at |
datetime |
timestamp of when the student first became enrolled in the course |
|
|
expires_at |
datetime |
timestamp of when the course enrollment expires |
|
|
is_active |
bool |
whether or not the student has access to the published course from this enrollment |
|
|
certficate_id |
char |
varying(32) |
unique id of the certificate earned for the course |
|
published_course_id |
char |
varying(32) |
unique id of the published course enrolled in |
|
purchase_id |
char |
varying(32) |
unique id of the purchase this enrollment corresponds to |
|
student_id |
char |
varying(32) |
unique id of the student |
|
student_course_progress_id |
char |
varying(32) |
unique id of the student course progress |
| channel |
char |
varying(25) |
method in which this enrollment was created |
lesson
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
lesson_id |
char |
varying(32) |
unique id of the lesson |
|
is_section |
bool |
indicates whether the lesson is a section/header |
|
|
is_optional |
bool |
when enabled, the lesson will not be required for course completion |
|
|
type |
char |
varying(12) |
the type of the lesson (e.g. ASSET, HTML, QUIZ, VILT, WEB_PACKAGE, IE_EXAM) |
|
title |
char |
varying(500) |
the title of the lesson |
|
order |
int |
the order in which this lesson appears within the course |
|
|
course_id |
char |
varying(32) |
unique id of the course |
|
quiz_id |
char |
varying(32) |
unique id of the quiz (if applicable) |
|
web_package_id |
char |
varying(32) |
unique id of the web package (if applicable) |
offer
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
offer_id |
char |
varying(32) |
unique id of the offer |
|
domain_id |
char |
varying(32) |
unique id of the domain this offer belongs to |
|
published_course_id |
char |
varying(32) |
unique id of the published course this offer belongs to |
|
course_series_id |
char |
varying(32) |
unique id of the course series this offer belongs to |
| published_path_id |
char |
varying(32) |
unique id of the published path this offer belongs to |
|
offer_type |
char |
varying(32) |
what is being offered (i.e. "publised_path", "published_course", "domain", "plan") |
|
price_cents |
int |
listed price in cents |
|
|
currency_code |
char |
varying(32) |
listed currency code |
|
sku |
char |
varying(32) |
listed sku |
|
max_quantity |
int |
listed max_quantity |
|
|
is_active |
bool |
whether or not the offer is active |
promo_code
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
promo_code_id |
char |
varying(32) |
unique id of the promo code |
|
code |
char |
varying(40) |
value of the promo code |
|
use_count |
int |
number of times the promo code has been used |
|
|
max_uses |
int |
maximum number of times the promo code can be used |
|
|
is_active |
bool |
whether or not this promo code is active and can be used |
|
|
promo_code_pool_id |
int |
varying(32) |
unique id of the promo code pool the promo code belongs to |
promo_code_pool
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
promo_code_pool_id |
char |
varying(32) |
unique id of the promo code pool |
|
name |
char |
varying(255) |
name of the promo code pool |
|
bulk_purchase_id |
char |
varying(32) |
unique id of the purchase - this is only present when the code was a result of a bulk purchase |
|
is_active |
bool |
whether or not this promo code pool is active and can be used |
|
|
starts_at |
datetime |
Indicating the start of the promo code pool |
|
|
ends_at |
datetime |
Indicating the end of the promo code pool |
published_course
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
published_course_id |
char |
varying(32) |
unique id of the published course |
|
is_live |
bool |
whether or not the published course is live |
|
|
is_visible |
bool |
whether or not the published course is visible or hidden by default (this may be overridden at the student group level by published_course_student_group_visibility) |
|
|
url |
char |
varying(255) |
the url of the published course |
|
course_id |
char |
varying(32) |
unique id of the course being published |
|
domain_id |
char |
varying(32) |
unique id of the domain the course is published on |
|
visible_on_catalog |
bool |
whether or not the published course is visible on the catalog page (True/False) |
published_course_student_group_visibility
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
published_course_student_group_visibility_id |
char |
varying(32) |
unique id of the published course student group visibility rule |
|
published_course_id |
char |
varying(255) |
unique id of the published course on which this relationship belongs |
|
student_group_id |
char |
varying(32) |
unique id of the student group on which this relationship belongs |
|
is_visible |
bool |
|
whether this override makes the published course visible to the specified student groups (override can either hide courses that are visible by default or make courses that are hidden by default visible) |
published_course_tag
|
Field name |
Format |
Length |
Description |
|
published_course_tag_id |
char |
varying(32) |
unique id of the published course tag |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
published_course_id |
char |
varying(32) |
unique id of the published course this tag is applied to |
|
tag_id |
char |
varying(32) |
unique id of the tag being applied |
purchase
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
purchased_at |
datetime |
timestamp of when the actual purchase occurred |
|
|
purchase_id |
char |
varying(32) |
unique id of the purchase |
|
refunded_at |
datetime |
timestamp of when the purchase was refunded |
|
|
order_id |
char |
varying(20) |
unique id for use in order reports |
|
state |
char |
varying(10) |
status of the purchase (SUCCESS, FAILED, REFUNDED, etc.) |
|
payment_processor |
char |
varying(10) |
name of the payment processor used (Stripe, PayPal, etc.) |
|
payment_processor_account_id |
char |
varying(512) |
unique id of the account in the payment processor's system (Stripe Charge ID, PayPal Payment ID, etc.) |
|
payment_processor_order_id |
char |
varying(128) |
unique id of the payment in the payment processor's system |
|
price_cents |
int |
listed price in cents |
|
|
price_currency |
char |
varying(3) |
listed currency |
|
quantity |
int |
quantity purchased |
|
|
promo_code_id |
char |
varying(32) |
unique id of the promo code if one was used |
|
promo_code_price_cents |
int |
listed price in cents (promo code) |
|
|
promo_code_quantity |
int |
quantity of promo codes used |
|
|
student_id |
char |
varying(32) |
unique id of the student this purchase belongs to |
|
offer_id |
char |
varying(32) |
unique id of the offer that was purchased |
|
offer_sku |
char |
varying(32) |
listed sku (copied from offer at time of purchase) |
|
offer_price_cents |
int |
listed price in cents (copied from offer at time of purchase) |
quiz
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_id |
char |
varying(32) |
unique id of the quiz |
|
name |
char |
varying(100) |
name of the quiz |
|
passing_percentage_correct |
int |
the minimum percentage of questions correct needed to pass the quiz |
|
|
max_attempts |
int |
the maximum number of quiz attempts permitted |
|
|
require_correct_response |
bool |
whether or not incorrect answers to questions are accepted |
|
|
randomize_questions |
bool |
whether or not questions are assigned in a random order |
|
|
limit_question_count |
int |
limits the number of questions assigned per quiz attempt (only respected if randomize_questions is set) |
|
|
randomize_answers |
bool |
whether or not answers are shown in a random order (applies to every question) |
|
|
time_limit_seconds |
int |
the time limit of a quiz in seconds. Blank means the students have unlimited time to complete the quiz |
quiz_answer
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_answer_id |
char |
varying(32) |
unique id of the answer |
|
order |
int |
the order in which this answer appears within the question |
|
|
is_correct |
bool |
whether or not the answer is considered correct for the question |
|
|
text |
char |
varying(1000) |
the value of the answer |
|
quiz_question_id |
char |
varying(32) |
unique id of the quiz this answer belongs to |
quiz_question
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_question_id |
char |
varying(32) |
unique id of the quiz question |
|
type |
char |
varying(20) |
the question type (‘MULTIPE_CHOICE’, ‘MULTIPLE_ANSWER’, ‘FILL_IN_THE_BLANK’, ‘FREEFORM’) |
|
order |
int |
the order in which this question appears within the quiz (only respected if randomize_questions is not set on the quiz) |
|
|
html |
text |
the HTML formatted value of the question |
|
|
quiz_id |
char |
varying(32) |
unique id of the quiz this question belongs to |
|
quiz_question_bank_id |
char |
varying(32) |
unique id of the question bank this question belongs to |
|
requires_manual_grading |
bool |
whether or not this question needs to be manually graded after submitting a response - a quiz with any question in this state will trigger the manual quiz grading workflow |
quiz_question_bank
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_question_bank_id |
char |
varying(32) |
unique id of the quiz question bank |
|
name |
char |
varying(100) |
name of the question bank |
quiz_question_bank_assignment
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_question_bank_assignment_id |
char |
varying(32) |
unique id of the quiz question bank assignment |
|
quiz_question_bank_id |
char |
varying(32) |
unique id of the quiz question bank |
|
quiz_id |
char |
varying(32) |
unique id of the quiz the question bank is assigned to |
|
order |
int |
|
order of the question bank in the quiz |
|
randomize_questions |
bool |
|
should the questions of the question bank be shown in a random order |
|
limit_question_count |
int |
|
limit the number of questions that will be asked from the question bank |
quiz_question_response
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_question_response_id |
char |
varying(32) |
unique id for the quiz question response |
|
order |
int |
the order in which the question appeared for the quiz attempt |
|
|
is_correct |
bool |
nullable value by default, returns whether or not the response was considered correct for the question (True/False), |
|
|
submit_count |
int |
number of times the question was attempted within a single quiz attempt |
|
|
started_at |
datetime |
timestamp of when the question response was started |
|
|
finished_at |
datetime |
timestamp of when the question response was finished |
|
|
grader_feedback |
char |
varying(5000) |
feedback provided by the grader (only provided in the case of manual grading) |
|
quiz_answer_id |
char |
varying(32) |
unique id for the student's answer (does not apply for Multiple Answer questions) |
|
quiz_response_id |
char |
varying(32) |
unique id for the quiz response this belongs to |
|
quiz_question_id |
char |
varying(32) |
unique id for the question this is in response to |
|
response_text |
char |
varying(5000) |
the student's provided free-form answer (only applies for Fill in the Blank & Free Form questions) |
|
randomize_answers |
bool |
whether or not the answer choices were shown in a random order |
quiz_question_response_chosen_answers
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_question_response chosen_answer_id |
char |
varying(32) |
unique id of the quiz question response chosen answer |
|
quiz_answer_id |
char |
varying(32) |
unique id of the chosen answer |
|
quiz_question_response_id |
char |
varying(32) |
unique id of the question response this belongs to |
quiz_response
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
quiz_response_id |
char |
varying(32) |
unique id of the quiz response |
|
completed_at |
datetime |
timestamp of when the response was considered complete and results became available |
|
|
graded_at |
datetime |
timestamp of when the response was manually graded via the dashboard (only applies when a question has requires_manual_grading set) |
|
|
correct_response_count |
char |
varying(12) |
number of questions the student answered correctly |
|
is_passed |
bool |
whether or not the student passed the quiz (True/False) |
|
|
started_at |
datetime |
timestamp of when the student started taking the quiz |
|
|
finished_at |
datetime |
timestamp of when the student finished taking the quiz |
|
|
question_count |
int |
total number of questions in the quiz |
|
|
quiz_id |
char |
varying(32) |
unique id of the quiz |
|
student_lesson_progress_id |
char |
varying(32) |
unique id of the student lesson progress this belongs to |
|
attempted_question_count |
int |
|
The number of questions the student answered (correctly or incorrectly) |
scorm_interaction
|
Field name |
Format |
Length |
Description |
|
scorm_interaction_id |
char |
varying(32) |
unique id of the SCORM interaction |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
student_sco_progress_id |
char |
varying(15) |
unique id of the student SCORM progress |
|
identifier |
char |
varying(255) |
unique identifier for the SCORM interaction within its package |
|
type |
char |
varying(15) |
type of the SCORM interaction (‘true-false’, ‘choice’, ‘fill-in’, ‘matching’, ‘performance’, ‘sequencing’, ‘likert’, ‘numeric’, ‘other’) |
|
weighting |
char |
varying(200) |
a factor which is used to identify the relative importance of one interaction compared to another |
|
order |
int |
the order of the SCORM interaction |
|
|
time |
char |
varying(20) |
a chronological point in a 24-hour clock which identifies when the interaction was completed |
|
response |
char |
varying(16000) |
the actual student response to the SCORM interaction |
|
result |
char |
varying(15) |
how the system judges the described response |
scorm_resource
|
Field name |
Format |
Length |
Description |
|
scorm_resource_id |
char |
varying(32) |
unique id of the the SCORM resource |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
web_package_id |
char |
varying(32) |
unique id of the SCORM web package |
|
identifier |
char |
varying(2000) |
unique identifier for the SCORM resource within its package |
|
type |
char |
varying(32) |
content type (‘sco’, ‘asset’) |
student
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
student_id |
char |
varying(32) |
unique id of the student |
|
first_name |
char |
varying(30) |
first name of the student |
|
last_name |
char |
varying(30) |
last name of the student |
|
|
char |
varying(254) |
email address of the student |
student_course_progress
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
student_course_progress_id |
char |
varying(32) |
unique id of student course progress |
|
latest_activity_at |
datetime |
timestamp of the student’s most recent activity within the course |
|
|
completed_at |
datetime |
timestamp of when the student completed the course |
|
|
score |
int |
score the student received on the course (in cases where course is tied to a quiz score) |
|
|
score_max |
int |
maximum possible score possible for the course |
|
|
credits_earned |
char |
varying(20) |
credits earned by the student from taking the course |
|
success_status |
char |
varying(10) |
student’s course success status (Passed, Failed) |
student_group
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
student_group_id |
char |
varying(32) |
unique id of the student group |
|
name |
char |
varying(100) |
name of the student group |
student_group_membership
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
student_group_membership_id |
char |
varying(32) |
unique id of the student group membership |
|
student_id |
char |
varying(32) |
unique id of the student |
|
student_group_id |
char |
varying(32) |
unique id of the student group this belongs to |
student_lesson_progress
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
student_lesson_progress_id |
char |
varying(32) |
unique id of the student lesson progress |
|
view_count |
int |
number of times student viewed the lesson |
|
|
score_max |
int |
maximum possible score achievable for the lesson (if applicable) |
|
|
success_status |
char |
varying(32) |
student’s lesson success status (Passed, Failed) |
|
lesson_id |
char |
varying(32) |
unique id of the lesson this belongs to |
|
last_viewed_at |
datetime |
timestamp of when the student last viewed the lesson |
|
|
student_course_progress_id |
char |
varying(32) |
unique id of the student course progress this belongs to |
|
completed_at |
datetime |
timestamp of when the student completed the lesson |
|
|
score |
int |
score student achieved for the lesson (if applicable) |
student_lesson_session_time_hourly
|
Field name |
Format |
Length |
Description |
|
student_lesson_session_time_hourly_id |
char |
varying(32) |
unique id of the student lesson session time hourly object |
|
hour_starts_at |
datetime |
timestamp of the hour bucket this session time is recorded for |
|
|
session_time_seconds |
char |
varying(32) |
seconds recorded for this lesson in the hour bucket |
|
course_id |
char |
varying(32) |
unique id of the course |
|
domain_id |
char |
varying(32) |
unique id of the domain |
|
enrollment_id |
char |
varying(32) |
unique id of the course |
|
published_course_id |
char |
varying(32) |
unique id of the published course |
|
student_id |
char |
varying(32) |
unique id of the student |
|
student_course_progress_id |
char |
varying(32) |
unique id of the student course progress |
|
student_lesson_progress_id |
char |
varying(32) |
unique id of the student lesson progress |
student_sco_progress
|
Field name |
Format |
Length |
Description |
|
student_sco_progress_id |
char |
varying(32) |
unique id of the SCORM progress |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
attempted_at |
datetime |
timestamp of when a new SCORM progress was created. It is used to surface user SCO attempts if a SCO lesson is configured to record multiple attempts. |
|
|
student_lesson_progress _id |
char |
varying(32) |
unique id for the student lesson progress this belongs to |
|
scorm_resource_id |
char |
varying(32) |
unique id for the SCORM resource this belongs to |
|
score_raw |
char |
varying(200) |
the most recent score the student achieved for the SCORM module |
|
score_min |
char |
varying(200) |
the minimum score for the SCORM module |
|
score_max |
char |
varying(200) |
the maximum score for the SCORM module |
|
total_time |
int |
total time spent on the SCORM module |
|
|
status |
char |
varying(32) |
status as reported by the SCORM module (‘passed’, ‘completed’, ‘failed’, ‘incomplete’, ‘browsed’, ‘not attempted’) |
tag
|
Field name |
Format |
Length |
Description |
|
tag_id |
char |
varying(32) |
unique id of the tag |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
name |
char |
varying(100) |
name of the tag |
|
slug |
char |
varying(100) |
slug of the tag |
training_credit_code
|
Field name |
Format |
Length |
Description |
|
training_credit_code_id |
char |
varying(32) |
unique id of the training credit code |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
code |
char |
varying(40) |
code value of training credit code |
|
available_to_all_students |
bool |
true if this training credit code can be applied by all students |
|
|
available_to_all_offers |
bool |
true if this training credit code can be applied by all offers |
|
|
credits_used |
int |
max(2147483647) |
total amount of credits used |
|
credits_total |
int |
max(2147483647) |
total amount that training credit code can spend (balance would be credits_total - credits_used) |
|
expiration_date |
datetime |
timestamp of when this code expires |
|
|
expire_content |
bool |
When set to true, content objects purchased with this training credit code will limit student’s access to it (including bulk purchase) |
|
|
tracking_identifier |
char |
varying(256) |
field for external tracking id |
training_credit_code_offer
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
training_credit_code_offer_id |
char |
varying(32) |
unique id of the training_credit_code_offer |
|
credit_code_id |
char |
varying(32) |
unique id of the training credit code |
|
offer_id |
char |
varying(32) |
unique id of the offer |
training_credit_code_student_group
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
training_credit_code_student_group_id |
char |
varying(32) |
unique id of the training_credit_code_student_group |
|
credit_code_id |
char |
varying(32) |
unique id of the training credit code |
|
student_group_id |
char |
varying(32) |
unique id of the student_group |
vilt_account
|
Field name |
Format |
Length |
Description |
|
vilt_account_id |
char |
varying(32) |
unique id of the account |
|
vilt_account_type |
char |
varying(40) |
type of VILT session this account is used for |
vilt_calendar_account
|
Field name |
Format |
Length |
Description |
|
vilt_calendar_account_id |
char |
varying(32) |
unique id of the calendar account |
|
instructor_name |
char |
varying(100) |
name of the instructor |
|
|
char |
varying(100) |
email of the instructor |
|
active |
bool |
whether or not this account is active |
|
|
vilt_account_id |
char |
varying(32) |
unique id of the vilt account this calendar account belongs to |
vilt_location
| Field name | Format | Length | Description |
| created_at | datetime | timestamp of when the object was created | |
| updated_at | datetime | timestamp of when the object was last updated | |
|
vilt_location_id |
char | varying(32) | unique id of the VILT location |
|
name |
char | varying(100) | display name of the VILT location |
|
info_url |
char | varying(1024) | set url for more information regarding the location |
|
is_active |
bool | Whether or not the location is active |
vilt_session
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
vilt_session_id |
char |
varying(32) |
unique id of the VILT session |
|
display_name |
char |
varying(100) |
display name of the VILT session |
|
instructor_name |
char |
varying(100) |
name of the instructor affiliated with the VILT session |
|
lesson_id |
char |
varying(32) |
unique id of the lesson this VILT session belongs to |
|
seats_total |
int |
total number of seats available for the VILT session |
|
|
instructor_external_id |
char |
varying(100) |
id of the instructor for this session from external authentication |
|
vilt_account_id |
char |
varying(32) |
unique id of the vilt_account for this session |
|
cancelled_at |
datetime |
timestamp of when the object was cancelled |
vilt_session_event
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
vilt_session_event_id |
char |
varying(32) |
unique id of the VILT session event |
|
starts_at |
datetime |
timestamp of when the event starts / started |
|
|
ends_at |
datetime |
timestamp of when the event ends / ended |
|
|
location |
char |
varying(100) |
location of the event |
|
timezone |
char |
varying(63) |
timezone for when the event starts / ends |
|
vilt_session_id |
char |
varying(32) |
unique id for the VILT session this event belongs to |
vilt_session_registration
|
Field name |
Format |
Length |
Description |
|
vilt_session_registration_id |
char |
varying(32) |
unique id of the VILT registration |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
vilt_session_id |
char |
varying(32) |
unique id of the VILT session this belongs to |
|
student_lesson_progress_id |
char |
varying(32) |
unique id of the student lesson progress this belongs to |
|
attended |
bool |
whether or not the student attended the VILT session (True/False) |
vilt_session_tag
|
Field name |
Format |
Length |
Description |
|
vilt_session_tag_id |
char |
varying(32) |
unique id of the VILT session tag |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
vilt_session_id |
char |
varying(32) |
unique id of the VILT session this tag is applied to |
|
tag_id |
char |
varying(32) |
unique id of the tag being applied |
web_package
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
web_package_id |
char |
varying(32) |
unique id of the web package |
|
title |
char |
varying(500) |
title of the web package |
|
type |
char |
varying(10) |
identifies the type of web package (HTML/SCORM) |
path
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
path_id |
char |
varying(32) |
unique id of the path |
|
title |
char |
varying(500) |
title of the path |
published_path
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
published_path_id |
char |
varying(32) |
unique id of the published path |
|
domain_id |
char |
varying(32) |
unique id of the domain |
|
path_id |
char |
varying(32) |
unique id of the path |
|
is_visible |
bool |
Whether or not the catalog page is visible or hidden by default |
student_path_progress
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
student_path_progress_id |
char |
varying(32) |
unique id of the student_path_progress |
|
student_id |
char |
varying(32) |
unique id of the student |
|
path_id |
char |
varying(32) |
unique id of the path |
|
completed_at |
datetime |
timestamp when the path was completed |
published_path_enrollment
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
published_path_enrollment_id |
char |
varying(32) |
unique id of the published_path_enrollment |
|
student_id |
char |
varying(32) |
unique id of the student |
|
published_path_id |
char |
varying(32) |
unique id of the published path |
|
student_path_progress_id |
char |
varying(32) |
unique id of the student path progress |
|
purchase_id |
char |
varying(32) |
unique id of the purchase |
|
expires_at |
char |
varying(32) |
timestamp of when the enrollment will expire |
|
enrolled_at |
char |
varying(32) |
timestamp of when the student enrolled in the path |
|
is_active |
bool |
varying(32) |
Whether or not the enrollment is active |
path_item
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
path_item_id |
char |
varying(32) |
unique id of the path_item |
|
path_id |
char |
varying(32) |
unique id of the path |
|
course_id |
char |
varying(32) |
unique id of the course |
|
order |
int |
The order in which this path_item appears |
student_path_item_progress
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
student_path_item_progress_id |
char |
varying(32) |
unique id of the student path item progress |
|
student_path_progress_id |
char |
varying(32) |
unique id of the student path progress |
|
student_course_progress_id |
char |
varying(32) |
unique id of the student course progress |
|
path_item_id |
char |
varying(32) |
unique id of the path_item |
published_path_tags
|
Field name |
Format |
Length |
Description |
|
created_at |
datetime |
timestamp of when the object was created |
|
|
updated_at |
datetime |
timestamp of when the object was last updated |
|
|
published_path_tag_id |
char |
varying(32) |
unique id of the published path tag |
|
published_path_id |
char |
varying(32) |
unique id of the published path this tag is applied to |
|
tag_id |
char |
varying(32) |
unique id of the tag being applied |
Data Connector Schema Diagram
Select the image to enlarge.
<%= heading %>