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 |
---|---|---|---|
AllowAnyOf | 9.2.2.1 | Number(1) | Indicates whether the node supports "Any of" for credits. Valid values: 1 = Yes, 0 = No. Defaults to 0. Required. |
AllowWaiver | 9.2.2.1 | Number(1) | Indicates whether the node can have credit hours waived. Valid values: 1 = Yes, 0 = No. Defaults to 0. Required. |
AltCompletionCount | 21.11.0.0 | Number(2) | Indicates how many alternative items are needed to satisfy each individual requirement. . Defaults to 0. Required. |
CompletionCount | 21.11.0.0 | Number(2) | Indicates how many items are needed to satisfy each individual requirement. . Defaults to 0. Required. |
CreditCapacity | 6.2.0 | Number(15) | The number of credits required at this node for it to be fully satisfied. |
GPAMethod | 21.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 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). |
isSingleSitting | 21.4.1.0 | Number(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. |
isSummation | 20.11.0.0 | Number(1) | If true, this node acts as a Summation Node for all the individual Test Scores that belong to it. |
MinimumGPA | 21.11.0.0 | Float | If set, the minimum GPA for course credits is applied to this node of the graduation plan. Must be greater than 0 if set. |
MinimumGrade | 21.11.0.0 | Varchar2(2) | If set, the minimum letter grade is required to fulfill this node of the graduation plan. |
MinimumGradePercentage | 21.11.0.0 | Number(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. |
NodeType | 20.11.0.0 | Number(5) | Type of Node, Default value 0.
|
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. |
RequirementCount | 21.11.0.0 | Number(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. |
VerifyMinimumGradeFirst | 21.11.0.0 | Number(1) | If true, letter grades are verified before percent grades. Else percent grades are verified first. |