State Course Code Data Pull


State Course Code Data Pull

Does anyone know how the table/field code I can use to pull over the State Course Code in my DDE Data Export?  I am pulling grades out of the StoredGrades table for a specific date time, but I would like to pull over the State Course Code that ties to the Course Number in StoredGrades.

1 Reply
Community Support Expert
Community Support Expert

Hi @toniquack,


The State Course code can be found in this Define District Courses for Washington as field [S_WA_CRS_X]StateCourseCd.


This historical grades table is not connected to the course table in DDE. You would not be able to just reference the above field and get the data. You would need to create a series of exports and combine the results.

Did your issue get resolved? Please remember to give Kudos and/or select Accept As Solution on helpful posts to thank the author and help others find the solution.

PowerSchool Community Support