cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Member

User Data

Morning All,

I am trying to determine the role associated with a user in the User_dim table. I haven't been able to find an entity relationship diagram for Canvas Data so any help much appreciated in terms of tables and fields I need.

0 Kudos
1 Reply
Highlighted
Community Advocate
Community Advocate

Hi nick.yee@bcito.org.nz,

CD has a role_dim set Canvas Data Portal, but it doesn't contain account roles, only course roles. Account roles aren't available in CD. So the only roles associated with users in CD are found in enrollment_dim.type where they link the user, course, and role. Here's a related discussion where james@richland.edu does some lifting and sharing to fill the gap.

https://community.canvaslms.com/message/63016-re-is-there-a-quick-way-to-get-the-user-list-for-each-... 

0 Kudos
Top Kudoed Authors
Labels