PSM_Assignment (ver1.0)
This table contains assignments entered by teachers using the PowerTeacher gradebook.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbreviation | 1.0 | Varchar2(30) | A shorter version of the name of this assignment for quick reference. |
AssignmentCategoryID | 1.0 | Number(19,0) | Internal ID of the PSM_AssignmentCategory record to which the record is associated. |
ContentGroupID | 1.0 | Number(19,0) | Internal ID of the PSM_ContentGroup record to which the record is associated. Required. |
CreatedByPlugin | 2.5 | Varchar2(100) | Name from Plugin table for assignments created |
DateDue | 1.0 | Date | The date this assignment is due. |
Description | 1.0 | Varchar2(4000) | A more detailed description of this assignment than the name. This is optional. |
ExtraCreditPoints | 1.6 | Number(10,0) | Number of extra points possible for an assignment. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
IsFinalScoreCalculated | 1.0 | Number(3,0) | 1 indicates scores for this assignment are included in final grade calculations. |
Name | 1.0 | Varchar2(50) | Name of the assignment, such as Essay, Homework, etc. Required. |
PointsPossible | 1.0 | Number(10,0) | Total possible points for this assignment that a student can earn. |
ScoringType | 1.0 | Number(10,0) | Indicates the scoring type used for the assignment, such as Points, Letter Grade, or Percent. |
Weight | 1.0 | Number(18,6) | The overall weight of this assignment. This, multiplied by PointsPossible, shows the actual points of this assignment for the total possible points for this section. |
WhenCreated | 2.5 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 2.5 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 2.5 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 2.5 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |