Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.