PSM_AssignmentStandardScore (ver2.0)
This table contains scores and related information for standards as applied to an assignment.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ActualScoreEntered | 2.0 | Varchar2(30) | The actual score entered by the teacher for this assignment. This may be points, percent, or a letter grade depending on the score type for the assignment. |
AssignmentStandardID | 2.0 | Number(19,0) | Internal ID for the PSM_AssignmentStandard record to which the record is associated. Required. |
Exempt | 2.0 | Number(3,0) | 1 indicates the student score for the assignment standard is exempt from final grade calculation. |
ID | 2.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
IsMissing | 2.0 | Number(3,0) | 1 indicates the assignment standard score is missing, such as there is no record of the student completing and submitting the assignment. |
Score | 2.0 | Number(18,6) | The points earned for the assignment. |
ScoreType | 2.2 | Number(3,0) | 0 indicates PSM_Grade labels are used. 1 indicates teacher-specific grade label. 2 indicates exempt teacher specific grade label. Labels for types 1 and 2 are found in the PSM_TeacherCode table. |
SectionEnrollmentID | 2.0 | Number(19,0) | Internal ID for the PSM_SectionEnrollment record to which the record is associated. Required. |
TurnedIn | 2.0 | Number(3,0) | 1 indicates the teacher collected the assignment standard from the student. |
TurnedInLate | 2.0 | Number(3,0) | 1 indicates the student turned in the assignment standard late. |
WhenCreated | 2.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 2.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 2.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 2.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |