PowerSchool SIS Roster Data

[Aman1211]

From which table should i fetch data from powerschool SIS if i want the unique courses with it's grade
and teachers and students associated with that courses?

[lthorne]

@Aman1211 The CC table will give you current and previous enrollments, with teacher ID. The Stored Grades table will give you historical grades.  The PGFinalGrades table will give you current grades.  

There are two wonderful Enterprise Reports available that provide this information for you.  The Student Grades pulls historical grades and related information.  The Current Grades - New report pulls current grades and related information.  Enterprise Reports are available under System Reports and are role-based access.  

[Aman1211]

Hey @lthorne 
Thanks for the reply,
My question was about the grade_level associated with the course
so where i can found that?
for eg: Course 1A has grade_level - 1.

[lthorne]

@Aman1211 On the Live side, the Sections (3) table will show you the grade level associated to the section.  On the PowerScheduler side, the ScheduleSections (112) table will show you the associated grade level.  

[Aman1211]

Thanks @lthorne.
And one more thing can you please also tell me that Is there any flag which tells that the course is an active course or an inactive course?

[ParitoshT]

Hi @Aman1211,

You can check the active/inactive courses in the Course list under Courses and use the filter to narrow the list of courses by course status. These statuses are Active, Inactive, and Unavailable. 

Please let me know if this helps you.

ParitoshT

Community Moderator