Skip to main content
Skip table of contents

S_BC_SGR_TRAX_X (ver 14.1.4)

This table is an extension of the StoredGrades table, which maintains student historical grades.

Column Name


Data Type




Number (10,0)

Primary key that relates the extended table to the [StoredGrades] table.



Varchar2 (1)

Used to indicate if the course type is standard (blank), (C)hallenge for credit, or (E)quivalent. 



Varchar2 (10)

Used to indicate the grade level of the course for imported historic course grades where the course does not exist in PowerSchool.

TRAXCourseNumber14.9.0Varchar2 (5)Ministry course number or local course number that will be used on the TRAX extract for imported and manually entered stored grade records if no relationship exists to a course and section in PowerSchool.
ExcludeFromTRAX14.9.0Varchar2 (1)Indicates this mark/grade/StoredGrade record will be excluded from the TRAX extract if set to 1. This will exclude the course from the TRAX extract if this StoredGrade record is the only data present for the course.
Provincial_Exam_Ind14.9.0Varchar2 (1)Indicates the course this mark/grade/StoredGrade record is for is a provincially examinable course if set to 1.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.