WebAsmt, 124 (ver3.6.1)
Assignments that have been created on the Web site and that can subsequently be transferred to PowerGrade. Once uploaded, these are deleted.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbrev | 3.6.1 | Varchar(15) | A shorter version of the name of this assignment for quick reference. This is required. |
CategoryID | 3.6.1 | Number(10,0) | The internal number for the PGCategories with which this record is associated. This is used to determine which category abbreviation to send. If there is no category assigned, send one called Unassigned. This is required. |
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. |
DistCategory | 3.6.1 | Varchar(60) | Currently this hold DIST if this is district category but was meant to as the District Category ID from GEN tables for category DISTWEBCAT. If this is a district-created assignment, uses the district category list. |
DistCourse Number | 3.6.1 | Varchar(20) | District Course number. Mostly used as a Mass Teacher setup of assignments. |
DueDate | 3.6.1 | Date | The date this assignment is due. The date entered is validated. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Name | 3.6.1 | Varchar(50) | Name of the assignment such as Essay or Homework. |
PtsPoss | 3.6.1 | Number(10,0) | Total possible points for this assignment that a student can earn. |
Scores | 3.6.1 | BLOB | This BLOB field maintains a key-pair value of students and the score they received for this assignment. Student IDs are prefixed with sc. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections record. |
Standard | 3.6.1 | CLOB | Comma-delimited list of standard identifiers. See Identifier in Standards table. |
Transferred | 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. |