Linkage between student and Contacts/Persons

[DaveTaylor]

I’m trying to use SQL and other tools to read/report on Students and their contacts. I assume there must be a table that links a student to the Person table in the same way students are linked to siblings in the Relationship table. I just want to pull the Student record and the related Persons

[ItsOnlyDoug]

One of the quickest ways we use is the Contact DAT builder Plugin from the exchange.

https://support.powerschool.com/exchange/view.action?download.id=1261&fromSearchResults=true

You can also use the Data Export Manager and Export all the data from the Contacts tables at once. 

[Scott_Hansen · Accepted solution]

It sounds like you might be looking for the studentcontactassoc table.

It containst a personid to link to the persons table, and a studentdcid field to link to the students table.

[Scott_Hansen]

Your join will look something like this: 

SELECT person.firstname, person.lastname, students.lastfirst
FROM studentcontactassoc
INNER JOIN person on person.id = studentcontactassoc.personid
INNER JOIN students on students.dcid = studentcontactassoc.studentdcid

[katibryce]

Would this fix any issues with parents submitting corrections to their contact information through the enrollment forms and link across kids at different campuses?

[Scott_Hansen]

Any changes to the contacts information should still show.