Incident (ver5.2.0)
This table is the focus of the incident report. It is the parent table of all supporting tables related to the incident.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Created_By | 5.2.0 | Varchar2(30) | The username of the session that created the record. |
Created_TS | 5.2.0 | Timestamp(6) | The date and time when this record was created. |
Entry_Author | 5.2.0 | Varchar2(305) | The person who made the initial entry of the incident. The recorder of the incident. Manually entered by the person entering the incident. |
Financial_Impact | 5.2.0 | Number(10) | The overall financial impact. |
Incident_Detail_Desc | 5.2.0 | CLOB(2048) | A detailed description of the incident. |
Incident_ID | 5.2.0 | Number(10) | Unique sequential number generated by the application. |
Incident_Reference_Value | 5.2.0 | Varchar2(30) | User-defined incident number. |
Incident_Title | 5.2.0 | Varchar2(80) | A short description of the incident. |
Incident_TS | 5.2.0 | Timestamp(6) | The date the incident occurred. |
| IsTeacherReferral | 20.4.0 | Number(1) | This indicates that the incident is a teacher referral. Valid values: 0=No, 1=Yes. Defaults to 0. |
Last_Modified_By | 5.2.0 | Varchar2(30) | The username of the session that last updated the record. |
Last_Modified_TS | 5.2.0 | Timestamp(6) | The date and time when this record was last updated. |
Location_Details | 6.0.1 | Varchar2(256) | Additional comments or notes about the location of the incident. |
PSGUID | 7.8.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
School_Number | 5.2.0 | Number(10) | The school number of where the incident occurred. If the School_Number field is Null, then the incident is a district incident. |