Incident_LU_Code (ver5.2.0)
This table contains the codes used to define the specific characteristics of the incident.
Column Name | Initial Version | Data Type | Description |
---|
Application_Display_Order | 5.2.0 | Number(10) | A user-defined value that determines the order in which codes are displayed on the user interface. |
Code_Type | 6.0.1 | Varchar2(50) | Valid values / Menu Option / Purpose: - "actionattribute" = "Action Attributes" = To define attributes of an incident action that are desirable to track. Such as, a Yes/No field, text field, number field, date field, or a select list.
- "actionchangecode" = "Action Change Codes" = To define valid reasons for changing an action that can be used for tracking purposes.
- "actioncode" = "Action Codes" = To define actions or consequences that are a result of an incident.
- "attributecode" = "Attribute Codes" = To define Incident Level attributes that are desirable to track. Such as, Bias related, Gang Related, On school transportation, or etc.
- "behaviorcode" = Behavior Codes" = To define behaviors that are to be tracked on an incident. Such as, Homicide, Kidnapping, or vandalism.
- "durationcode" = "Duration Codes" = To describe the unit of measure of time for the duration. Such as, During school hours, after school hours, etc.
- "incidenttypecode" = "Incident Types" = To define the current incident types supported by the district. Such as, Incident Management or equivalent name.
- "locationcode" = "Location Codes" = To define common locations, such as "On School Property".
- "objectcode" = "Object Codes" = To define various objects that could have been used in an incident and it is desirable to track that type of object. Such as, "Guns", "Knives" or "Bombs".
- "participantattributecode" = "Participant Attribute Codes" = To define personal attributes for a participant for a specific incident. Such as, a participant possessed a qualifying disability at the time of this incident, or this participant received an injury from this incident.
- "personcode" = "Participant Role Codes" = To define the roles a person could play in an incident. Such as "Offender", "Victim", "Witness", "Reporter".
- "timecode" = "Time Codes" = To define periods of time, such as "During School Hours".
|
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_Category | 5.2.0 | Varchar2(50) | You may have multiple Incident_Category values for a single Code_Type; for example: For Code_Type="timecode" you may have one or more of the following Incident_Category values: "during school hours", "in transit", "outside school hours". For Code_Type="behaviorcode" you may have one or more of the following Incident_Category values: "alcohol", "arson", "battery". |
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. |
LU_Code_ID | 5.2.0 | Number(10) | Unique sequential number generated by the application. |
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. |
State_Aggregate_Rpt_Code | 5.2.0 | Varchar2(20) | A user-defined value used for aggregated reporting. |