Skip to main content
Skip table of contents

PSRW_IncidentParticipant (ver6.1.0)

This view provides information on Incident Participant.

Column NameInitial VersionData TypeDescription

Age

6.1.0

Real

[From Incident_Other_Person] The participant age. This is null for students and teachers.

Created_By

6.1.0

String30

[From Incident_Object] The username of the session that created the record.

Created_TS

6.1.0

Date

[From Incident_Object] The date and time when this record was created.

DOB

6.1.0

Date

[From Students or Teachers] The participant date of birth. This is null for other participants.

First_Name

6.1.0

String30

[From Students or Teachers or Incident_Other_Person] The participant first name.

Gender

6.1.0

String10

[From Students or Teachers or Incident_Other_Person] The participant gender.

Grade_Level

6.1.0

Real

[From Students.Grade_Level] Grade Level for participant with type 'Students'. This is null for participants with type 'Others' or 'Teachers'.

ID

6.1.0

Longint

[From Incident_Detail.Incident_Detail_ID] Unique sequential number generated by the application.

Incident_ID

6.1.0

Longint

[From Incident_Detail] Internal ID for the Incident record to which the record is associated.

Last_Modified_By

6.1.0

String30

[From Incident_Object] The username of the session that last updated the record.

Last_Modified_TS

6.1.0

Date

[From Incident_Object] The date and time when this record was last updated.

Last_Name

6.1.0

String30

[From Students or Teachers or Incident_Other_Person] The participant last name.

Middle_Name

6.1.0

String30

[From Students or Teachers or Incident_Other_Person] The participant middle name.

Participant_Number

6.1.0

String21

[From Students.Student_Number or Teachers.TeacherNumber or Incident_Other_Person.Incident_Other_Person_ID] The participant unique number.

Participant_Title

6.1.0

String40

[From Incident_Other_Person.Position] Any known information regarding the position of this other person.

Participant_Type

6.1.0

String8

The participant type, which can be only one of the following: Students, Teachers, Others.

Role_Code

6.1.0

String50

[From Incident_LU_Sub_Code] The participant role code.

Role_Subcode

6.1.0

String50

[From Incident_LU_Sub_Code] The participant role subcode.

School_Name

6.1.0

String60

[From Schools] School Name of the school associated with the participant. This is null for participants with type 'Others'.

SchoolID

6.1.0

Real

[From Students.SchoolID or Teachers.SchoolID] School ID of the school associated with the participant. This is null for participants with type 'Others'.

Unknown_Indicator

6.1.0

Real

[From Incident_Other_Person.Is_Unknown] Used to indicate whether the person is known or unknown.

JavaScript errors detected

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

If this problem persists, please contact our support.