StandardCourseLowerWeight (ver10.0.0)
If standards for a particular course are configured to be automatically calculated form lower-level standards using a custom weighting method (as opposed to mean, median, mode, etc.), the records in this table include the weight for each of those lower-level standards. These weights are used to calculate the higher level standards grade for a specific course and store code based on the grade for the lower level standards.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ReportingTermStoreCode | 10.0.0 | Varchar2(8) | The reporting term store code, originating from the Termbins.StoreCode field, is retained here for any course standard with specific weighting assigned. If the value is NULL, then the weight value is considered the default value to be used when the current section reporting term is not listed for the course and standard that the record is associated with. |
StandardCourseAssocID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated StandardCourseAssoc.StandardCourseAssocID record. This column is treated as the parent column by the application, rather than the StandardId column. Required. Indexed. |
StandardCourseLowerWeightID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
StandardID | 10.0.0 | Number(16,0) | Foreign key. Internal number for the associated Standard.StandardID record. Required. Indexed. |
Weight | 10.0.0 | Number(10,4) | The weight associated to the grading element. Required. |
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. |