AssignmentRetakeScore (ver10.0.0)
This table tracks student retake scores for an assignment. One record is created for every assignment retake score. When an assignmentScore has an assignmentScoreComment record, and does not contain retake scores, the AssignmentRetakeScoreID will be null in the AssignmentScoreComment record. When an AssignmentRetakeScore record is created, the comment record is assigned the AssignmentRetakeScoreID of the new AssignmentRetakeScore record that is created for the original AssignmentScore, assuring that the comment remains with the original AssignmentScore. Another new AssignmentRetakeScore record is created to capture the details of the Assignment Retake Score. The details of the retake will also be written to the AssignmentScore record. When additional retakes occur for an assignment, a new AssignmentRetakeScore record will be created, and the details of that score will update the existing AssignmentScore record as well. All of the attributes associated with the AssignmentScore remain with the AssignmentScore record and comments remain with the AssignmentRetakeScore record.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ActualScoreEntered | 10.0.0 | Varchar2(30) | Identifies the actual score entered for this assignment. Required. |
ActualScoreGradeScaleDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated grade scale record that represents the actual score. 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. |
AltNumericGrade | 10.0.0 | Number(18,6) | The alternate grade in an numeric form. |
AltScoreGradeScaleDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated grade scale record that represents the Alternate score. Indexed. |
AssignmentScoreID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated AssignmentScore.AssignmentScoreID record. Required. Indexed. |
DisplayPosition | 10.0.0 | Number(6,0) | Persists a value to maintain the desired display position of this assignment retake score in the user interface. |
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. |
ParentScoreRetakeId | 10.0.0 | Number(16,0) | Foreign key (self referencing). Internal number for the associated AssignmentRetakeScore.AssignmentRetakeScoreID record. Indexed. |
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 associated grade scale record that represents the Section or Student score. 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. |
StandardRetakeScoreID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated StandardRetakeScore.StandardRetakeScoreID record. 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. |