PSM_GradeScale (ver1.0)
This table contains grade scale information. Data duplicated here from the originating SIS.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CanModify | 1.5 | Number(1,0) | 1 indicates the teacher can modify the gradescale. |
ContentGroupID | 1.0 | Number(19,0) | The internal ID of the PSM_ContentGroup record to which the grade is associated. Required. |
Description | 1.0 | Varchar2(4000) | Grade scale description. |
GradingScale | 1.5 | Number(10,0) | Currently not used. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
IsDistrictDefault | 1.0 | Number(3,0) | 1 indicates the gradescale defined by the district. 0 indicates the gradescale defined by teacher. |
IsNumeric | 1.5 | Number(5,0) | 1 indicates the gradescale is numeric based. 0 indicates the gradescale is letter based. |
Name | 1.0 | Varchar2(50) | The gradescale name. Required. |
NumericMax | 1.5 | Number(10,0) | For numeric gradescales, contains the max numeric value possible. |
NumericMin | 1.5 | Number(10,0) | For numeric gradescales, contains the min numeric value possible. |
NumericPrecision | 1.5 | Number(10,0) | For numeric gradescales, contains the precision for the values. |
NumericScale | 1.5 | Number(10,0) | For numeric gradescales, contains the scale (number of decimal places) |
ParentGradeScaleID | 1.5 | Number(19,0) | Internal number for the associated PSM_GradeScale record. |
SchoolID | 1.5 | Number(19,0) | Internal number for the associated PSM_School record. |
TeacherID | 1.5 | Number(19,0) | Internal number for the associated PSM_Teacher record. |