A Grade Formula Set is a container that includes a grouping of related terms to be configured for Grading Formulas. The Terms and Reporting Terms for a set are found in the GradeCalculationType table.
The description of the formula set.
Primary key. Unique sequential number generated by PowerSchool. Required. Indexed.
Indicates if the course grade is calculated. Valid values: 0=Course Grade Not Calculated, 1=Course Grade Calculated. Defaults to 1. Required.
Indicates whether this setup is the same for all reporting terms. Valid values: 0=Reporting Term Setup is NOT the Same, 1=Reporting Term Setup Same. Defaults to 0. Required.
The unique name of the formula set. Required.
Foreign key. Internal number for the associated sections.DCID record. Indexed.
|Type||21.11.0||Varchar2(10)||The Formula Set Type. Valid values: 'School' = The formula set is at the school level, 'Course' = The formula set is at the course level. Defaults to 'School". Required.|
Date and time the record was created. Defaults to system date. Required.
Date and time the record was modified. Defaults to system date. Required.
The user login that created the record. Defaults to a database user. Required.
The user login that modified the record. Defaults to a database user. Required.
A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Required. Indexed.