Student email address - table/view location?

[Kyle Schneider]

Okay PSUGers, I've spent an afternoon trying to figure out what table or view contains the student email address.  Does anyone know?

--
Kyle Schneider
Student Support Specialist
Southwest Region School District
PO Box 90
Dillingham, AK 99576
Phone: 907 842 8221
Fax: 907 842 5428

Skype: call or chat
kschn...@swrsd.org

[jordan....@g.kpbsd.org]

I don't know how it is setup by default, but for us we store it as a custom field on our student table as "kp_student_email" so this simplified query would pull that info for us:

select student_number, lastfirst, ps_customfields.getstudentscf(id, 'kp_student_email') as email from students

I doubt you use the same name for your student email custom field :P , so you should be able to look at kid that has a student email in DDA to find out the field name used for his email.  Worst case scenario, you can use this query to find some possible names for the custom field you're using:

 select name from fieldstable where lower(name) like '%email%'

Then try running my original query a few times while replacing "kp_student_email" with some of your best guesses from the second query.

-Jordan

[Kyle Schneider]

We're not using a custom field and its not an option for us as it would remove teachers' ability to email students from inside their gradebook and it would break compatibility with a third party system.

--
Kyle Schneider
Student Support Specialist
Southwest Region School District
PO Box 90
Dillingham, AK 99576
Phone: 907 842 8221
Fax: 907 842 5428

Skype: call or chat
kschn...@swrsd.org

--
You received this message because you are subscribed to the Google Groups "AK PSUG" group.
To post to this group, send email to ak-...@googlegroups.com.
Visit this group at http://groups.google.com/group/ak-psug.

[Wyatt, Jay]

Good Afternoon, Mr Andle has some things that will be useful posted on PowerSource under PowerSchool Forums> Using PowerSchool>Cannot access Student email in 7.0.

Hope you find it helpful (we do not keep Student emails at all).

Thanks and take care,

Jay

Jay Wyatt

JSD/OIS

907 957-3032

[Kyle Schneider]

I found a query!

select 

  s.lastfirst, 

  psc.email from PSM_STudentcontact psc 

  

inner join psm_studentcontacttype psct on psc.studentcontacttypeid= psct.id and psct.name='Self' 

inner join sync_studentmap ssm on psc.studentid = ssm.studentid 

inner join students s on ssm.studentsdcid = s.dcid 

--
Kyle Schneider
Student Support Specialist
Southwest Region School District
PO Box 90
Dillingham, AK 99576
Phone: 907 842 8221
Fax: 907 842 5428

Skype: call or chat
kschn...@swrsd.org