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