StandardScore (ver10.0.0)
This table tracks standards scores for a student by assignment. Comments associated with the Assignment Score record, whether there are retakes or not, will have a NULL value in the StandardRetakeScoreID field of the StandardScoreComment field. Properties related to the score are also stored in this table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ActualScoreEntered | 10.0.0 | Varchar2(30) | Identifies the actual score entered for this assignment. This field may be null. |
ActualScoreGradeScaleDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated Actual GradeScaleItem.DCID record. Indexed. |
ActualScoreKind | 10.0.0 | Varchar2(30) | Indicates the type of score that was entered for this assignment score. |
AltAlphaGrade | 10.0.0 | Varchar2(30) | The alternate grade in an alpha form. Either AltNumericGrade or AltAlphaGrade is populated. Both fields cannot be populated. |
AltNumericGrade | 10.0.0 | Number(18,6) | The alternate grade in an numeric form. Either AltNumericGrade or AltAlphaGrade is populated. Both fields cannot be populated. |
AltScoreGradeScaleDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated Alternate GradeScaleItem.DCID record. Indexed. |
AssignmentSectionID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated AssignmentSection.AssignmentSectionID record. Required. Indexed. |
AssignmentStandardAssocID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated AssignmentStandardAssoc.AssignmentStandardAssocID record. Required. Indexed. |
HasRetake | 10.0.0 | Number(1,0) | This assignment score has an associated StandardScoreRetake record or records. Valid values: 0=No retakes, 1=Assignment retake records exist. |
IsAbsent | 10.0.0 | Number(1,0) | Indicates the student was absent on the due date. Valid values: 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. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
IsExempt | 10.0.0 | Number(1,0) | Indicates whether this assignment is exempt. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
IsIncomplete | 10.0.0 | Number(1,0) | Indicates whether this assignment is incomplete. Valid values: 0=Complete, 1=Incomplete. Defaults to 0. Required. |
IsLate | 10.0.0 | Number(1,0) | Indicates whether this assignment was turned in late. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
IsMissing | 10.0.0 | Number(1,0) | Indicates whether this assignment is missing. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
ScoreEntryDate | 10.0.0 | Timestamp(6) | The date the score was entered. Required. |
ScoreGradeScaleDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the section or student GradeScaleItem DCID record. Indexed. |
ScoreLetterGrade | 10.0.0 | Varchar2(30) | Identifies the letter grade given to this assignment. |
ScoreNumericGrade | 10.0.0 | Number(18,6) | Identifies the numeric grade given to this assignment. |
ScorePercent | 10.0.0 | Number(18,6) | Indicates the score as a percent. |
ScorePoints | 10.0.0 | Number(18,6) | Indicates the number of points for a score. |
StandardScoreID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
StudentsDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated students.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. |
YearID | 10.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Indexed. |