GradeCalcFormulaWeight (ver10.0.0)
Contains the specific weighting of items used in a calculation formula. One row represents each item weighted. For example: HW 50%, Tests 50%.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated Assignment AssignmentID record. Indexed. |
DistrictTeacherCategoryID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated DistrictTeacherCategory DistrictTeacherCategoryID record. This allows administrators be able to set up district category weights. Indexed. |
GradeCalcFormulaWeightID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
GradeCalculationTypeID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated GradeCalculationType GradeCalculationTypeID record. Required. Indexed. |
StndCalculationMetric | 10.0.0 | Varchar2(30) | Indicates how higher level standards are calculated. Valid values: Mean, Median, Mode, Highest, Specific_Weights, Specific_Sum, Null. Defaults to Null. |
StoreCode | 10.0.0 | Varchar2(10) | The code used to represent this grade level to term ID and school ID. |
TeacherCategoryID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated TeacherCategory TeacherCategoryID record. Indexed. |
Type | 10.0.0 | Varchar2(30) | The Type associated with one of the grading elements. Valid values: Total_Points, Term_Weighting, Standards_Weighting and Category_Weighting. Defaults to Total_Points. |
Weight | 10.0.0 | Number(10,4) | The weight associated with one of the grading elements. A numerical value which will be compared with other related rows to determine its actual percentage of the whole. Defaults to 1.0 |
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. |