Hi all,
Can anyone help me identifying the table where student email is getting stored in PowerSchool. I do not find it in students table and also when I try to export student data using "List students" I dont see a student email field. Any suggestions?
The student email field is not in the Students table so you won't find it in the field list. However, in PS 22.9.0.0 you can now use a PowerQuery DAT to export student email:
~(*powerquery;query=com.powerschool.core.dats.students.student_email)
For more information on other PQ DATs added in version 22.9 check out the release notes.