How to see which students are under which teacher?

[JiaqiCheng]

Hi, Canvas team,

We have encountered a problem. We know that in the "enrollment_dim" table, there is "type" column to differentiate "StudentEnrollment", "TaEnrollment", and "course_id" to see which course the students and teachers are enrolled, as well as "user_id" to map specifically teachers and students. But how can we know which students are under which teacher specifically?

Thanks. 

[mzimmerman · Accepted solution]

Hi @JiaqiCheng 

There is not a single place where this specific association is recorded.  You will need to look at the course_id for the enrollment, then look at all the other enrollments for that course_id and see which one(s) have a teacher role.

If there are multiple teachers associated with a course, and multiple sections within the course, you might see if specific teachers are associated with the same section that the student is in.

If that is not that case, can you clarify what you mean by "which students are under which teacher" as it relates to Canvas?