topic Re: Linkage between student and Contacts/Persons in Community Forum

Linkage between student and Contacts/Persons

DaveTaylor — Thu, 13 Feb 2025 17:25:06 GMT

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

Re: Linkage between student and Contacts/Persons

ItsOnlyDoug — Tue, 18 Feb 2025 22:12:59 GMT

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.

Re: Linkage between student and Contacts/Persons

Scott_Hansen — Wed, 12 Mar 2025 13:43:18 GMT

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.

Re: Linkage between student and Contacts/Persons

Scott_Hansen — Wed, 12 Mar 2025 13:46:57 GMT

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

Re: Linkage between student and Contacts/Persons

katibryce — Wed, 02 Jul 2025 17:26:26 GMT

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

Re: Linkage between student and Contacts/Persons

Scott_Hansen — Wed, 02 Jul 2025 18:49:45 GMT

Any changes to the contacts information should still show.