PSM_SectionStandardCalc (ver2.0)
This table contains information used to store current and historical standard data used to calculate scores.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 2.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
TopLevelType | 2.3 | Number(10,0) | Valid values: 0 = Mean, 1 = Median, 2 = Mode, 3 = Highest |
CalculationType | 2.0 | Number(10,0) | Valid values: 0 = Mean, 1 = Median, 2 = Mode, 3 = Highest, 4 = Most recent, 5 = None. |
RecencySetup | 2.0 | Varchar2(256) | Comma delimited list of assignment weight values for the school or teacher gathered from the PSM_StandardRecentSetup records. |
ReportingTermID | 2.0 | Number(19,0) | The internal ID for the PSM_ ReportingTerm record to which the record is associated. Required. |
SectionID | 2.0 | Number(19,0) | The internal ID for the PSM_Section record to which the record is associated. Required. |
WhenCreated | 2.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 2.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 2.0 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 2.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. |