GradeFormulaSet (ver10.0.0)

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.

Column Name

Initial Version

Data Type

Description

Description

10.0.0

Varchar2(4000)

The description of the formula set.

GradeFormulaSetID

10.0.0

Number(16,0)

Primary key. Unique sequential number generated by PowerSchool. Required. Indexed.

IsCourseGradeCalculated

10.0.0

Number(1,0)

Indicates if the course grade is calculated. Valid values: 0=Course Grade Not Calculated, 1=Course Grade Calculated. Defaults to 1. Required.

IsReportTermSetupSame

10.0.0

Number(1,0)

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.

Name

10.0.0

Varchar2(30)

The unique name of the formula set. Required.

SectionsDCID

10.0.0

Number(16,0)

Foreign key. Internal number for the associated sections.DCID record. Indexed.

Type21.11.0Varchar2(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.

WhenCreated

10.0.0

Timestamp(6)

Date and time the record was created. Defaults to system date. Required.

WhenModified

10.0.0

Timestamp(6)

Date and time the record was modified. Defaults to system date. Required.

WhoCreated

10.0.0

Varchar2(100)

The user login that created the record. Defaults to a database user. Required.

WhoModified

10.0.0

Varchar2(100)

The user login that modified the record. Defaults to a database user. Required.

YearID

10.0.0

Number(10,0)

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.

Copyright © 2021 PowerSchool Group LLC