Assignment (ver10.0.0)
This table uniquely identifies an assignment. An assignment can be associated to multiple sections. This table provides the ability to identify the original assignment.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
CreatedByPlugin | 10.0.0 | Varchar2(100) | This field contains the Identifier value of the plugin if the plugin that created the assignment is a signed plugin. If not, it contains the ID of the plugin. |
HasStandards | 10.0.0 | Number(1,0) | Set to True when standards are associated to an assignment section. Valid values: 0=No standards associated with this section assignment. 1=Standards are associated. Defaults to 0. Required. |
StandardCalcDirection | 10.0.0 | Varchar2(30) | Defines assignment scores are rolled up to standards, or if standards are rolled up to assignment scores. Valid values: RollupAssignmentScoreToStandard, RollupStandardToAssignmentScore, NONE. Defaults to NONE. Required. |
StandardRollupMethod | 10.0.0 | Varchar2(30) | Defines the rollup method to use on a standard for an assignment section. Valid values: Metric, Weight, SumOfPoints, SumOfNumerics. Defaults to Null. |
StandardRollupMetric | 10.0.0 | Varchar2(30) | Defines the rollup metric to use on a standard for an assignment section. Valid values: Mean, Median, Mode, WeightedMean, Highest. Defaults to Null. |
StandardScoringMethod | 10.0.0 | Varchar2(30) | Defines the scoring method being used for this sections assignment. Valid values: GradeScale, AlternateScale, PointOrQuestion. |
UCUID | 11.0.0 | Varchar2(36) | Assignment identifier unique among all PowerSchool districts. For internal use with Unified Classroom only. |
WhenCreated | 10.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 10.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 10.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 10.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |
YearID | 10.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. |