StandardGradeRollup (ver9.0.0)
This table contains the rollup record for standard grades having the same Student, Standard, StoreCode, and YearID. This is calculated if a student has been assessed the same standard in multiple sections for the same year and store code.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
GradeLevel | 9.0.0 | Number(10,0) | Grade level of the student for this record at the time the record is created. |
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) | Planned future use. Defines if this record is for a student that is still enrolled. Valid values 0 = False, 1 = True. Defaults to 1. Required. |
IsLocked | 9.0.0 | Number(1,0) | No longer used by the application. See LockOverride (ver12.0.0). |
IsMigrated | 9.0.0 | Number(1,0) | Indicator of success of standards migration to this table. 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. |
NumScores | 9.0.0 | Number(10,0) | Number of standards grades used to calculate this rolled up grade. |
SchoolName | 9.0.0 | Varchar2(60) | 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. Required. |
SGRCalculationSettingsID | 12.0.1 | Number(16,0) | Foreign Key. Internal number for the associated SGRCaclculationSettings.SGRCaclculationSettingsID. Indexed. |
StandardAverageGrade | 9.0.0 | Varchar2(50) | Previous StandardsGrades.TransAverageScore column. Translated average score provided for this student for this standard. |
StandardAveragePercent | 9.0.0 | Float(126) | Previous StandardsGrades.AverageScore column. Average score provided for this student for this standard. |
StandardGradeRollupID | 9.0.0 | Number(16,0) | Primary Key. Unique sequential number generated by the application. Indexed. Required. |
StandardHighGrade | 9.0.0 | Varchar2(40) | Previous StandardsGrades.TransHighScore column. Translated High Score (based upon calculation method). |
StandardHighPercent | 9.0.0 | Float(126) | Previous StandardsGrades.HighScore column. Current High Score. |
StandardID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated Standard.StandardID record. Indexed. Required. |
StandardName | 9.0.0 | Varchar2(400) | The name of the standard associated with this record. |
StoreCode | 9.0.0 | Varchar2(10) | The code used to represent this grade level to term ID and school ID. Required. |
StudentsDCID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated students.DCID record. Indexed. Required. |
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. |