TeacherNote (ver21.4.0)
This table stores teacher observations or incidents tied to a student.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| DateTime | 21.4.0 | Timestamp | The date and time the incident or teacher observation took place. |
| Description | 21.4.0 | Varchar(4000) | Full description of the incident or teacher observation. |
| EscalatedDate | 21.4.0 | Timestamp | The date and time that the teacher observation was escalated and an incident was created. |
| GroupIdentifier | 21.4.0 | Varchar(32) | A unique identifier used to group observations. Currently not used. |
| ID | 21.4.0 | Number(16) | The unique sequential number generated by the application. Indexed. Required. |
| IncidentID | 21.4.0 | Number(16) | Foreign key to Incident.Incident_Id column. Indexed. |
| Location | 21.4.0 | Varchar(36) | The location of the incident or teacher observation. |
| SectionsDCID | 21.4.0 | Number(16) | Foreign key to Sections.DCID column. Indexed. Currently not used. |
| StudentsDCID | 21.4.0 | Number(16) | Foreign key to Students.DCID column. Indexed. Required. |
| Title | 21.4.0 | Varchar(36) | Title of the incident or teacher observation. |
| UsersDCID | 21.4.0 | Number(16) | Foreign key to Users.DCID column. Indexed. Required. |
| WhenCreated | 21.4.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 21.4.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 21.4.0 | Varchar(100) | The name of the person who created the record. Defaults to user. Required. |
| WhoModifed | 21.4.0 | Varchar(100) | The name of the person who modified the record. Defaults to the user. Required. |