StandardReportingTermWeight (ver10.0.0)
This table contains a list of reporting terms and their respective weights for each course/standard association, as set by the district. This is used when calculating final grades and standards as part of the final grade calculation.
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. Required. Indexed. |
StandardReportingTermWeightID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by the application. Required. Indexed. |
Weight | 10.0.0 | Number(10,4) | The weight associated with this reporting term and associated standard and course. 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. |