Skip to main content
Skip table of contents

PSRW_IncidentTypeForUser (ver6.1.0)

This view provides a list of users with access to Incident Types based on the user's security group.

Column NameInitial VersionData TypeDescription

GroupID

6.1.0

Longint

[From Gen.ID] The security group ID.

Incident_Category

6.1.0

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".

Incident_Security
_Group_ID

6.1.0

Longint

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

Is_Police_Reportable_Flg

6.1.0

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

6.1.0

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.

Long_Desc

6.1.0

String256

[From Incident_LU_Sub_Code] A more detailed description.

LU_Code_ID

6.1.0

Longint

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

LU_Sub_Code_ID

6.1.0

Longint

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

Severity

6.1.0

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

6.1.0

String80

[From Incident_LU_Sub_Code] A short description.

State_Aggregate_Rpt_Code

6.1.0

String20

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

Sub_Category

6.1.0

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".

UserID

6.1.0

Longint

[From Teachers.ID] The teacher/user ID.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.