PSRW_IncidentParticipantAction (ver6.1.0)
This view provides information on Incident Participant Actions.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Action_Actual_Resolved_DT | 6.1.0 | Date | [From Incident_Action] The actual date the action ended. |
Action_Change_Reason | 6.1.0 | String256 | [From Incident_Action] A short description of why the duration of this action was changed. |
Action_Plan_Begin_DT | 6.1.0 | Date | [From Incident_Action] The date when an action began. |
Action_Plan_End_DT | 6.1.0 | Date | [From Incident_Action] The date when the action is expected to end. |
Action_Resolved_Desc | 6.1.0 | String256 | [From Incident_Action] Documentation of any details surrounding the resolution of the incident. |
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. |
Chng_Rsn_Incident_Detail_ID | 6.1.0 | Longint | [From Incident_Action] The ID of an Incident_Detail record that defines an Action Change Reason for the Incident_Action. This item will be used to look up a defined "Action Change Codes" that describes valid reasons for a change to the Incident Action. |
Created_By | 6.1.0 | String30 | [From Incident_Action] The username of the session that created the record. |
Created_TS | 6.1.0 | Date | [From Incident_Action] The date and time when this record was created. |
Duration_Actual | 6.1.0 | Real | [From Incident_Action] If a duration was changed, the actual duration. |
Duration_Assigned | 6.1.0 | Real | [From Incident_Action] The assigned duration for this incident action. |
Duration_Incident_Detail_ID | 6.1.0 | Longint | [From Incident_Action] The ID of an Incident_Detail record that defines the Duration for the Incident_Action. This item will be used to look up a defined "Duration Codes' that describes the unit of measure of time for the duration. |
Duration_Notes | 6.1.0 | String256 | [From Incident_Action] Comments regarding why the duration was changed. |
ID | 6.1.0 | Longint | [From Incident_Person_Action.Incident_Person_Action_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_Person_Role_ID | 6.1.0 | Longint | [From Incident_Person_Detail.Incident_Person_Role_ID] Internal ID for the Incident_Person_Role 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. |
Last_Modified_By | 6.1.0 | String30 | [From Incident_Action] The username of the session that last updated the record. |
Last_Modified_TS | 6.1.0 | Date | [From Incident_Action] The date and time when this record was last updated. |
Long_Desc | 6.1.0 | String256 | [From Incident_LU_Sub_Code] 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. |
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_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. |