GradeScaleItem_Backup, 90 (ver3.6.1)
This table is no longer used by the application. The GradeScaleItem table was renamed GradeScaleItem_Backup. A new GradeScaleItem table has been created in its place. For more information, see the new GradeScaleItem table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AddedValue | 3.6.1 | 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. |
Alt_Grade_Points | 4.3.0/5.0.7 | Float | Alternate Grade Point value. |
CountsInGPA | 3.6.1 | Number(10,0) | Indicates whether this grade scale item will count toward GPA calculation. 1=yes. |
CutoffPercentage | 3.6.1 | Float | Anything at or above this percentage points (less than the next record) receives the letter grade of this record. |
CutoffPoints | 4.3.0/5.0.7 | Float | Similar to the cutoff for Percentage, except that this field will specify the point’s demarcation rather than the percentage. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | The description given to this grade scale item such as Above Average or if parent level, AP Grade Scale. |
ExcludeFromAFG | 4.3.0/5.0.7 | Number(10,0) | Flag to specify that this record should be excluded from the Average Final Grade calculation. |
Grade_Replacement_Policy | 7.8.1 | 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. |
GradeScaleID | 3.6.1 | 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. |
Grade_Points | 3.6.1 | Float | Points associated to this grade. For example, 4 to A, 3 to B, etc. |
GraduationCredit | 3.6.1 | Number(10,0) | Indicates whether this grade scale item is high enough to earn graduation credit. 1= yes. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Modify_Code | 3.6.1 | Number(10,0) | Indicates whether this grade scale can be modified. 1= Modifiable. |
Name | 3.6.1 | Varchar(50) | The actual letter grade associated to this record, such as A, B, etc. |
PowerLink | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PowerLinkSpanish | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
TeacherScale | 3.6.1 | Number(10,0) | Indicates whether these are valid for Teacher grade scales. 1= yes. |
Value | 3.6.1 | Float | The grade point value assigned to this grade scale. |