PSRW_IncidentParticipant (ver6.1.0)
This view provides information on Incident Participant.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
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. |