GradeScaleScoreCode (ver10.0.0)
This table contains the district score codes available for use.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Description | 10.0.0 | Varchar2(4000) | The description of the score code. Upon creation of a score code association with a GradeScaleItem record, the description of the grade scale item is copied here. A teacher created score code contains the description provided by the teacher. |
GradeScaleItemDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated GradeScaleItem.DCID record. Null if the record represents a score code created by the teacher. Required. Indexed. |
GradeScaleScoreCodeID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
IsAbsent | 10.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 | 10.0.0 | Number(1,0) | Indicates whether this assignment was turned in and collected. 1=Yes, 0=No. Defaults to 0. Required. |
IsExempt | 10.0.0 | Number(1,0) | Indicates if this score code is exempt from being included in the final grade. The value 0 indicates the grades that use this grade label are used for calculating points for the section. The value 1 indicates the grades using this grade label are not used for computing points for the section. Defaults to 0. Required. |
IsInComplete | 10.0.0 | Number(1,0) | Indicates whether this assignment is incomplete. Valid values: 0, 1. 0=Complete, 1=Incomplete. Defaults to 0. Required. |
IsLate | 10.0.0 | Number(1,0) | Indicates the assignment is late. Valid values: 0, 1. 0=Not late, 1=Late. Defaults to 0. Required. |
IsMissing | 10.0.0 | Number(1,0) | Indicates the assignment is missing. Valid values: 0, 1. 0=Not missing, 1=Missing. Defaults to 0. Required. |
Name | 10.0.0 | Varchar2(30) | The name of the score code. Upon creation of a score code association with a GradeScaleItem record, the name of the grade scale item is copied here. A teacher created score code contains the name provided by the teacher. Required. |
NumericType | 10.0.0 | Varchar2(30) | Indicates the numeric type for a score code, such as Min, Max, or Custom. Valid values: Max, Min, Custom. |
NumericValue | 10.0.0 | Number(10,0) | Indicates the numeric value assigned to this grade label for this teacher. Applies to standards that use a points scale. |
PercentValue | 10.0.0 | Number(18,6) | The percent value assigned to this grade label for this teacher. |
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. |