TermBins, 33 (ver3.6.1)
Term information associated for Grading is maintained in this table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AreGradesLocked | 12.0.0 | Number (1,0) | If the value is NULL, the reporting term is automatically locked based on the offsets in the GradeSchoolConfig table. If the value is 1 the Reporting Term is explicitly locked and no changes will be allowed that affect grade calculations. If the value is 0 the reporting term is explicitly unlocked, changes affecting grade calculations are allowed, and the auto-lock is suspended until the value is changed. |
ChangeGradeTo | 3.6.1 | Varchar(20) | The grade to change to if attendance points are exceeded. |
CitAsmt | 3.6.1 | Varchar(50) | Indicates whether citizenship is being stored. |
Collect | 3.6.1 | Number(10,0) | This is always set to 1 but not currently used. |
CollectionDate | 3.6.1 | Date | Date the data is to be collected. This is usually the Terms last day. |
CreditPct | 3.6.1 | Float | The percentage amount of credit to multiply the potential credit by. |
CreditString | 3.6.1 | Varchar(15) | Converted CreditPct field to a string with the % symbol in it. |
Current Grade | 3.6.1 | Number(10,0) | The TermID this grade is being stored for. |
Date1 | 3.6.1 | Date | The start date for the grades being stored. |
Date2 | 3.6.1 | Date | The end date for the grades being stored. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | Varchar(30) | A short text description for this record to help the user. |
ExcludedMarks | 3.6.1 | CLOB | A list of grades that get excluded from storages. Like pass-fail. |
GradeScaleID | 3.6.1 | Number(10,0) | The gradescale to use on this storage, overriding the default for the courses. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
NumAttPoints | 3.6.1 | Float | The number of attendance points that will trigger a grade change at that point or higher. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
ShowOnSpreadSht | 3.6.1 | Number(10,0) | Used to show the credit factor in terms of portion of part of the year the term takes up. This would be numerator in a fraction. Full year=1, semester=2, quarter=4, etc. |
StoreCode | 3.6.1 | Varchar(8) | The code used to store grades for this term. Often matches the term abbreviation. Must be one letter then one number. Indexed. |
StoreGrades | 3.6.1 | Number(10,0) | The current PG grade this is going to store |
SuppressLtrGrd | 3.6.1 | Number(10,0) | Flag to say if the letter grade should be restrained from displaying. |
SuppressPercentScr | 4.0.0 | Number(10,0) | Indicates whether or not to suppress showing the Percent score on quick lookups. |
TermID | 3.6.1 | Number(10,0) | The internal number for the term with which this record is associated. Indexed. |
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. |