GPNode (ver6.2.0)

Details of the nodes of the GradPlan. Hierarchy with each node containing a capacity.

Column Name

Initial Version

Data Type

Description

AllowAnyOf9.2.2.1Number(1)Indicates whether the node supports "Any of" for credits. Valid values: 1 = Yes, 0 = No. Defaults to 0. Required.
AllowWaiver9.2.2.1Number(1)Indicates whether the node can have credit hours waived. Valid values: 1 = Yes, 0 = No. Defaults to 0. Required.

CreditCapacity

6.2.0

Number(15)

The number of credits required at this node for it to be fully satisfied.

GPAMethod21.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 node.

GPVersionID

6.2.0

Number(10)

Foreign key to GPVersion.ID.

ID

6.2.0

Number(10)

Unique identifier.

IsHidden

6.2.0

Number(1)

If true, this node will not be displayed on the progress screen (not used currently).

isSingleSitting21.4.1.0Number(1)If true, test scores must come from a single sitting. Otherwise, the best score is used. 1 = Yes (True), 0 = No (False). Defaults to 0. Required.
isSummation20.11.0.0Number(1)If true, this node acts as a Summation Node for all the individual Test Scores that belong to it.
MinimumGPA21.11.0.0FloatIf set, the minimum GPA for course credits is applied to this node of the graduation plan. Must be greater than 0 if set.
MinimumGrade21.11.0.0Varchar2(2)If set, the minimum letter grade is required to fulfill this node of the graduation plan.
MinimumGradePercentage21.11.0.0Number(4,1)If set, the minimum percent grade is required to fulfill this node of the graduation plan. Valid value is between 0 and 100.

Name

6.2.0

Varchar2(80)

Name of this node.

NodeType20.11.0.0Number(5)Type of Node, Default value 0. 0 = Legacy Course Group Node, 1 = Test Group Node

ParentID

6.2.0

Number(10)

"Parent" node, such as node, which contains this one, or null for the "root" node in a version. Indexed.

RequirementCount21.11.0.0Number(2,0)If set, it specifies how many programs are needed to fulfill graduation requirements for this node of the graduation plan.

SortOrder

6.2.0

Number(10)

Order of the node amongst its siblings.

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

Copyright © 2021 PowerSchool Group LLC