cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ctcck
Community Member

Is any SIS ID of user in Canvas Data Portal?

Jump to solution

I have just reviewed the database schema of Canvas Data Portal.

For some reasons, I would like to obtain sis_id as well as email of user (e.g. in user_dim table). Anyone has idea about it?

Please advance.

1 Solution

Accepted Solutions
bneporadny
Community Champion

Hi Kenneth,

The SIS ID you provide when creating the user account within Canvas can be found in the #pseudonym_dim table. Column is call #sis_user_id

Hope this helps.

View solution in original post

1 Reply
bneporadny
Community Champion

Hi Kenneth,

The SIS ID you provide when creating the user account within Canvas can be found in the #pseudonym_dim table. Column is call #sis_user_id

Hope this helps.