TeacherScoreCode (ver9.0.0)
Contains the teacher and district score codes available for use.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Description | 9.0.0 | Varchar2(4000) | The description of the score code. Upon creation of a score code is association with a GradeScaleItem record, the description of Grade Scale Item will be copied here. A teacher created Score Code, will contain the description given by the teacher. |
IsAbsent | 9.0.0 | Number(1,0) | Indicates the student was absent on the due date. Valid values: 0, 1. 0=Not absent, 1=absent. Defaults to 0. Required. |
IsCollected | 9.0.0 | Number(1,0) | Indicates whether this assignment was turned in and collected. 1=Yes, 0=No. Defaults to 0. Required. |
IsExempt | 9.0.0 | Number(1,0) | Is this score code exempt from being included in the final grade. 0 indicates the grades using this grade label are used for computing points for the section. 1 indicates the grades using this grade label are not used for computing points for the section. Defaults to 0. Required. |
IsInComplete | 9.0.0 | Number(1,0) | Indicates whether this assignment is incomplete. Valid values: 0, 1. 0=Complete, 1=Incomplete. Defaults to 0. Required. |
IsLate | 9.0.0 | Number(1,0) | Indicates the assignment is late. Valid values: 0, 1. 0=Not late, 1=Late. Defaults to 0. Required. |
IsMissing | 9.0.0 | Number(1,0) | Indicates the assignment is missing. Valid values: 0, 1. 0=Not missing, 1=Missing. Defaults to 0. Required. |
Name | 9.0.0 | Varchar2(30) | The name of the score code. Upon creation of a score code is association with a GradeScaleItem record, the name of Grade Scale Item will be copied here. A teacher created Score Code, will contain the name given by the teacher. Required. Indexed. |
NumericType | 9.0.0 | Varchar2(30) | Indicates the numeric type for a score code, such as (Min, Max, or Custom). Max indicates use the maximum from the grade scale value, such as A. Min indicates use the minimum gradescale value, such as F. Custom indicates a custom value, NumericValue. Valid values: Max, Min, Custom. |
NumericValue | 9.0.0 | Number(10,0) | Indicates the numeric value assigned to this grade label for this teacher. Applies to standards using a points scale. |
PercentValue | 9.0.0 | Number(18,6) | The percent value assigned to this grade label for this teacher. |
TeacherScoreCodeId | 9.0.0 | Number(16,0) | Primary Key. Unique sequential number generated by the application. Required. Indexed. |
UsersDCID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated USERS record. Null if the record represents a score code created by the district. Indexed. |
WhenCreated | 9.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 9.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |