Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JohnF5

Fields for Export

JohnF5
Journeyman
‎05-17-2022 12:57 PM
‎05-17-2022 12:57 PM

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?

0 Kudos
4 Replies
ItsOnlyDoug
PowerSchool Mentor
PowerSchool Mentor
‎05-18-2022 07:52 AM
‎05-18-2022 07:52 AM

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.


0 Kudos
littleb
Hobbyist
‎05-22-2024 11:40 AM
‎05-22-2024 11:40 AM

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.

0 Kudos
JohnF5
Journeyman
‎05-23-2024 12:46 PM
In response to littleb
‎05-23-2024 12:46 PM

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

0 Kudos
littleb
Hobbyist
‎05-23-2024 01:25 PM
In response to JohnF5
‎05-23-2024 01:25 PM

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

0 Kudos
Related Discussions & Articles