PGFinalGrades, 95 (ver3.6.1)
Students final grades stored PowerTeacher Gradebook and PowerTeacher Pro.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CalculatedGrade | 10.0.0 | Varchar2(7) | The value of the calculated grade. |
CalculatedPercent | 10.0.0 | Float(126) | The value of the calculated percent. |
Citizenship | 3.6.1 | Varchar2(7) | Shows the Citizenship progress of a student in this section, such as E=Excellent, S=Satisfactory, U=Unsatisfactory, N=Neutral. |
Comment_Value | 5.2.0 | CLOB | Any comment teacher added for this final grade. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Primary key. Required. Indexed. |
EndDate | 3.6.1 | Date | The day the section ended and this grade is for. Usually the terms end day. |
FinalGradeName | 3.6.1 | Varchar2(8) | Name assigned to this final grade. This might be the term abbreviation, such as S1. |
Grade | 3.6.1 | Varchar2(7) | The letter grade assigned to this section for this student. |
GradebookType | 5.1.1 | Number(10,0) | Indicates the type of gradebook used by the teacher. Valid values: 0=PowerGrade, 1=PowerTeacher Gradebook, 2=PowerTeacher Pro. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IsExempt | 10.0.0 | Number(1,0) | Indicates whether this assignment is exempt. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
IsIncomplete | 10.0.0 | Number(1,0) | Indicates whether this assignment is incomplete. Valid values: 0=Complete, 1=Incomplete, Defaults to 0. Required. |
LastGradeUpdate | 3.6.1 | Date | The date this grade record was last updated in PowerTeacher Gradebook or PowerTeacher Pro. |
OverrideFG | 5.0.7 | Varchar2(2) | This field is used to indicate if the final grade has been overridden. |
Percent | 3.6.1 | Float(126) | The percentage points that was received by the student for this section. |
Points | 3.6.1 | Float(126) | The actual points student received for this section. |
PointsPossible | 3.6.1 | Float(126) | The total points possible for this section. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections record. Indexed. |
StartDate | 3.6.1 | Date | The day the section started and this grade is for. Usually the terms first day. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. Indexed. |
VarCredit | 5.0.0 | Float(126) | In support of AEP analysis that teachers have the ability to assign variable credit to students in their class if they wish to do so. |