[ARCHIVED] Is any SIS ID of user in Canvas Data Portal?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2019
08:50 PM
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.
Solved! Go to Solution.
1 Solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2019
06:18 AM
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.
This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.