GPProgressSubjectEarned (ver10.0.0)
For reporting purposes, this table contains the credits a student earned per course 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 |
|---|---|---|---|
CourseNumber | 10.0.0 | Varchar2(20) | Value obtained from the StoredGrades table. |
| EarnedCredits | 10.0.0 | Number(15,10) | Number of earned credits. Values obtained from the StoredGrades table. Defaults to 0. |
| GPProgressSubjectID | 10.0.0 | Number(10,0) | Internal number for the associated GPProgressSubject record. Indexed. Required. |
| ID | 10.0.0 | Number(19,0) | A unique sequential number generated by the PowerSchool. Required. Indexed. |
| LetterGrade | 10.0.0 | Varchar2(7) | Value obtained from the StoredGrades table. |
| Percentage | 10.0.0 | Float | Value obtained from the StoredGrades table. |
| StoregradesDCID | 10.0.0 | Number(10,0) | Internal number for the associated StoredGrades record. Required. Indexed. |
WhenCreated | 10.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |