I am attempting to recreate the "Student Submissions" report using tables from the Canvas Data Portal. I have been able to find everything and put it together just fine except SIS source IDs for students. There is a field in the enrollment_dim table called sis_source_id, but it has been deprecated and I haven't been able to find the replacement. I've tried to use the pseudonym_dim table, but not all records there have SIS IDs. The API calls for enrollments can be made to return them. When I look at individual student accounts in Canvas they all have the ID numbers under the login information, and the "Student Submissions" report itself has them all, but I can't find where it gets them from.
Any suggestions where I should be looking?