Data Connector: Data Dictionary

  • Updated

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

catalog_page_student_group_visibility

certificate

course

course_series

course_series_published_courses

domain

domain_access_code

domain_access_code_pool

domain_membership

domain_signup_field

domain_signup_info

enrollment

lesson

offer

promo_code

promo_code_pool

published_course

published_course_student_group_visibility

published_course_tag

purchase

quiz

quiz_answer

quiz_question

quiz_question_bank

quiz_question_bank_assignment

quiz_question_response

quiz_question_response_chosen_answers

quiz_response

scorm_interaction

scorm_resource

student

student_course_progress

student_group

student_group_membership

student_lesson_progress

student_lesson_session_time_hourly

student_sco_progress

tag

training_credit_code

training_credit_code_offer

training_credit_code_student_group

vilt_account

vilt_calendar_account

vilt_location 

vilt_session

vilt_session_event

vilt_session_registration

vilt_session_tag

web_package

path

published_path

student_path_progress

published_path_enrollment

path_item

student_path_item_progress

published_path_tags

 

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

Back to tables

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

Back to tables

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

Back to tables

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.

Back to tables

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)

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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)

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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)

Back to tables

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)

Back to tables

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

Back to tables

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)

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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)

Back to tables

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

Back to tables

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’)

Back to tables

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

email

char

varying(254)

email address of the student

Back to tables

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)

Back to tables

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

Back to tables

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

Back to tables

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)

Back to tables

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

Back to tables

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’)

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

email

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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)

Back to tables

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

Back to tables

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)

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

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

Back to tables

Data Connector Schema Diagram

data_connector_schema-12-8-2021.png

Select the image to enlarge. 

Was this article helpful?

0 out of 0 found this helpful