GradeScaleItem (ver9.0.0)
This table contains grade scale and grade label information.
Note: The GradeScaleItem (ver3.6.1) table is no longer used by the application and has been renamed GradeScaleItem_Backup. For more information, see the GradeScaleItem_Backup table.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AddedValue | 9.0.0 | Number(10,0) | Number to be added to GPA for this grade scale. Usually for AP courses there is a bump to the GPA, such as 0.125. |
AltConvertGradeScaleDCID | 9.0.0 | Number(10,0) | Planned future use. Internal number of the associated grade scale item record containing the alternate assignment conversion grade scale to be used in place of the course grade scale. |
AltFinalNumericCutoff | 9.0.0 | Number(18,6) | Planned future use. The numeric final grade conversion cutoff used for assignments and standards in place of the course grade scale. |
AltFinalNumericRange | 9.0.0 | Varchar2(30) | Planned future use. The numeric effective range used for assignments and standards in place of the course grade scale. |
Alt_Grade_Points | 9.0.0 | Float(126) | Alternate grade point value. |
Color | 9.0.0 | Varchar2(30) | Within PowerTeacher Pro, indicates the color to be used for this grade label. Is paired with proficiency setting. Valid values: 1,2 = not proficient, 3,4,5 = proficient |
ColorLevels | 9.0.0 | Number(6,0) | Within PowerTeacher Pro, indicates the number of initial available color levels for the grade scale. |
ConversionToNumeric | 9.0.0 | Varchar2(30) | Within PowerTeacher Pro, when scoring standards this value indicates the method of converting other scales into a numeric scales. Determines if a decimal value is allowed. Valid values: Cutoff, Percent. Defaults to NULL. |
CountsInGPA | 9.0.0 | Number(10,0) | Indicates whether this grade scale item will count toward GPA calculation. Valid values: 0 = No, 1 = Yes. Defaults to NULL. |
CutoffPercentage | 9.0.0 | Float(126) | Anything at or above this percentage points (less than the next record) receives the letter grade of this record. |
CutoffPoints | 9.0.0 | Float(126) | Similar to the cutoff for percentage, except that this field will specify the point's demarcation rather than the percentage. |
DCID | 9.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 9.0.0 | Varchar2(4000) | The description given to this grade scale item such as Above Average or if parent level, AP Grade Scale. |
DisplayPosition | 9.0.0 | Number(6,0) | Within PowerTeacher Pro, the sort order of the score codes and other special grade labels will appear. For an alpha scale, it also determines which item is the default zero cut-off grade label when multiple zero cutoffs exist. |
ExcludeFromAFG | 9.0.0 | Number(10,0) | Flag to specify that this record should be excluded from the average final grade calculation. Valid values: 0 = False, 1 = True. Defaults to NULL. |
GradeScaleID | 9.0.0 | Number(10,0) | The parent ID of this grade scale. If -1, then this is the parent. Otherwise, this could be the general grade scale, such as Weighted GPA, Total GPA. Indexed. |
GradeScaleType | 9.0.0 | Varchar2(30) | Within PowerTeacher Pro, type used when scoring this grade scale. Valid values: Alpha, Numeric, Special. Required. |
Grade_Points | 9.0.0 | Float(126) | Points associated to this grade. For example, 4 to A, 3 to B, etc. |
Grade_Replacement_Policy | 9.0.0 | Number(10,0) | Indicates whether the repeated course grade suppression policy rule has been enabled for this grade. Valid values: 0 = False, 1 = True. Defaults to 0. |
GraduationCredit | 9.0.0 | Number(10,0) | Indicates whether this grade scale item is high enough to earn graduation credit. Valid values: 0 = No, 1 = Yes. Default is NULL. |
HasRelatedScales | 9.0.0 | Number(1,0) | Planned future use. 1 indicates other alpha and numeric grades scales can be used in conjunction with this grade scale. Valid values: 0 = No, 1 = Yes. Defaults to 0. Required. |
HasSpecialGrades | 9.0.0 | Number(1,0) | Within PowerTeacher Pro, 1 indicates a special grade scale is used in conjunction with this grade scale. Valid values: 0 = No, 1 = Yes. Defaults to 0. Required. |
ID | 9.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IsForCourseGrade | 9.0.0 | Number(1,0) | Within PowerTeacher Pro, indicates if this gradescale applies for the final grade for a course Valid values: 0 = No, 1 = Yes. Defaults to 1. Required. |
IsForStandards | 9.0.0 | Number(1,0) | Within PowerTeacher Pro, indicates if this gradescale applies to standards and standard final grades Valid values: 0 = No, 1 = Yes. Defaults to 1. Required. |
IsGPAShown | 9.0.0 | Number(1,0) | 1 Indicates the GPA related columns are displayed in the grade scale grid. Valid values: 0=No, 1=Yes. Defaults to 1. Required. |
IsProficient | 9.0.0 | Number(1,0) | Within PowerTeacher Pro, indicates this grade label is considered to be proficient. Is paired with the Color Valid values: 0=No, 1=Yes. Defaults to 1. Required. |
IsScoreCodeOnAssignments | 9.0.0 | Number(1,0) | Within PowerTeacher Pro, for Special Grade Scales, a 1 indicates that the grade label can also be used on assignments by the teacher. It is an attribute of the item. Valid values: 0=No, 1=Yes. |
IsTermWeightingShown | 9.0.0 | Number(1,0) | 1 Indicates the term weighting related columns are displayed in the grade scale grid. Valid values: 0=No, 1=Yes.Defaults to 0. Required. |
Modify_Code | 9.0.0 | Number(10,0) | Indicates whether this grade scale can be modified. Valid values: 0=Locked, 1=Modifiable. Defaults to NULL. |
Name | 9.0.0 | Varchar2(50) | The actual letter grade associated to this record, such as A, B, etc. |
NumericCutoff | 9.0.0 | Number(18,6) | Within PowerTeacher Pro, for a numeric scale, anything at or above this numeric value (less than the next record) receives the numeric grade of this record. |
NumericDecimals | 9.0.0 | Number(10,0) | Within PowerTeacher Pro, the number of decimal places to be used for numeric scales. |
NumericExtras | 9.0.0 | Varchar2(30) | Within PowerTeacher Pro, for zero decimal numeric grade scales, this value determines if additional discrete options are valid: (HALF_PLUS = +, THIRD_PLUS_MINUS = +/-, HALF_POINT_5 = 0.5, THIRD_POINT_33 = 0.33, QUARTER_POINT_25 = 0.25, NONE). |
NumericMax | 9.0.0 | Number(10,0) | Within PowerTeacher Pro, for a numeric scale, this value indicates the maximum numeric integer value allowed for the grade scale. |
NumericMin | 9.0.0 | Number(10,0) | Within PowerTeacher Pro, for a numeric scale, this value indicates the minimum numeric integer value allowed for the grade scale item. |
| NumericMode | 19.4.0.0 | Varchar2(8) | For Scales, where GradeScaleType is NUMERIC, and isForCourseGrade is 1, determines whether the PERCENT or LEVEL will be used when calculating course final grades |
NumericValue | 9.0.0 | Number(18,6) | Within PowerTeacher Pro,. For a numeric scale, the numeric value of the scale item. Necessary for mapping numeric items with extras. ex: 4- = 3.67 |
PSGUID | 9.0.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SpecialGradeScaleDCID | 9.0.0 | Number(10,0) | Within PowerTeacher Pro, internal number of the associated grade scale item record containing the special grade scale. No value for grade label records. |
TeacherScale | 9.0.0 | Number(10,0) | Indicates whether these are valid for Teacher grade scales. Valid values: 0=No, 1=Yes. Defaults to NULL |
Value | 9.0.0 | Float(126) | The grade point value assigned to this grade scale. |
WhenCreated | 9.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 9.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |