The following documentation describes the data dictionary and file glossary for the Bridge Data Export file, found in ADMIN > TOOLS > DOWNLOAD ALL DATA. Table descriptions andnd column definitions have been provided for the most commonly requested CSV files from the data export.
Suggestions for cross-referencing data have been included in the table descriptions. For assistance with additional tables not listed in this document, please contact the Bridge Support team.
Note: Some tables shown are only available to Bridge accounts with employee development enabled.
Learn Reports Glossary
- affiliated_sub_account_sources: includes the learning items ID and the sub-accounts in which that item is found
- affiliated_sub_accounts: provides overview information about the sub-accounts that have been created in a root account
- approval_events: includes approval item ID as well as when the event was updated and created
- approvals: includes the ID of the approver, and state of the approval
- attachments: provides the URL of each learning item attachment, and also if that file is visible to learners
- attempts: provides overview information of the attempts for a learning item, as well as the score
- clone_objects: Overview of data points used when an account is cloned
- comments_ratings: provides raw comment data from learning items (does not include free-text)
- Comments: Provides overview information of comments made in Bridge
- content_editor_groups: Overview of editor groups including content ID, type, group ID and timestamps
- content_editors: Overview of when learning items were created and deleted, as well as most recent update timestamp. User ID included.
- content_providers: overview of content ID’s and the affiliated subaccounts, as well as last-sync date
- course_template_versions: All learning item ID’s, the item type, as well as the name and description of the learning item. Includes creation and last-updated date.
- course_templates: all courses and their course IDs; includes date of creation, where the course was originally authored, who authored it, whether or not it was deleted or archived, etc. The table can be joined to the Users, Enrollments, and Domains tables.
- custom_fields: Includes the name of each custom field in an account, date of creation, and date of last update. Each time a custom field is added to an instance within Bridge, a record is created within this table. The table can be joined to the Learner_custom_field_values table to define a name/title to the value found within the corresponding records. The table can also be joined to the Domains table to find the corresponding domain or subaccount.
- devices: Overview of device ID values, as well as the user ID. Includes creation/update/deleted timestamp.
- domain_hierarchies: Overview of the domain tree and associated direct/indirect parents/children/grandchildren etc.
- domains: Overview of the origin and creation of the account
- downloads: Overview of downloads executed within the account account with User ID
- enrollment_profiles: raw data for the enrollment information found in the ‘settings’ section of a learning item
- enrollments_sources: Includes the ID for the enrollment source (group, user, program, or Journey, etc.)
- Enrollments_versions: allows an admin to view the create, update, destroy, and restore events for enrollments as well as the “whodunnit” values for those events.
- enrollments: all enrollments to all learnable types for all users. Each record can be joined to a corresponding user and course using the user_id and course_template_id fields.
- grant_versions: Overview of information for the role version a user has
- grants: Overview of the information associated with a users role
- group_enrollments_versions: overview of when permissions were given to a particular user
- group_enrollments: Overview of enrollments that were created by a group
- group_hierarchies: Overview of the group ‘tree’; includes row_id; ancestor_id; descendant_id; and generations column
- groups: all groups, manual and smart
- hosts: Overview of root host and all sub account hosts
- import_columns: Overview of host account, as well as subdomain’s and their vanity details (if applicable)
- import_objects: Overview of fields that were imported via csv, along with timestamp
- import_profile_versions: Overview of profile information that has been brought into Bridge
- import_profiles: Includes the general file information and url location for the file that was uploaded to update user information
- import_scorm_objects: Overview of raw data from individual SCORM file imports
- import_scorm_profiles: Overview of SCORM upload data (sftp location, etc.)
- Integration_fields: Overview of information used for some integrations. May be blank if not utilised. id; user_id; vendor; feature; contents; created_at; updated_at
- learner_custom_field_values: Overview of UID, custom field ID as well as values. The table can be joined to the corresponding user through the user_id field as well as the corresponding custom field using the custom_field_id field.
- learning_items: Overview of learner assignments to individual items and their status. Each time an enrollment is created for a Course, Live Training, Checkpoint, Program, Survey (built-in surveys not Engage), or LTI item a line is created here. It will give you the specifics about the enrollment in the line.
- library_item_sources: Overview of items available in the library as well as their relevance and enrollment source
- library_items: Overview of raw data for items in the library including course type and title, as well as duration and description
- live_course_enrollment_sources: Overview of Live Training enrollment sources with timestamps
- live_course_enrollments: Overview of individual user enrollments and the associated timestamps. The table can be joined to the Users and Live Courses tables using the user_id and live_course_id fields.
- live_course_group_enrollments: Overview of Live Training group enrollments and registrations
- live_course_session_instructors: Overview of Live Training session ID’s and instructors
- live_course_session_registrations: Overview of Live Training ID’s, UID’s and their respective enrollments. Inclusive of timestamps. The table can be joined to the Users, Live_course_sessions, and Live_course_enrollments tables using the user_id, live_course_session_id, and live_course_enrollment_id fields.
- live_course_session_versions: Overview of Live Training versions, types, and created date
- live_course_sessions: Overview of Live Training data including start/end date, seats available, ID and creation date, subaccount associations, etc. The table can be joined to the live_course table using the live_course_id field.
- live_course_web_conferences: Overview of Live Training provider information, meeting URL, password, and registration link
- live_courses: Includes Live Training title, creation date, session count, etc. The table can be joined to the Users and Domains tables using the user_id and domain_id fields.
- local_saml_service_provider: Overview of SAML service information
- lti_content_item_enrollment_sources: Overview of LTI enrollment sources
- lti_content_item_enrollments: List of individual Learner enrollments triggered via LTI as well as the status of the enrollment.
- lti_content_items: Overview of content details for resources utilising an LTI placement
- lti_placements: Overview of LTI placement information and their respective titles
- lti_tools: Overview of LTI tools and their descriptions as well as XML data and launch URL’s
- memberships: Outlines when users were added to specific groups
- notification_profiles: Overview of notifications that are sent
- oauth_clients: Overview of OAUTH details (if enabled)
- open_sesame_tenants: Overview of OS information in the account (if utilized)
- open_sesame_users: Overview of OS user information - includes Bridge UID and OS learner ID
- program_enrollment_sources: Overview of the create, update, destroy, and restore events for program enrollments and their sources
- program_enrollment_versions: Overview of program enrollments, their versions, the event, and the associated raw data
- program_enrollments: Overview of individual program enrollment data
- program_group_enrollments: Overview of Program enrollments by Group ID
- program_items: Overview of items within a Program
- program_sections: Overview of Programs by title, description, and domain ID.
- program_versions: Overview of creation and update timestamps of Programs
- programs: all programs and their program IDs
- Questions_responses: Numerical responses and scores of learners’ quiz attempts. Does not include free text answers.
- retain_questions: Overview of Retain questions, answers, score, etc.
- retain_quizzes: Overview of Retain enrollments
- rules: smart group logic to place users into groups
- scorm_dispatches: Overview of SCORM uploads
- slide_versions: Overview of updates that were made to individual slides
- slides: Overview of what edits were made to which slides
- survey_distributions: Overview of survey distribution details
- surveys_questions: Overview of survey questions
- surveys_recipient_group_members: Overview of what surveys were sent to which group members
- surveys_recipient_groups: Survey distribution by group details
- surveys_recipients: List of individuals that a survey was distributed to
- survey_responses: Overview of survey responses
- surveys_submissions: Overview of survey submissions
- surveys_surveys: Overview of surveys, their title, creation datem, and distribution count
- Tag_relevance: Tag names and the course ID’s they are associated with, along with relevance
- taggings: Overview of tag ID’s and their placements, context, creation date, and the subaccounts they’re associated with etc.
- tags: Overview of tag names, domain’s they are used in, subaccounts they’re utilized in, etc.
- task_enrollment_sources: (‘tasks’ is a legacy term for current-day Checkpoints); Checkpoint enrollment sources
- task_enrollments: Overview of Checkpoint enrollments
- task_group_enrollments: Overview of Checkpoint enrollments by group
- tasks: Checkpoints (‘tasks’ is a legacy term for current-day Checkpoints)
- temporary_enrollments: Overview of temporary enrollments
- user_course_visit_logs: Overview of a learners visit to courses; includes IP address
- User_course_visits: Overview of a learners visit to a course, as well as the associated IP address
- user_versions: Record of changes made to the users table in the database
- user_visit_logs: Overview of user visits and duration
- users: All users within account. The table includes one user record for each user and can be joined to other tables within the data export, including the various enrollment tables using the id field. The subaccount in which the user was created can be found by joining to the Domains table using the sub_account_id field.
- user_visits: Overview and timestamps of users visits along with the browser used
Perform Reports Glossary
- performanceConversationsAllUsersReport: An all-user export of all performance conversations, including the reviewee, reviewer, the final rating, and the final comment made by both the reviewer and reviewee
- performanceConversationsManagerReport: Numerical report of percentage completed, completed conversations, completed employee reviews, etc.
- cadence_group_member: Overview of group agenda cadence member details; does not include free text entries
- goal: Export of Goal names, timestamps, assignees, goal type, status, and visibility etc.
- cadence_group: Overview of 1:1 cadence information
- to_do: Overview of tasks created in the 1:1 agenda
- goal_task: Overview of individual goals created in the account
- company_goal: Overview of company goals created in an account
- assessment_grade: Overview of assessment grades, comments, and timestamps
- question_topic: Overview of data from the Question Bank
- skill_descriptor: Overview of Skill descriptions
- achievement: Overview of achievements that have been created in an account by learners
- assessor: Overview of the assessor for specific accounts as well as timestamps. The table can be joined to the Users and Domains tables.
- question: Overview of questions found in the Question Bank
- agenda: Overview of agenda creation and status. Does not include free text entries. Each time an agenda is created in Bridge, a record is created within this table. The table can be joined to the Users, Agenda_item, and Domains tables
- skill_job: Overview of Skill data and the accounts they are associated with
- agenda_item: Overview of agenda details, type, completion date etc.; does not include free text entries. The table can be joined to the Course_templates, Agenda, Users, and Domains tables.
- job: Overview of job titles in an account, includes timestamps for creation/updates
- to_do_participant: Overview of tasks from group agendas
- skill: Overview of skills and their descriptions
- assessment: Overview of assessment creation, datestamp, deadline, etc. : Overview of assessment creation, datestamp, deadline, etc.
Files
The following files are covered in this article:
Agenda
|
Table Description: Each time an agenda is created in Bridge, a record is created within this table. The table can be joined to the Users, Agenda_item, and Domains tables.
| |
Column Name |
Description |
account_id |
The ID of the account the 1on1 agenda is located in |
| sub_account_id | The ID of the subaccount the 1on1 agenda is located in. Can be joined to the Domains table to define the subaccount name |
| id | The ID of the individual 1on1 agenda form |
| manager_id | The unique Bridge ID of the manager involved in the 1on1 agenda |
| employee_id | The unique Bridge ID of the employee involved in the 1on1 agenda. Can be joined to the Users table to define the employee’s name |
| created_at | The date and time the 1on1 agenda was created |
| updated_at | The date and time the 1on1 agenda was last updated |
| completed_at | If complete, the date and time the 1on1 agenda was completed |
| state | Which state the 1on1 agenda is currently in (Active, Completed, Dismissed, Requested, Withdrawn) |
| agenda_type | Indicates 1on1 agenda type. Check-in (Check_in), Peer, or Performance Conversation (Perf_Conv) |
Agenda_item
|
Table Description: Each time an agenda item is created in Bridge, a record is created within this table. The table can be joined to the Course_templates, Agenda, Users, and Domains tables.
| |
Column Name |
Description |
account_id |
The ID of the account the 1on1 agenda item is located in |
sub_account_id |
The ID of the subaccount the 1on1 agenda item is located in. Can be joined to the Domains table to define the subaccount name |
id |
The ID of the individual 1on1 agenda item |
agenda_id |
The ID of the individual 1on1 agenda form |
author_id |
The unique Bridge ID of the author of the agenda item |
assignee_id |
The unique Bridge ID of the person the agenda item is assigned to |
item_text |
The text entered in Bridge as the agenda item |
item_type |
Indicates agenda item type (Achievement, Achievements Snapshot, Action Item, Assessment, Goal, Goals Snapshot, Learning, Note, To Do, To Do Snapshot) |
item_order |
Indicates the order in which agenda items are listed in the user interface |
visibility |
Indicates the visibility of the agenda item |
due_at |
The due date and time of the agenda item |
created_at |
The creation date and time of the agenda item |
updated_at |
The date and time the agenda item was last updated |
completed_at |
The date and time the agenda item was marked complete, if applicable |
deleted_at |
The date and time the agenda item was deleted, if applicable |
| learning_course_template_id | The ID number of a Bridge course listed as an agenda item, if applicable |
| parent_item_id | The ID number of the hierarchical parent of an agenda item, if applicable |
| thread_id | The ID number that connects the agenda item across multiple agendas, if applicable |
| archived_at | The date and time the agenda item was archived, if applicable |
Assessor
|
Table Description: Each time an assessment is created within Bridge, a record is created within this table. The table can be joined to the Users and Domains tables.
| |
Column Name |
Description |
account_id |
The ID of the account the assessment is located in |
| sub_account_id | The ID of the subaccount the assessment is located in, if applicable |
| id | The ID of the assessment record |
| assessment_id | The ID of the assessment that relates an assessor with the assessment |
| employee_id | The unique Bridge ID of the employee completing the assessment. Can be joined to the Users table to define the employee’s name |
| completed_at | The date and time the assessment was marked complete, if applicable |
Custom_fields
|
Table Description: Each time a custom field is added to an instance within Bridge, a record is created within this table. The table can be joined to the Learner_custom_field_values table to define a name/title to the value found within the corresponding records. The table can also be joined to the Domains table to find the corresponding domain or subaccount.
| |
Column Name |
Description |
id |
The ID number of the mapped custom field |
name |
The name of the custom field |
created_at |
When the custom field was first added using a CSV file upload |
updated_at |
When the custom field was last updated |
deleted_at |
When the custom field was deleted |
domain_id |
The account or subaccount ID number where the custom field was created |
Course_templates
|
Table Description: Each time a course is created within Bridge, a record is created within this table. The table can be joined to the Users, Enrollments, and Domains tables.
| |
Column Name |
Description |
id |
The ID number of the course |
title |
The title of the course |
estimated_time |
The estimated completion time of the course |
user_id |
The ID of the user who created the course |
created_at |
When the course was created |
updated_at |
When the course was last updated |
passing_threshold |
The required minimum passing score |
published_at |
When the course was published |
has_unpublished_changes |
If the course has unpublished changes (Yes: t or No: f) |
has_certificate |
If the course has certificates enabled for users (Yes: t or No: f) |
external_id |
External ID number of uploaded and shared courses. The originating Bridge account’s name will be used as a prefix. |
draft_external_id |
External ID number of uploaded and shared courses that have not been published. The originating Bridge account’s name will be used as a prefix. |
external_status |
The status of uploaded courses (pending, complete, attached, etc.) |
course_type |
Indicates course type: Bridge native (0), SCORM (1), Lynda (2), or OpenSesame (3), LinkedIn Learning (4) |
domain_id |
The account or subaccount ID where the course was created |
deleted_at |
The date of course deletion, if applicable |
attachments_count |
The number of attachments added to the course, including media added to course slides |
sub_account_id |
The account or subaccount ID where the course is held |
open_book |
If the course has the Open Book option enabled for users (Yes: t or No: f) |
description |
The course description |
third_party_course_id |
The course ID provided by the third party source |
quizzes_count |
The number of quiz questions in the course |
external_status_message |
Information provided for failed course upload, if applicable |
manual_estimated_time |
If the estimated completion time of the course has been manually set by the author (Yes: t or No: f) |
Enrollments
|
Table Description: Every time a user is enrolled in a course, an enrollment record is created within this table. Each record can be joined to a corresponding user and course using the user_id and course_template_id fields.
| |
Column Name |
Description |
id |
Unique enrollment id |
user_id |
User id for the user that the enrollment belongs to |
state |
Which state the enrollment is currently in (Created, Active, Complete) |
created_at |
The date on which the enrollment was created |
updated_at |
The date on which the enrollment has been updated |
completed_at |
The date on which the enrollment was completed |
score |
The score the user received upon completion of the course |
end_at |
Due date of the enrollment |
course_template_id |
The course in which the user enrolled |
attempts_count |
How many attempts have been completed by the user |
required |
If the course is a required course (Yes: t or No: f) |
external_id |
External ID number of uploaded and shared courses. The originating Bridge account’s name will be used as a prefix. |
deleted_at |
The date of enrollment deletion, if applicable |
sources_count |
How many methods have been used to enroll a user in an item (groups, learning library, program, etc.) |
config |
Enrollment configuration relating to the Office 365 integration (calendar) and Retain participation set using API (retain_opt_out). |
expires_at |
When the user’s enrollment completion will expire |
inactive |
If the course enrollment is inactive (Yes: t) |
renew_by |
The date the previous enrollment will expire |
Goal_task
|
Table Description: Each time a task is created for a goal within Bridge, a record is created within this table.
| |
Column Name |
Description |
account_id |
The ID of the account the goal task is located in |
| sub_account_id | The ID of the subaccount the goal task is located in |
| id | The ID of the individual task record |
| goal_id | The ID of the goal that the task is linked to |
| name | The text entered as the task name |
| created_at | The date and time the task was created |
| updated_at | The date and time the task was last updated |
| completed | Indicates task completion status (True, False) |
| due_at | The date and time of the task due date, if applicable |
| completed_at | The date and time the task was completed, if applicable |
| deleted_at | The date and time the task was deleted, if applicable |
Learner_custom_field_values
|
Table Description: Each time a value is added to a user’s custom field, a record is created within this table. The table can be joined to the corresponding user through the user_id field as well as the corresponding custom field using the custom_field_id field.
| |
Column Name |
Description |
user_id |
User’s ID that the custom field value joins to |
custom_field_id |
ID of the custom field which the value belongs to |
value |
The value residing within the corresponding custom field |
deleted_at |
The date of custom field value deletion, if applicable |
Live_course_enrollments
|
Table Description: Each time a user is enrolled in a live training, a record is created within this table. The table can be joined to the Users and Live Courses tables using the user_id and live_course_id fields.
| |
Column Name |
Description |
id |
Unique identifier for the live training enrollment. |
user_id |
ID of the enrolled user |
live_course_id |
ID of the live training the user has enrolled in |
created_at |
The date when the user was enrolled in the specified live training |
updated_at |
The last date an update was made to the enrollment |
state |
0 = Invited; 1 = Registered; 2 = Attended |
deleted_at |
The date of enrollment deletion, if applicable |
sources_count |
How many methods have been used to enroll a user in the live training (groups, learning library, program, etc.) |
expires_at |
The date which the enrollment will expire |
inactive |
If the live training enrollment is inactive (Yes: t) |
renew_by |
The date the previous enrollment will expire |
Live_courses
|
Table Description: Each time a live training is created within Bridge, a record is created within this table. The table can be joined to the Users and Domains tables using the user_id and domain_id fields.
| |
Column Name |
Description |
id |
The unique identifier of the live training |
title |
The title assigned to the course by the live training creator |
description |
The description assigned to the live training by the creator |
created_at |
The date which the live training was created |
updated_at |
The last date which an update was made to the live training |
user_id |
The user ID of the user who created the live training |
domain_id |
The domain to which the live training belongs |
deleted_at |
The date of live training deletion, if applicable |
sessions_count |
The number of sessions in the live training |
enrollments_count |
The number of enrollments within the live training |
attachments_count |
The number of attachments within the live training |
sub_account_id |
The id of the subaccount to which the live training belongs. Can be joined to the Domains table to define the subaccount name |
external_course_id |
External ID number of a shared live training. The originating Bridge account’s name will be used as a prefix. |
Live_course_sessions
|
Table Description: Each time a new session is created for a live training, a new record is created within this table. The table can be joined to the live_course table using the live_course_id field.
| |
Column Name |
Description |
id |
The unique identifier assigned to the live training session |
start_at |
The planned start date/time of the session |
end_at |
The planned end date/time of the session |
location |
Where the session will be located |
seats |
The max amount of users that can register for the session |
live_course_id |
The ID of the live training in which the session was created |
created_at |
The date which the session was created |
| parent_id | The ID of the first session in a multi-part session |
updated_at |
The date when the last update was made to the session |
registered_count |
The number of users registered for the session |
concluded_at |
The date/time when the session actually ended |
deleted_at |
The date of session deletion, if applicable |
notes |
Any notes added to the session by the session creator |
domain_id |
The ID of the domain to which the session belongs |
sub_account_id |
The ID of the subaccount to which the session belongs |
present_count |
The number of attendees who have been marked as present |
Live_course_session_registrations
|
Table Description: Each time a user is registered for a session within a live training, a new record is created within this table. The table can be joined to the Users, Live_course_sessions, and Live_course_enrollments tables using the user_id, live_course_session_id, and live_course_enrollment_id fields.
| |
Column Name |
Description |
id |
The unique identifier assigned to the session registration |
live_course_session_id |
The ID of the session the user has registered for |
user_id |
The ID of the user who is registered |
created_at |
The date/time when the registration was created |
updated_at |
The last date/time the registration was updated |
live_course_enrollment_id |
The ID of the live training enrollment the registration is tied to |
deleted_at |
The date of registration deletion, if applicable |
config |
Enrollment configuration relating to the Office 365 integration (calendar) |
marked_complete_at |
The date the registration was completed |
Users
|
Table Description: Each time a user is created within Bridge, a record is created within this table. The table includes one user record for each user and can be joined to other tables within the data export, including the various enrollment tables using the id field. The subaccount in which the user was created can be found by joining to the Domains table using the sub_account_id field.
| |
Column Name |
Description |
id |
User’s unique Bridge ID |
User’s email |
|
uid |
User’s unique ID as defined by institution |
created_at |
When the user was created |
updated_at |
The last time the user and any corresponding info was updated |
avatar_url |
Location of the user’s avatar used within Bridge |
first_name |
User’s first name |
last_name |
User’s last name |
external_id |
User ID defined by the institution |
domain_id |
Foreign key used to join Users.csv to Domains.csv |
deleted_at |
If a user is deleted, the date of deletion will appear here |
tac_accepted_at |
When the user accepted the Terms and Conditions of using Bridge |
tagline |
User’s tagline |
locale |
User’s locale parameters (i.e. language, region, etc.) |
unsubscribed |
If a user has unsubscribed from Bridge, a ‘t’ (true) will appear here |
welcomed_at |
Date when the user was sent a welcome email from Bridge |
logged_in_at |
The date the user last logged in |
config |
Configuration relating to the Office 365 integration (calendar), accessibility (a11y), Retain tutorial walkthrough (bridge_retain_onboarding_pending), and timezone. |
full_name |
User’s full name |
sortable_name |
User’s name. Formatted as Last Name, First Name |
uuid |
Universally Unique Identifier |
sub_account_id |
The ID of the subaccount the user belongs to. Joins to Domains.csv |
hris_id |
User’s unique identifier used within the institution’s HRIS |
support_user |
Users identified as being from Instructure support |
hire_date |
Date user was hired (as defined by the institution) |
hidden |
Users identified as being hidden within Bridge |