PSM_CategoryMetaAttributes (ver1.0)
This table contains additional attributes of categories a teacher has entered to classify their assignments, such as color code.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentCategoryID | 1.0 | Number(19,0) | Internal ID for the PSM_AssignmentCategory record to which the record is associated. Required. |
ColorCode | 1.0 | Number(10,0) | The color for the category. Valid values: 0 = None, 1 = Black, 2 = Red, 3 = Violet, 4 = Blue, 5 = Green, 6 = Olive, 7 = Orange. |
PublishState | 2.3 | Number(10,0) | Indicates the default publishing preference selected by the teacher for an assignment in this category. Valid values: 0 = Immediately, 1 = On Specified Date, 2 = X Days Before the Due Date, 3 = On Due Date, 4 = Never. |
PublishonSpecificDate | 2.3 | Date | Indicates the default specific date that assignments will be published for assignments created in this category. |
PublishDaysBe foreDue | 2.3 | Number(10,0) | Indicates the default for assignments created in this category of days before the due date the assignment will be published. |
PublishScores | 2.3 | Number(3,0) | Indicates the default for assignments created in this category to indicate if the assignment score, percent earned, and letter grade are published. Valid values: 0 = Do not publish, 1 = Publish. |
PushAssignmentScores | 2.3 | Number(3,0) | Push the assignment scores default for assignments created in this category: 0 = Do not push scores, 1= push scores. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |