PSM_FinalScore (ver1.0)
This table contains students' final grades as entered in PowerTeacher gradebook.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ActualScoreEntered | 1.0 | Varchar2(30) | The last value entered when manually overriding a grade. For example, if the user enters letter grade of 'A' and then a '100', the '100' is stored. Then, it they go back and change the 'A' to a 'B', the 'B' is stored. |
CommentCode | 1.0 | Varchar2(30) | Any comment teacher added for this final grade. |
CommentValue | 1.0 | Varchar2(4000) | Any comment teacher added for this final grade. Note: Comment renamed CommentValue (ver1.5). |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
LastUpdated | 1.5 | Timestamp | Row update date. |
LetterGrade | 1.0 | Varchar2(10) | The letter grade received for the reporting term. A letter grade is stored regardless of whether the final score is manually overridden. The letter grade will be either the calculated final grade or the grade entered by the teacher if they manually override the calculated grade. |
ManualOverride | 1.0 | Number(3,0) | Used to indicate if a calculated final grade has been overridden. |
PointsEarned | 1.0 | Number(18,6) | The total points earned for a reporting term final grade. Used for final grades when Total Points based weighting is used. |
PointsPossible | 1.0 | Number(18,6) | The total points possible for a reporting term final grade. Used for final grades when Total Points based weighting is used. |
PotentialVarCreditValue | 2.1 | Number(18,6) | In variable credit situations, potential credit value submitted by the teacher. Also known as attempted credit. |
OutOfDate | 1.0 | Number(3,0) | Indicates whether a final score is out of date and needs to be recalculated. |
ReportingTermID | 1.0 | Number(19,0) | Internal ID for the PSM_ReportingTerm record to which the record is associated. Required. |
Score | 1.0 | Number(18,6) | The percentage points that were received by the student for this section. |
SectionEnrollmenttID | 1.0 | Number(19,0) | Internal ID for the PSM_SectionEnrollment record to which the record is associated. Required. |
VariableCreditValue | 2.1 | Number(18,6) | In variable credit situations, actual credit earned by the student awarded by the teacher. |