topic Re: Fields for Export in Community Forum

Fields for Export

JohnF5 — Tue, 17 May 2022 19:57:05 GMT

I'm trying to find some fields built into Power School to identify a Student as a Student and a Teacher as a Teacher. What table and field should I be looking for?

Re: Fields for Export

ItsOnlyDoug — Wed, 18 May 2022 14:52:27 GMT

Students and Teachers live in 2 different tables in PowerSchool so I don't think there is a specific field delineating the two.

Re: Fields for Export

littleb — Wed, 22 May 2024 18:40:13 GMT

Did you ever get an answer to this? I am working on setting up an export to a third party and I need to find a field that distinguishes students as a student and teachers/employees as staff.

Re: Fields for Export

JohnF5 — Thu, 23 May 2024 19:46:49 GMT

I don't believe so. I would think the Data Export Manager might work. You can export from the different tables.

Re: Fields for Export

littleb — Thu, 23 May 2024 20:25:41 GMT

Thank you for letting me know. I actually got an answer in a different discussion regarding this. Here are the fields to put in with you want to distinguish a student as a student and an employee as staff...

~(decode;1;1;Student;)

~(decode;1;1;Staff;)