Skip to main content
Continuing Online Operations
Loyola is continuing online operations while we prepare for reopening safely in the fall. Coronavirus resources

Selected Blackboard DDA Queries: Selected Tables

Selected Blackboard Data Direct Access (DDA) Queries.

Most Commonly Used Tables

Most Commonly Used Tables

activity_accumulator Logs user access to course contents
attempt Each row identifies one submission by one student against one gradable item (a row in the gradebook_grade table)
auth_provider_log Logs each user login, logout, and session expiration
course_course Relates parent and child courses in "merged enrollments."
course_main The top-level definition of each course.
course_term Relates each course to one or more terms (semesters).
course_users Lists users (students, instructors, and other course-level roles) enrolled in each course
domain Lists the names of domains (named subsets of courses, users, and other objects), if any are used. The domain named 'default' refers to the entire database. Hierarchy nodes, created through the GUI or through the SIS interface, are also stored in the domain table.
domain_admins Lists the administrators and their system roles for each domain. The Secondary System Roles of users who have them are listed here, and refer to the 'default' domain (entire database).
domain_user_coll Users included in a domain or hierarchy node are listed in the domain_user_coll table. 
gradebook_grade Describes the grades individual students received for specific gradable items.
gradebook_grade_calc Holds the values of calculated columns within the grade book of a course.
gradebook_main Describes the grade book for each course. Each row describes a gradable item, and corresponds to a column the grade center display of the related course.
gradebook_settings Settings that apply to the whole grade book within a given course. 
gradebook_type Lists the categories of gradable items in a given course.
term Describes each term (semester) than can be associated with courses.
users Describes each user account.