ClassRank, 15 (ver3.6.1)
This table stores cumulative or grade-level specific class ranking for current students in a school by calculating GPAs on fly using methods assigned to the school.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ClassRank_Log | 3.6.1 | CLOB | Log of the record whether it's new or any modifications made. |
DateRanked | 3.6.1 | Date | Date this ranking took place within the system. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
GPA | 3.6.1 | Varchar(80) | Grade Point Average of the student calculated on fly. |
GPAMethod | 3.6.1 | Varchar(50) | Method(s) used to calculate GPA and rank students: overridecountsinranka, onlyincludeinranka, isnumericgpaa, includeearlygradsa, earlygradexitcodea. |
Grade_Level | 3.6.1 | Number(10,0) | The Grade Level of the student, such as 9,10, etc. If not cumulative. See StoreCode. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
OutOf | 3.6.1 | Number(10,0) | The total number of students for this school that are being ranked, such as 250 OutOf 300 the 300. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
Rank | 3.6.1 | Number(10,0) | The rank of this student for this school, such as 250 OutOf 300 the 250. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SchoolName | 3.6.1 | Varchar(60) | The name of the school for this class ranking. |
StoreCode | 3.6.1 | Varchar(10) | If empty then cumulative class ranking otherwise if a term is provided then checks for Grade level and Year ID for ranking within grade level. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Unused1 | 3.6.1 | Number(10,0) | Currently unused field. |
YearID | 3.6.1 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004, if not cumulative. See StoreCode. The number is equal to the ID of the year term divided by 100. |