Skip to main content
Skip table of contents

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 NameInitial VersionData TypeDescription

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.