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.

GPAMethod20.11.0.0Varchar2(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.

IsAdvancedPlan6.2.0Number(1,0)Column holds Boolean value indicating if the plan version is Advanced (value=1) or legacy/deprecated (value=0). Required.
MinimumGPA20.11.0.0FloatIf set, the minimum GPA for course credits is applied to this graduation plan. Must be greater than 0 if set.
MinimumGrade20.11.0.0Varchar2(2)If set, the minimum letter grade is required to fulfill this graduation plan.
MinimumGradePercentage20.11.0.0Number(4,1)If set, the minimum percent grade is required to fulfill the graduation plan. Valid value is between 0 and 100.
SourceID21.4.0Number(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.

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 database user. 

WhoModified

6.2.0

Varchar2(100)

The user login that modified the record. Defaults to database user. 

VerifyMinimumGradeFirst20.11.0.0Number(1)If true, letter grades are verified before percent grades. Else percent grades are verified first.

Copyright © 2021 PowerSchool Group LLC