GradeCourseConfig (ver10.0.0)
This table contains configuration settings at the course level that can affect how grades are calculated and who may edit those settings. These settings may supersede school specific settings.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CalcMetricCourseFromStnd | 10.0.0 | Varchar2(30) | Defines the metric to be used when calculating the course grade from the standard grade. Valid values: Power, Most_Recent, None, Mean, Weighted_Mean, Median, Mode, Highest, Null. Defaults to Null. |
CoursesDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated Courses.DCID record. Required. Indexed. |
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. Defaults to Null. |
GradeCourseConfigID | 10.0.0 | Number(16,0) | Primary key. A unique sequential number generated by the PowerSchool. Required. Indexed. |
GradeFormulaSetID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated GradeFormulaSet.GradeFormulaSetID record. 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. |
IsAsgmtScorePushEditable | 10.0.0 | Number(1,0) | Indicates if the user can edit the assignment score value used to calculate the standards values setting. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsAsgmtScorePushToStnd | 10.0.0 | Number(1,0) | Indicates whether the assignment score value is used to calculate the standard scores. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsCalcCrsFrmStndEditable | 10.0.0 | Number(1,0) | Indicates if the user can edit the calculation metric for calculating a course grade from a standard grade. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsCalcFormulaEditable | 10.0.0 | Number(1,0) | Indicates whether 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 whether the teacher can edit the calculation precision. 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 level standard. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsHigherStndAutoCalc | 10.0.0 | Number(1,0) | Indicates if 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 standard 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 weights entered provides the number of most recent scores. Stored as a comma separated list. Defaults to Null. |
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. |
WhenCreated | 10.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 10.0.0 | Timestamp(6) | The 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. |