PSRW_IncidentBehavior (ver6.1.0)
This view provides information about Incident Behaviors.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
App_Display_ Order | 6.1.0 | Longint | [From Incident_LU_Code.Application_Display_Order] A user defined value that determines the order in which codes are displayed on the user interface. |
ID | 6.1.0 | Longint | [From Incident_Detail.Incident_Detail_ID] Unique sequential number generated by the application. |
Incident_Cate gory | 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". |
Incident_ID | 6.1.0 | Longint | [From Incident_Detail] Internal ID for the Incident record to which the record is associated. |
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_1 | 6.1.0 | String256 | [From Incident_LU_Sub_Code.Long_Desc] A more detailed description. |
Long_Desc_1 | 6.1.0 | String256 | [From Incident_LU_Sub_Code.Long_Desc] A more detailed description. |
Long_Desc_2 | 6.1.0 | String256 | [From Incident_LU_Sub_Code.Long_Desc] A more detailed description. |
Long_Desc_4 | 6.1.0 | String256 | [From Incident_LU_Sub_Code.Long_Desc] A more detailed description. |
Lookup_Code_Desc | 6.1.0 | String512 | [From Incident_Detail] If a comment is enabled for a code/subcode combination, then the comment entered by the user will be stored in this field. |
Primary_Indic ator | 6.1.0 | Integer | [From Incident_Detail] The field to indicate that this behavior is the primary behavior of the incident. The value in the field will be "primary" if it is the primary behavior of the incident. Default value is blank. |
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_1 | 6.1.0 | String80 | [From Incident_LU_Sub_Code.Short_Desc] A short description. |
Short_Desc_2 | 6.1.0 | String80 | [From Incident_LU_Sub_Code.Short_Desc] A short description. |
Short_Desc_3 | 6.1.0 | String80 | [From Incident_LU_Sub_Code.Short_Desc] A short description. |
Short_Desc_4 | 6.1.0 | String80 | [From Incident_LU_Sub_Code.Short_Desc] A short description. |
State_Aggregate_Rpt_Code | 6.1.0 | String20 | [From Incident_LU_Code] A user defined value used for aggregated reporting. |
State_Detail_ Report_Code | 6.1.0 | String20 | [From Incident_LU_Sub_Code] A user defined value used for detailed reports. |
Sub_App_Display_Order_1 | 6.1.0 | Longint | [From Incident_LU_Sub_Code.Application_Display_Order] A user defined value that determines the order in which codes are displayed on the user interface. |
Sub_App_Display_Order_2 | 6.1.0 | Longint | [From Incident_LU_Sub_Code.Application_Display_Order] A user defined value that determines the order in which codes are displayed on the user interface. |
Sub_App_Display_Order_3 | 6.1.0 | Longint | [From Incident_LU_Sub_Code.Application_Display_Order] A user defined value that determines the order in which codes are displayed on the user interface. |
Sub_App_Display_Order_4 | 6.1.0 | Longint | [From Incident_LU_Sub_Code.Application_Display_Order] A user defined value that determines the order in which codes are displayed on the user interface. |
Sub_Category_1 | 6.1.0 | String50 | [From Incident_LU_Sub_Code.Sub_Category] 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". |
Sub_Category_2 | 6.1.0 | String50 | [From Incident_LU_Sub_Code.Sub_Category] 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". |
Sub_Category_3 | 6.1.0 | String50 | [From Incident_LU_Sub_Code.Sub_Category] 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". |
Sub_Category_4 | 6.1.0 | String50 | [From Incident_LU_Sub_Code.Sub_Category] 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". |
Sub_Is_Police_Reportable_Flg_1 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_Police_Reportable_Flg] Used to indicate whether the incident is police reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |
Sub_Is_Police_Reportable_Flg_2 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_Police_Reportable_Flg] Used to indicate whether the incident is police reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |
Sub_Is_Police_Reportable_Flg_3 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_Police_Reportable_Flg] Used to indicate whether the incident is police reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |
Sub_Is_Police_Reportable_Flg_4 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_Police_Reportable_Flg] Used to indicate whether the incident is police reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |
Sub_Is_State_Reportable_Flg_1 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_State_Reportable_Flg] Used to indicate whether the incident is state reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |
Sub_Is_State_Reportable_Flg_2 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_State_Reportable_Flg] Used to indicate whether the incident is state reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |
Sub_Is_State_Reportable_Flg_3 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_State_Reportable_Flg] Used to indicate whether the incident is state reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |
Sub_Is_State_Reportable_Flg_4 | 6.1.0 | Integer | [From Incident_LU_Sub_Code.Is_State_Reportable_Flg] Used to indicate whether the incident is state reportable, or not. Valid values are (1=true, 0=false). Default value = 0. |