PSRW_IncidentLocation (ver6.1.0)
This view provides information on Incident Location.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Code_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_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_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. |
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. |
State_Aggregate_Rpt_Code | 6.1.0 | String20 | [From Incident_LU_Code] A user defined value used for aggregated reporting.[From Incident_LU_Code] |
State_Detail_Re port_Code | 6.1.0 | String20 | [From Incident_LU_Sub_Code] A user defined value used for detailed reports. |
Code_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_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_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. |
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. |
State_Aggregate_Rpt_Code | 6.1.0 | String20 | [From Incident_LU_Code] A user defined value used for aggregated reporting.[From Incident_LU_Code] |
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 | 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. |