PSM_Grade (ver1.0)
This table contains the actual grades contained by the grade scales. Data duplicated here from the originating SIS.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AdminUseOnly | 1.0 | Number(3,0) | 1 indicates the grade is for administrator use only, not for teacher's use in PowerTeacher gradebook. Required. |
CutoffPercentage | 1.0 | Number(18,6) | Anything at or above this percentage points (less than the next record) receives the letter grade of this record. |
DefaultZeroCutoff | 1.0 | Number(3,0) | Indicates if the grade will be used as the default if there is more than one grade with a zero cutoff. |
Description | 1.0 | Varchar2(4000) | The description given to this grade scale item, such as Above Average, or, if parent level, AP Grade Scale. |
GradeLabel | 1.0 | Varchar2(30) | The actual letter grade associated to this record, such as A, B, etc. Required. |
GradeScaleID | 1.0 | Number(19,0) | The internal ID of the PSM_GradeScale record to which the grade is associated. Required. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
IsSpecial | 1.0 | Number(3,0) | Not included in any calculations, for example averages. Allowed as a final grade for both alpha and numeric scale types. Allows selection in the manual override option. |
PercentValue | 1.0 | Number(18,6) | The percent value assigned to this grade. |
PointsValue | 1.0 | Number(18,6) | The grade point value assigned to this grade. |
SortOrder | 1.5 | Number(10,0) | Order Grade should appear in the gradescale. |