AssignmentSection (ver10.0.0)
This table identifies sections that are associated to an assignment. Typically, there will only be one section associated to an assignment. It is possible to have multiple sections associated to the same assignment, in which case one row appears for each section associated to an assignment. The properties of an assignment can be changed for each section.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated Assignment.ID record. Required. Indexed. |
AssignmentSectionID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
Description | 10.0.0 | Varchar2(4000) | The description of the assignment. |
DueDate | 10.0.0 | Date | The date the assignment is due. Defaults to Default is the system date + 1 day. Indexed. |
ExtraCreditPoints | 10.0.0 | Number(18,6) | Indicates the number of extra credit points available for this assignment. |
IsCountedInFinalGrade | 10.0.0 | Number(1,0) | Indicates if the assignment will count toward the final grade. Valid values: 0=Does not count toward final grade, 1=Counts toward final grade. Defaults to 1. Required. |
IsScoresPublish | 10.0.0 | Number(1,0) | Flag to indicate if the assignment score, percent earned, and letter grade are published. Valid values: 0=Do not publish, 1=Publish. Defaults to 1. Required. |
IsScoringNeeded | 10.0.0 | Number(1,0) | Indicates if this assignment needs to be scored. Valid values: 0=False, 1=True. Defaults to 0. Required. |
MaxRetakeAllowed | 10.0.0 | Number(6,0) | Indicates the maximum number of retakes allowed for an assignment. Valid values: 0=No retakes are allowed for this assignment, Any Number Greater Than 0=Allows that number of retakes, 99=An unlimited number of retakes are allowed. Defaults to 0. |
Name | 10.0.0 | Varchar2(50) | Name of the assignment, such as Essay, Homework, etc. Required. Indexed. |
PublishDaysBeforeDue | 10.0.0 | Number(3,0) | Indicates the number of days before the assignment due date that the assignment will be published. Defaults to 0. |
PublishOnSpecificDate | 10.0.0 | Date | Indicates the specific date on which the assignment will be published. Default is the system date. |
PublishOption | 10.0.0 | Varchar2(30) | Indicates when the assignment is available to view in the PowerSchool Student and Parent portal, and in PowerSchool Mobile. Valid values: Immediately, OnSpecificDate, DaysBeforeDue, OnDueDate, Never. Defaults to Immediately. Required. |
PublishedDate | 10.0.0 | Date | Indicated the date the assignment was published. Default is the system date. |
PublishedScoreTypeID | 10.0.0 | Number(16,0) | Indicates if the scores appear on the PowerSchool Student and Parent portal, and in PowerSchool Mobile. This is separate from the assignments publish status. For example, an assignment may be published, but the teacher does not want the score to appear to parents or students. |
RelatedGrade ScaleItemDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated Assignment AssignmentID record. Ties the assignment to a grade scale. It will only be set if the grade scale used for the AssignmentSection is not the section's main grade scale. Indexed. |
ScoreEntryPoints | 10.0.0 | Number(18,6) | Identifies the score entered for this assignment. Required. |
ScoreType | 10.0.0 | Varchar2(30) | Indicates if this score is a letter grade or percent. |
SectionsDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated sections.DCID record. Required. Indexed. |
TotalPointValue | 10.0.0 | Number(18,6) | This is the total weighted points that the assignment is worth. If the entry points are 25, and the weight is 4, then the total point value is 100. |
Weight | 10.0.0 | Number(18,6) | The overall weight of this assignment. This value multiplied by Points Possible shows the actual points of this assignment for total possible points for this section. Defaults to 1. |
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. |