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 assessed 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.

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

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

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.

Copyright © 2021 PowerSchool Group LLC