Skip to main content
Skip table of contents

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(50)

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.

IsTeacherReferral20.4.0Number(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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.