GPProgressSubject (ver10.0.0)
For reporting purposes, this table contains a summary per subject group of a student's credits for their graduation plan. Data is accessed by selecting a group of students and then navigating to [Select Function] arrow > Graduation Progress Report Data Capture (or Special Functions > Group Functions > Graduation Progress Report Data Capture).
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AppliedWaivedCredits | 10.0.0 | Number(15,10) | Number of waived credits that have been applied to this subject group. Defaults to 0. |
EarnedCredits | 10.0.0 | Number(15,10) | Number of earned credits. Values obtained from the StoredGrades table. Defaults to 0. |
EnrolledCredits | 10.0.0 | Number(15,10) | Number of enrolled credits. Values obtained from the CC table. Defaults to 0. |
GPNodeID | 10.0.0 | Number(10,0) | Internal number for the associated GPNode record. Indexed. Required. |
ID | 10.0.0 | Number(19,0) | A unique sequential number generated by the PowerSchool. Required. Indexed. |
IsAdvancedPlan | 10.0.0 | Number(1,0) | Column holds Boolean value indicating if the plan version is Advanced (value=1) or Legacy/Deprecated (value=0). Required |
IsGroupSatisfied | 21.4.0.0 | Number(1,0) | Boolean value indicating if this group node satisfies (value = 1) the student's courses/tests. |
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. |
IsTestGroupWaived | 21.4.0.0 | Number(1,0) | Boolean value indicating if this test group node requirement was waived (value = 1) for this student. |
MinGPAMet | 21.11.0.0 | Number(1,0) | Boolean value indicating that this node meets minimum GPA requirements (value = 1). Reserved for future use. |
NodeGPA | 21.11.0.0 | Float | GPA that has been calculated for this node. Reserved for future use. |
RequestedCredits | 10.0.0 | Number(15,10) | Number of requested credits. Values obtained from the ScheduleRequests table. Defaults to 0. |
RequiredCredits | 10.0.0 | Number(15,10) | Number of required credits. Values obtained from the GPNode table. Defaults to 0. |
StudentsDCID | 10.0.0 | Number(10,0) | Internal number for the associated Student record. Required. Indexed. |
WaivedCredits | 10.0.0 | Number(15,10) | Number of credits waived from this subject group. Defaults to 0. |
WhenCreated | 10.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
WhoCreated | 10.0.0 | Varchar2(100) | The user login that created the record. Defaults to the database user. Required. |