PGAssignments, 92 (ver3.6.1)
Assignments entered by teachers in PowerGrade.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Abbreviation | 3.6.1 | Varchar(15) | A shorter version of the name of this assignment for quick reference. |
AssignmentID | 3.6.1 | Number(10,0) | This is the sequential number for this assignment for this section. |
DateDue | 3.6.1 | Date | The date this assignment is due. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | A more detailed description of this assignment than the name. This is optional. |
GradebookType | 5.0.13 | Number(10,0) | Indicates the type of gradebook in used for this assignment. Valid values: 0 = PowerGrade, 1 = PowerTeacher gradebook. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IncludeInFinalGrades | 5.0.13 | Number(10,0) | Indicates if the assignment will count toward the final grade. |
Name | 3.6.1 | Varchar(50) | Name of the assignment such as Essay, Homework, etc. |
PGCategoriesID | 3.6.1 | Number(10,0) | The internal number for the PGCategories with which this record is associated. Indexed. |
PointsPossible | 3.6.1 | Float | Total possible points for this assignment that a student can earn. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
PublishDaysBeforeDue | 5.0.13 | Number(10,0) | Indicates the number of days before the assignment due date that the assignment will be published. |
PublishOnSpecificDate | 5.0.13 | Date | Date an assignment will be published. |
PublishScores | 5.0.13 | Number(10,0) | Flag to indicate if the assignment score, percent earned, and letter grade are published. Valid values: 0 = Do not publish, 1 = Publish |
PublishState | 5.0.13 | Number(10,0) | Indicates the publishing preference selected by the teacher for an assignment. Valid values: 0 = Immediately, 1 = On Specified Date, 2 = X Days Before the Due Date, 3 = On Due Date, 4 = Never. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections record. |
Type | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Weight | 3.6.1 | Float | The overall weight of this assignment. This multiplied by PointsPossible shows the actual points of this assignment for total possible points for this section. |