HonorRoll, 34 (ver3.6.1)
Students who have met the Honor Roll requirements set in Pref table for the school.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DateStored | 3.6.1 | Date | Date this record was created. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
GPA | 3.6.1 | Varchar(80) | The GPA value calculated for this student. |
Grade_Level | 3.6.1 | Number(10,0) | Students grade level at the time this record was created. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
LevelValue | 3.6.1 | Varchar(50) | Name of the level l from Gen table used to calculate the honor roll in combination with Method, such as gpacomparator. The values of different levels are stored as named pair in the custom field or other Value fields of the Gen table. Note: Also known as Level. |
Log | 3.6.1 | CLOB | Keeps a detailed log any time an existing record is modified. |
Message | 3.6.1 | CLOB | The value from ValueT of the Gen table used for reports. |
Method | 3.6.1 | Varchar(50) | Method used to calculate the honor roll from Prefs table. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SchoolName | 3.6.1 | Varchar(60) | The associated school name to the school ID for this honor roll. |
StoreCode | 3.6.1 | Varchar(10) | The code retrieved from the Prefs table for the GPAHonorRollStoreCode for the school. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
YearID | 3.6.1 | 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. |