Incident_Detail (ver5.2.0)
This table contains the details of an 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. |
Incident_Detail_ID | 5.2.0 | Number(10) | Unique sequential number generated by the application. |
Incident_ID | 5.2.0 | Number(10) | Internal ID for the Incident record to which the record is associated. |
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. |
Lookup_Code_Desc | 6.0.1 | Varchar2(512) | If a comment is enabled for a code/subcode combination, then the comment entered by the user will be stored in this field. |
LU_Code_ID | 5.2.0 | Number(10) | Internal ID for the Incident_LU_Code record to which the record is associated. |
LU_Sub_Code_ID | 5.2.0 | Number(10) | Internal ID for the Incident_LU_Sub_Code record to which the record is associated. |
Primary_Indicator | 6.0.1 | Varchar2(30) | The field to indicate that this behavior is the primary behavior of the incident. The value in the field will be "primary" if it is the primary behavior of the incident. Defaults to blank. |
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. |