PSRW_Incident (ver6.1.0)
This view provides information about the Incident table with some additional school-related information.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Created_By | 6.1.0 | String30 | [From Incident] The username of the session that created the record. |
Created_TS | 6.1.0 | Date | [From Incident] The date and time when this record was created. |
Entry_Author | 6.1.0 | String50 | [From Incident] 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 | 6.1.0 | Longint | [From Incident] The overall financial impact. |
Incident_Detail_Desc | 6.1.0 | Clob | [From Incident] A detailed description of the incident. |
Incident_ID | 6.1.0 | Longint | [From Incident] Unique sequential number generated by the application. |
Incident_Reference_Value | 6.1.0 | String30 | [From Incident] User defined incident number. |
Incident_Title | 6.1.0 | String80 | [From Incident] A short description of the incident. |
Incident_TS | 6.1.0 | Date | [From Incident] The date the incident occurred. |
Last_Modified_By | 6.1.0 | String30 | [From Incident] The username of the session that last updated the record. |
Last_Modified_TS | 6.1.0 | Date | [From Incident] The date and time when this record was last updated. |
Location_Details | 6.1.0 | String256 | [From Incident] Additional comments or notes about the location of the incident. |
School_Name | 6.1.0 | String60 | [From Schools] Name for the school. "District Office" if the incident is associated with the District. |
School_Number | 6.1.0 | Longint | [From Schools] Unique identifier for the school. 0 if the incident is associated with the District. |