GradeSectionConfig (ver10.0.0)
This table contains configuration settings at the section level that can affect how grades are calculated and who may edit those settings. Section specific settings always override school and course settings.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CalcMetricSectionFromStnd | 10.0.0 | Varchar2(30) | Defines the metric to be used when calculating the course grade from the standard grade. Valid values: Most_Recent, None, Mean, Weighted_Mean, Median, Mode, Highest, Null. Defaults to Null. |
DefaultDecimalCount | 10.0.0 | Number(1,0) | Defines the default decimal count at the course level. Valid values: 0, 1, 2, 3, Null. Defaults to Null |
DefaultRoundingRule | 10.0.0 | Varchar2(30) | Defines the default rounding rule at the course level. Valid values: Round, Truncate, Null. |
GradeFormulaSetID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated GradeFormulaSet.GradeFormulaSetID record. Indexed. |
GradeSectionConfigID | 10.0.0 | Number(16,0) | 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, Null. Defaults to Null. |
IsCalcFormulaEditable | 10.0.0 | Number(1,0) | Indicates if the teacher can edit the calculation formula. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
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, Null. Defaults to Null. |
IsCalcSectionFromStndEdit | 10.0.0 | Number(1,0) | Indicates if the user can edit the calculation metric for calculating a section grade from a standard grade. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsDropScoreEditable | 10.0.0 | Number(1,0) | Indicates if the teacher can edit the drop score. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsHigherLvlStndEditable | 10.0.0 | Number(1,0) | Indicates if the user can edit the higher standard. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsHigherStndAutoCalc | 10.0.0 | Number(1,0) | Indicates whether the higher standard is auto calculated. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsHigherStndCalcEditable | 10.0.0 | Number(1,0) | Indicates if the user can edit the higher standard auto calculation. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsStndCalcMetEditable | 10.0.0 | Number(1,0) | Indicates if the teacher can edit the calculation metric. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsStndRcntScoreEditable | 10.0.0 | Number(1,0) | Indicates if the teacher can edit the recent score. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
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, Null. Defaults to Null. |
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 Null. |
SectionsDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated Sections.DCID record. Required. Indexed. |
StndCalculationMetric | 10.0.0 | Varchar2(30) | Indicates how higher level standards are calculated. Valid values: Power, Most_Recent, None, Mean, Weighted_Mean, Median, Mode, Highest, Null. Defaults to Null. |
Type | 10.0.0 | Varchar2(30) | Determines if the formula is defined by the PowerSchool administrator or the teacher. Valid values: Admin, Teacher. Required. Indexed. |
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 database user. Required. |
WhoModified | 10.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |