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.
Doug Skinner
District Instructional Data Officer
Gateway Regional School District
![]() | ![]() |
Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the 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.
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