PSRW_IncidentLUCodeAndSubcode (ver6.1.0)

Application_Display_Order

Longint

[From Incident_LU_Code] A user defined value that determines the order in which codes are displayed on the user interface.

Code_Type

String50

[From Incident_LU_Code] 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

String30

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

Created_TS

Dat e

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

Incident_Category

String50

[From Incident_LU_Code] 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", and "Outside School Hours".

For Code_Type="behaviorcode" you may have one or more of the following Incident_Category values: "Alcohol", "Arson", and "Battery".

Is_Police_Reportable_Flg

Integer

[From Incident_LU_Sub_Code] Used to indicate whether the incident is police reportable, or not. Valid values are (1=true, 0=false). Default value = 0.

Is_State_Reportable_Flg

Integer

[From Incident_LU_Sub_Code] Used to indicate whether the incident is state reportable, or not. Valid values are (1=true, 0=false). Default value = 0.

Last_Modified_By

String30

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

Last_Modified_TS

Dat e

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

Long_Desc

String256

[From Incident_LU_Sub_Code] A more detailed description.

LU_Code_ID

Longint

[From Incident_LU_Code] Unique sequential number generated by the application.

LU_Sub_Code_ID

Longint

[From Incident_LU_Sub_Code] Unique sequential number generated by the application. [From Incident_LU_Sub_Code]

Severity

Real

[From Incident_LU_Sub_Code] Used to indicate the weight or severity of the incident. Expanded to use up to 2 decimal places.

Short_Desc

String80

[From Incident_LU_Sub_Code] A short description.

State_Aggregate_Rpt_Code

String20

[From Incident_LU_Code] A user defined value used for aggregated reporting

Sub_Category

String50

[From Incident_LU_Sub_Code] The value in the Sub_Category directly relates to the value in the Incident_Category in the Incident_LU_Code table; for example:

For Code_Type="timecode" you may have one or more of the following Incident_Category values: "During School Hours", "In Transit", and "Outside School Hours". And, you may have one or more of the following Sub_Category values: "Before Classes", "During Class", "Between Classes", and "After Classes".

For Code_Type="behaviorcode" you may have one or more of the following Incident_Category values: "Alcohol", "Arson", and "Battery". And, you may have one or more of the following Sub_Category values: "Possession of Alcohol", "Use of Alcohol", "Sale of Alcohol", "Setting a fire", "Physically attacking", "Intentionally causing bodily harm".