Incident_Person_Role (ver5.2.0)
This table contains data used to identify the role that individual participants played. If a person played two roles in an incident (for example, was both an offender and a victim), they would have two rows in this table to allow for the actions related to each role to be recorded separately.
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. |
Incident_ID | 5.2.0 | Number(10) | Internal ID for the Incident record to which the record is associated. |
Incident_Other_Person_ID | 5.2.0 | Number(10) | Internal ID for the Incident_Other_Person record to which the record is associated. |
Incident_Person_Role_ID | 5.2.0 | Number(10) | Unique sequential number generated by the application. |
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. |
Person_Desc | 5.2.0 | Varchar2(2048) | Description of the person. |
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. |
Role_Incident_Detail_ID | 6.0.1 | Number(10) | The ID of an Incident_Detail record that defines the role played by a participant tied to the Incident. |
StudentID | 5.2.0 | Number(10) | The student id of a person involved in an incident. Will be NULL for "Staff" and "Other" participants. |
TeacherID | 5.2.0 | Number(10) | The internal identification number of the teacher in the associated SchoolStaff record. Will be NULL for "Students" and "Other" participants. |