Fields for Export

[JohnF5]

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?

[ItsOnlyDoug]

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

[littleb]

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]

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

[littleb]

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