StandardsGrade (ver9.0.0)
This view, formerly the StandardsGrade table, provides information about the standard scores students have if PowerGrade is not being used. This must be set up for each school first so Teachers can enter the Final Grades.
Note: This view maintains compatibility for SQL written prior to PowerSchool SIS 9.0. This view is no longer used for active development.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AverageScores | 3.6.1 and 4.2.1 | Float | [From StandardGradeSection.StandardPercent or StandardGradeRollup.StandardAveragePercent] Average score provided for this student for this standard. School can either set up average score, high score, trans average score or trans high score to be entered. |
Comment_Value | 3.6.1 and 4.2.1 | CLOB | [From StandardGradeSectionComment.CommentValue, or StandardGradeRollup.CommentValue] If set up for the school, any comment teacher enters for this grade. |
DateStored | 3.6.1 | Date | [From StandardGradeSection.LastUpdated or StandardGradeRollup.LastUpdated] Date this grade was entered. |
DCID | 4.0.0 | Number(10,0) | [From StandardGradeSection.StandardGradeSectionID, or StandardGradeRollupId] Unique identifier for this table. Indexed. Required. |
Grade_Level | 3.6.1 | Number(10,0) | [From StandardGradeSection.GradeLevel, or StandardGradeRollup.GradeLevel] Grade level of the student for this record. |
HighScore | 4.2.1 | Float | [From StandardGradeSection.StandardPercent, or StandardGradeRollup.StandardHighPercent] Current high score. |
ID | 3.6.1 | Number(10,0) | [From StandardGradeSection.StandardGradeSectionID, or StandardGradeRollupId] Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
NumScores | 4.2.1 | Number(10,0) | [From StandardGradeRollup.NumScores] Number of scores. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SchoolName | 3.6.1 | Varchar(31) | Name of the school associated with this record. |
StandardsID | 3.6.1 | Number(10,0) | [From Standard.LogitudinalId] The internal number for the standards with which this record is associated. Indexed. |
StoreCode | 3.6.1 | Varchar(10) | [From StandardGradeSection.StoreCode or StandardGradeRollup.StoreCode] The code used to represent this grade level to Term ID and School ID. |
StudentID | 3.6.1 | Number(10,0) | [From Students.Id] The internal number and ID of the associated students record. |
TransAverageScore | 3.6.1 and 4.2.1 | Varchar(50) | [From StandardGradeSection.StandardGrade or StandardGradeRollup.StandardAverageGrade] Translated average score provided for this student for this standard. School can either set up average score, high score, trans average score or trans high score to be entered. Indexed. |
TransHighScore | 4.2.1 | Varch ar(40) | [From StandardGradeSection.StandardGrade or StandardGradeRollup.StandardHighGrade] Translated high score (based upon calculation method). |
YearID | 3.6.1 | Number(10,0) | [From StandardGradeSection.YearId] 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. Indexed. |