[ARCHIVED] Is any SIS ID of user in Canvas Data Portal?

[ctcck]

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.

[bneporadny · Accepted solution]

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.