GPVersion (ver6.2.0)
A specific version of a GradPlan (range of years).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
EndYear | 6.2.0 | Number(4) | The latest Student.GPEntryYear (for Grad Contract) or Student.Sched_YearOfGraduation (for Post-Secondary plans), which will automatically get this version when assigned to the plan. |
| GPAMethod | 20.11.0.0 | Varchar2(50) | If set, it specifies which GPA method is used to calculate the student's earned GPA for course credits applied to this graduation plan. |
GradPlanID | 6.2.0 | Number(10) | Foreign key to GradPlan.ID. |
ID | 6.2.0 | Number(10) | Unique identifier. |
| IsAdvancedPlan | 6.2.0 | Number(1,0) | Column holds Boolean value indicating if the plan version is Advanced (value=1) or legacy/deprecated (value=0). Required. |
| MinimumGPA | 20.11.0.0 | Float | If set, the minimum GPA for course credits is applied to this graduation plan. Must be greater than 0 if set. |
| MinimumGrade | 20.11.0.0 | Varchar2(2) | If set, the minimum letter grade is required to fulfill this graduation plan. |
| MinimumGradePercentage | 20.11.0.0 | Number(4,1) | If set, the minimum percent grade is required to fulfill the graduation plan. Valid value is between 0 and 100. |
| SourceID | 21.4.0 | Number(10) | Foreign key to Historic version which was migrated to create this Advanced version. Null if the version was created directly, not migrated. |
StartYear | 6.2.0 | Number(4) | The earliest Student.GPEntryYear (for Grad Contract) or Student.Sched_YearOfGraduation (for Post-Secondary plans), which will automatically get this version when assigned to the plan. |
| UseAllCoursesForGPACalc | 21.11.1.0 | Number(1,0) | If set, indicates to use all courses that the student has credits in for GPA. If zero, restricts GPA calculation to courses named in the Graduation Plan. |
WhenCreated | 6.2.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.0 | Varchar2(100) | The user login that created the record. Defaults to the database user. |
WhoModified | 6.2.0 | Varchar2(100) | The user login that modified the record. Defaults to the database user. |
| VerifyMinimumGradeFirst | 20.11.0.0 | Number(1) | If true, letter grades are verified before percent grades. Else percent grades are verified first. |