Skip to main content
Skip table of contents

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





Number of waived credits that have been applied to this subject group. Defaults to 0.

EarnedCredits10.0.0Number(15,10) Number of earned credits. Values obtained from the StoredGrades table. Defaults to 0.

Number of enrolled credits. Values obtained from the CC table. Defaults to 0.

GPNodeID10.0.0Number(10,0)Internal number for the associated GPNode record. Indexed. Required.
ID10.0.0Number(19,0) A unique sequential number generated by the PowerSchool. Required. Indexed.
IsAdvancedPlan10.0.0Number(1,0) Column holds Boolean value indicating if the plan version is Advanced (value=1) or Legacy/Deprecated (value=0). Required
IsGroupSatisfied21.4.0.0Number(1,0)Boolean value indicating if this group node satisfies (value = 1) the student's courses/tests.
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.
IsTestGroupWaived21.4.0.0Number(1,0)Boolean value indicating if this test group node requirement was waived (value = 1) for this student.
MinGPAMet21.11.0.0Number(1,0)Boolean value indicating that this node meets minimum GPA requirements (value = 1). Reserved for future use.
NodeGPA21.11.0.0FloatGPA that has been calculated for this node. Reserved for future use.
RequestedCredits10.0.0Number(15,10) Number of requested credits. Values obtained from the ScheduleRequests table. Defaults to 0.
RequiredCredits10.0.0Number(15,10) Number of required credits. Values obtained from the GPNode table. Defaults to 0.
StudentsDCID10.0.0Number(10,0) Internal number for the associated Student record. Required. Indexed.
WaivedCredits10.0.0Number(15,10) Number of credits waived from this subject group. Defaults to 0.




The date and time the record was created. Defaults to system date. Required.




The user login that created the record. Defaults to the database user. Required.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.