AssignmentScoreComment (ver10.0.0)
This table identifies assignment comments entered for a student in a section. When an assignmentScore has an assignmentScoreComment record and does not have any retakes, then the AssignmentRetakeScoreID will be null in the AssignmentScoreComment record. When an AssignmentRetakeScore record is created, the comment record receives the AssignmentRetakeScoreID of the new AssignmentRetakeScore record that is created for the Original AssignmentScore. That way, the comment stays with the original AssignmentScore. Another new AssignmentRetakeScore record is created to record the details of of the Assignment Retake Score. The details of the retake will also be written to the AssignmentScore record.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentRetakeScoreID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated AssignmentRetakeScore and AssignmentRetakeScoreID record. Indexed. |
AssignmentScoreCommentID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
AssignmentScoreID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated AssignmentScore.AssignmentScoreID record. Required. Indexed. |
CommentValue | 10.0.0 | Varchar2(4000) | The written comment made on an assignment score for a student. Required. |
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. |