GPProgressSubjectProgramCourse (ver21.11.0.0)
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CourseName | 21.11.0.0 | Varchar2(100) | Name of the course. Required. |
| CourseNumber | 21.11.0.0 | Varchar2(20) | Course number for this course. Required. |
| CreditTypes | 21.11.0.0 | Varchar2(20) | Credit types if this course was matched via that method. Required. |
| Department | 21.11.0.0 | Varchar2(20) | Department. Required. |
| ExcludeFromGpa | 21.11.0.0 | Number(1,0) | Boolean value indicating if this course is to be excluded from GPA calculations. (1=Exclude) |
| GpProgressSubjectProgramId | 21.11.0.0 | Number(19,0) | Foreign key to the related GPProgressSubjectProgram record. Required. |
| GradeLevel | 21.11.0.0 | Varchar2(20) | Grade level of this course. Required. |
| Id | 21.11.0.0 | Number(19,0) | A unique sequential number generated by the PowerSchool. Required. Indexed. |
| IsComplete | 21.11.0.0 | Number(1,0) | Boolean value indicating if this course has been completed. (1=Completed). Required. |
| IsRequired | 21.11.0.0 | Number(1,0) | Boolean value indicating if this course was required. (1=Required, 0=Not Required). Required. |
| LetterGrade | 21.11.0.0 | Varchar2(20) | Letter grade earned by the student for this course. Required. |
| PercentGrade | 21.11.0.0 | Float | Percent grade earned by the student for this course. |
| PotentialCreditHours | 21.11.0.0 | Float | Credit hours course is worth. |
| SectionId | 21.11.0.0 | Number(19,0) | Foreign key to the section related to this course. |
| Source | 21.11.0.0 | Varchar2(20) | Value indicating where this grade originated Values: Waiver, StoredGrade, Enrollment, Request, Planned. Required. |
| TermName | 21.11.0.0 | Varchar2(20) | Term name associated with this course/section. Required. |
| YearName | 21.11.0.0 | Varchar2(20) | Year name associated with this course/section. Required. |