Incident_LU_Code (ver5.2.0)

Application_Display_Order

Number(10)

A user-defined value that determines the order in which codes are displayed on the user interface.

Code_Type

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

Varchar2(30)

The username of the session that created the record.

Created_TS

Timestamp(6)

The date and time when this record was created.

Incident_Category

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

Varchar2(30)

The username of the session that last updated the record.

Last_Modified_TS

Timestamp(6)

The date and time when this record was last updated.

LU_Code_ID

Number(10)

Unique sequential number generated by the application.

PSGUID

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

Varchar2(20)

A user-defined value used for aggregated reporting.