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 Name | Initial Version | Data Type | Description |
|---|---|---|---|
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 | 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. |