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 |
|---|---|---|---|
| AreGradesLocked | 12.0.0 | Number(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. |
| IsStandardsLimited | 22.5.0 | Number(1,0) | Indicates whether to Limit Assignment Standard Selection to Lowest Level. Valid values: 1=Yes, 0=No. Defaults to 0. |
| IsStandardsLimitedEditable | 22.5.0 | Number(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. |
| IsUsingPercentForStndAutoCalc | 22.5.1.0 | Number(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. |
| StartingPageKey | 24.10.0.0 | Varchar2(256) | The URL specified in StartingPageURL may contain one or more pages that can be displayed. This StartingPageKey uniquely identifies the page to display as the starting page. |
| StartingPageURL | 24.10.0.0 | Varchar2(1024) | The URL for the starting page to use if the teacher has not selected their own starting page. If not set, the teacher will start on the Assignment List page. |
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. |
| TermBinLockOffset | 12.0.0 | Number(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. |