PSRW_IncidentActionChange (ver6.1.0)
This view provides information about Incident Action Changes.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 6.1.0 | Longint | [From Incident_Detail.Incident_Detail_ID] Unique sequential number generated by the application. |
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". |
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. |
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. |
State_Detail_Re port_Code | 6.1.0 | String20 | [From Incident_LU_Sub_Code] A user defined value used for detailed reports. |
Sub_Application_Display_Order | 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 | 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". |
Sub_Is_Police_Reportable_Flg | 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 | 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. |