Help

Fields for Export

JohnF5
Journeyman

Fields for Export

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?

4 Replies
ItsOnlyDoug
PowerSchool Mentor
PowerSchool Mentor

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



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.


littleb
Hobbyist

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.

JohnF5
Journeyman

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

littleb
Hobbyist

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;)