PSM_GradingFormulaWeighting (ver1.0)
This table contains the weighting used in the grade setup for each reporting term in a teacher's section in PowerTeacher gradebook.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentCategoryID | 1.0 | Number(19,0) | If category-based weighting is used, the internal ID of the PSM_AssignmentCategory record selected by the teacher. |
AssignmentID | 1.0 | Number(19,0) | If an assignment is selected to be included in the grading formula, the internal ID of the PSM_Assignment record. |
GradingFormulaWeightingType | 1.0 | Varchar2(255) | Indicated type of weighting used for the grading formula (term based weighting, category based weighting, or assignment based weighting). Required. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
LowScoresToDiscard | 1.0 | Number(10,0) | The number of low scores to discard as entered by the teacher. |
ParentGradingFormulaID | 1.0 | Number(19,0) | The internal ID of the PSM_GradingFormula record to which the record is associated. Applies only to term based weighting. Required. |
ReportCardItemID | 2.7 | Number(19,0) | The internal ID of the PSM_ReportCardItem record to which the record is associated. Applicable only to standards. Indexed. |
ReportingTermID | 1.0 | Number(19,0) | The internal ID of the PSM_ReportingTerm record to which the record is associated. |
Weighting | 1.0 | Number(18,6) | Weight as entered by the teacher. Required. |