StandardGradeSection (ver9.0.0)
This table contains the standards final grades for a student based on a year, reporting term, standard, school, and section.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CalculatedGrade | 9.2.0 | Varchar2(50) | The value of the calculated grade. |
CalculatedHighest | 9.2.0 | Varchar2(50) | The calculated grade using the highest grading metric. |
CalculatedHighestMostRecent | 9.3.0 | Varchar2(50) | Contains the highest score of the N most recent scores. |
CalculatedMean | 9.2.0 | Varchar2(50) | The calculated grade using the mean grading metric. |
CalculatedMedian | 9.2.0 | Varchar2(50) | The calculated grade using the median grading metric. |
CalculatedMode | 9.2.0 | Varchar2(50) | The calculated grade using the mode grading metric. |
CalculatedMostRecentScores | 9.2.0 | Varchar2(50) | The calculated grade using the most recent score(s) grading metric. |
CalculatedPower | 9.2.0 | Varchar2(50) | The calculated grade using the power grading metric. |
CalculatedWeightedMean | 9.2.0 | Varchar2(50) | The calculated grade using the weighted mean grading metric. |
CourseName | 9.0.0 | Varchar2(100) | Not used. |
GradeLevel | 9.0.0 | Number(10,0) | The grade level of the student for this record. |
IsAdminModified | 9.0.0 | Number(1,0) | Defines if this record was modified by an Admin. Valid values: 0=False, 1=True. Defaults to 0. Required. |
IsEnrolled | 9.0.0 | Number(1,0) | Defines if this record is for a student that is still enrolled. Valid values: 0=False, 1=True. Defaults to 1. Required. |
IsExempt | 9.2.0 | Number(1,0) | Indicates that the grade is exempt. Required. |
IsIncomplete | 9.2.0 | Number(1,0) | Indicates that the status of the grade is incomplete. Required. |
IsLocked | 9.0.0 | Number(1,0) | No longer used by the application as ver12.0.0. See LockOverrideSection table. Defines if this record is locked and cannot be modified by the teacher. Valid values: 0 = False,1 = True. Defaults to 0. Required. |
IsManuallyOverridden | 9.2.0 | Number(1,0) | Indicates that the grade has been manually overridden. Required. |
IsMigrated | 9.0.0 | Number(1,0) | Indicates if this record was migrated from PowerTeacher Gradebook original data modified by the teacher. Valid values: 0=False, 1=True. Defaults to 0. Required. |
IsReportsRollupExcluded | 9.0.0 | Number(1,0) | Indicates if this record is excluded from the report rollup. Valid values: 0=False, 1=True. Defaults to 0. Required. |
LastUpdated | 9.0.0 | Timestamp(6) | The date the last update to the grade occurred. Required. |
SchoolName | 9.0.0 | Varchar2(60) | The name of the school associated with this record. |
SchoolsDCID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated Schools.DCID record. Indexed. |
SectionsDCID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated Sections.DCID record. Indexed. |
StandardGrade | 9.0.0 | Varchar2(50) | Previously StandardsGrades.TransAverageScore column. The actual letter or numeric standard grade for the student for this section and store code. |
StandardGradeSectionID | 9.0.0 | Number(16,0) | Primary Key. Unique sequential number generated by the application. Required. Indexed. |
StandardID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated Standard.StandardID record. Required. Indexed. |
StandardName | 9.0.0 | Varchar2(400) | Currently not used. |
StandardPercent | 9.0.0 | Float(126) | Previous StandardsGrades.AverageScore column. Average score provided for this student for this standard stored in a percent value. |
StoreCode | 9.0.0 | Varchar2(10) | The code used to represent the TermBin record for this school and year. Required. |
StudentsDCID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated students.DCID record. Required. Indexed. |
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. |
YearID | 9.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Required. Indexed. |