AdvancedReports_Selection (ver 24.2.0.0)
This table contains the ids of selected students and/or staff for users running Advanced Reports.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ID | 24.2.0.0 | Number(19.0) | System generated unique key for this rrow Required. Indexed. |
SelectionId | 24.2.0.0 | Varchar(50) | A unique key associating this record to a group of rows in the same selection. Required. |
Source | 24.2.0.0 | Varchar(100) | Indicates to where this record is associated. Currently this will be either “STUDENT” or “STAFF” depnding on which table this record’s “SourceId” points to. Required. |
SourceId | 24.2.0.0 | Number(10,0) | The id from the source table for this selection element. Required. |
UserId | 24.2.0.0 | Number(19,0) | The internal id of the user associated with this selection. Required. |