PSM_SectionSpecField (ver2.3)
This table stores teacher-defined fields to be used to track section specific information about students such as preferred name or desk number. For each teacher, preferred name and personal note records will be available by default.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Description | 2.3 | Varchar2(100) | Description of the teacher defined field. |
FieldDataType | 2.3 | Number(3,0) | 0 indicates text data. |
FieldDisplayOrder | 2.3 | Number(3,0) | Number corresponding to the column number in which the fields are displayed in the student tab. |
FieldLabel | 2.3 | Varchar2(30) | Label displayed in the column header. Modifiable for SystemFieldType of 0. Required. |
ID | 2.3 | Number(19,0) | Unique sequential number generated by the application. Required. |
SectionID | 2.3 | Number(19,0) | The internal ID for the PSM_Section record to which the record is associated. Required. |
SystemFieldType | 2.3 | Number(3,0) | Valid values: 0 = extra class column, 1= student's preferred name, 2 = order in which the student is displayed in the scoresheet, 3 = teacher personal note. Required. |
WhenCreated | 2.3 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 2.3 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 2.3 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 2.3 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |