Skip to main content
Skip table of contents

GradeSchoolConfig (ver10.0.0)

This table contains configuration settings at the school level that can affect how grades are calculated and who may edit those settings. In some cases, these settings may be overridden by course-specific settings.

Column Name

Initial Version

Data Type

Description

AreGradesLocked12.0.0Number(1,0)If the value is NULL, the reporting term is automatically locked based on the offsets in the GradeSchoolConfig table. If the value is 1 the Reporting Term is explicitly locked and no changes will be allowed that affect grade calculations. If the value is 0 the reporting term is explicitly unlocked, changes affecting grade calculations are allowed, and the auto-lock is suspended until the value is changed.

CalcMetricSchoolFromStd

10.0.0

Varchar2(30)

Indicates the calculation metric used to calculate standards for the school. Valid values: Mean, Median, Mode, Weighted_Mean, Specific_Weighting. Defaults to Mean. Required.

CalculationMetric

10.0.0

Varchar2(30)

Indicates how higher-level standards are calculated. Valid values: Power, Most_Recent, Mean, Weighted_Mean, Median, Mode, Highest. Defaults to Most_Recent. Required.

DefaultDecimalCount

10.0.0

Number(1,0)

Indicates the default decimal count at the course level. Valid values: 0,1,2,3. Defaults to 0. Required.

DefaultRoundingRule

10.0.0

Varchar2(30)

Indicates the default rounding rule at the course level. Valid values: Round, Truncate. Defaults to Round. Required.

GradeCalcPreferenceOrder

10.0.0

Varchar2(30)

Indicates the order of precedence for calculating the grade. For example, the course settings override the school setting. Valid values: School, Course. Defaults to School. Required.

GradeSchoolConfigID

10.0.0

Number(16,0)

Primary key. Unique sequential number generated by the application. Required. Indexed.

HigherLevelStndMetric

10.0.0

Varchar2(30)

Defines the metric to be used for the higher-level standard. Valid values: Highest, Mean, Median, Mode, Specific_Weighting, Specific_Sum. Defaults to Mean. Required.

IsCalcFormulaEditable

10.0.0

Number(1,0)

Indicates if the teacher can edit the calculation formula. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsCalcMetricEditable

10.0.0

Number(1,0)

Indicates if the teacher can edit the calculation metric. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsCalcMetricSchoolEdit

10.0.0

Number(1,0)

Indicates if the user at the school can edit the calculation metric. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsCalcPrecisionEditable

10.0.0

Number(1,0)

Indicates if the teacher can edit the calculation precision (number of decimal places). Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsDropScoreEditable

10.0.0

Number(1,0)

Indicates if the teacher can edit the drop score. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsHighStandardEditable

10.0.0

Number(1,0)

Indicates if the user can edit the higher standard. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsHigherStndAutoCalc

10.0.0

Number(1,0)

Indicates if the higher standard is auto-calculated. Valid values: 1=Yes, 0=No. Defaults to 0. Required.

IsHigherStndCalcEditable

10.0.0

Number(1,0)

Indicates if the user can edit the higher standard auto calculation. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsRecentScoreEditable

10.0.0

Number(1,0)

Indicates if the teacher can edit the recent score. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsStandardsLimited22.5.0Number(1,0)Indicates whether to Limit Assignment Standard Selection to Lowest Level. Valid values: 1=Yes, 0=No. Defaults to 0.
IsStandardsLimitedEditable22.5.0Number(1,0)Indicates if the teacher can set Limit Assignment Standard Selection to Lowest Level. Valid values: 1=Yes, 0=No. Defaults to 0.

IsStandardsShown

10.0.0

Number(1,0)

Describes if the standards pages appear in the gradebook. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsStandardsShownOnAsgmt

10.0.0

Number(1,0)

Describes if teachers are able to associate standards to assignments. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsTraditionalGradeShown

10.0.0

Number(1,0)

Describes if the traditional grades appear in the gradebook. Valid values: 1=Yes, 0=No. Defaults to 1. Required.

IsUsingPercentForStndAutoCalc22.5.1.0Number(1,0)Indicates whether to use the assignment percent score when auto-calculating standards scores. Valid values: 1=Use the assignment percent score, 0=Use the earned standard level value. Defaults to 0.

RecentScoreWeightList

10.0.0

Varchar2(400)

Indicates the weighting across the most recent scores. The number of weight values entered provides the number of most recent scores. Stored as a comma-separated list. Defaults to 1,1,1 (string). Required.

SchoolsDCID

10.0.0

Number(10,0)

Foreign key. Internal number for the associated Schools.DCID record. Required. Indexed.

SectionNames

10.0.0

Varchar2(30)

Defines how sections are differentiated/displayed for teachers at a school. Valid values: PeriodAndDay, SectionNumber, Alphabetical. Defaults to PeriodAndDay. Required.

StandardTraditionalOrder

10.0.0

Varchar2(30)

When both Traditional and Standards are used, which appears first in the gradebook. Valid values: TraditionalFirst=Order by Traditional then Standards, StandardsFirst=Order by Standards then Traditional. Defaults to TraditionalFirst. Required.

TermBinLockOffset12.0.0Number(2)Number of days after the end of the reporting term that grades should be locked. Optional. Default NULL.

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 the database user. Required.

WhoModified

10.0.0

Varchar2(100)

The user login that modified the record. Defaults to the 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.

JavaScript errors detected

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

If this problem persists, please contact our support.