DistrictTeacherCategory (ver10.0.0)
This table contains all of the categories defined by the district. Categories are then associated for use in specific schools using the CategorySchoolAssoc table.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Color | 10.0.0 | Varchar2(30) | Indicates the color displayed for the assignment. Valid values: Red, Yellow, Blue, Orange, Purple, Green, etc... Required. |
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. |
DefaultScoreEntryPoints | 10.0.0 | Number(18,6) | The default score entry points for this category. |
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 user interface. Defaults to 9999. Required. |
DistrictTeacherCategoryID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
IsActive | 10.0.0 | Number(1,0) | Indicates if the assignment is active. Valid values: 1=Yes=Active, 0=No=Disabled. Defaults to 1. Required. |
IsDefaultPublishScores | 10.0.0 | Number(1,0) | Indicates the default behavior for publishing scores for this category. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
IsInFinalGrades | 10.0.0 | Number(1,0) | Indicates if the assignment is included in the final grade. Valid values: 1=Yes, 0=No. Defaults to 1. Required. |
IsUserModifiable | 10.0.0 | Number(1,0) | Indicates if the assignment record is modifiable by the user. Valid values: 1=Yes, 0=No. Defaults to 1. Required. |
Name | 10.0.0 | Varchar2(30) | The unique name of the category. Required. |
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. |