TeacherCategory (ver10.0.0)
This table contains all categories used by a teacher to classify their assignments.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CategoryType | 10.0.0 | Varchar2(30) | The type of category, such as Homework, Project, etc. Valid values: user, district. Required. |
Color | 10.0.0 | Varchar2(30) | The color assigned to the category for display purposes. Valid values: Red, Yellow, Blue, Orange, Purple, Green, etc... |
DefaultDaysBeforeDue | 10.1.0 | Number(3,0) | The default days before due. |
DefaultExtraCreditPoints | 10.0.0 | Number(18,6) | The default extra credit points for this category. |
DefaultPublishOption | 10.0.0 | Varchar2(30) | The default publish option for this category. |
DefaultPublishState | 10.0.0 | Varchar2(30) | The default publish state for this category. |
DefaultScoreEntry Points | 10.0.0 | Number(18,6) | The default score entry points. |
DefaultScoreType | 10.0.0 | Varchar2(30) | The default score type for this category. |
DefaultTotalValue | 10.0.0 | Number(18,6) | The default total value for this category. |
DefaultWeight | 10.0.0 | Number(18,6) | The default weight for this category. |
Description | 10.0.0 | Varchar2(4000) | The description of the category. |
DisplayPosition | 10.0.0 | Number(6,0) | Persists a value to maintain the desired display position in the application. Required. |
DistrictTeacherCategoryID | 10.0.0 | Number(16,0) | Foreign key. The ID of a district category that has been related to the teacher category record. Internal number for the associated DistrictTeacherCategory.DistrictTeacherCategoryID record. Indexed. |
IsActive | 10.0.0 | Number(1,0) | Indicates if the category is active for use by the teacher. Valid values: 1=Yes=Active, 0=No=Disabled. Defaults to 1. Required. |
IsDefaultPublishScores | 10.0.0 | Number(1,0) | Indicates if the scores are published by default. Valid values: 1=Yes, 0=No. Defaults to 1. Required. |
IsInFinalGrades | 10.0.0 | Number(1,0) | Indicates if this record should be included in the final grade. Valid values: 1=Yes, 0=No. Defaults to 1. Required. |
IsUserModifiable | 10.0.0 | Number(1,0) | Indicates if this record can be modified by the teacher. Valid values: 1=Yes, 0=No. Defaults to 1. Required. |
Name | 10.0.0 | Varchar2(30) | The name of the category. |
TeacherCategoryID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by PowerSchool. Required. Indexed. |
TeacherModified | 10.0.0 | Number(1,0) | Indicates if the teacher modified the record. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
UsersDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated user DCID record. Required. Indexed. |
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. |