PSRW_ParticipantBehActAttr (ver6.1.0)
This view provides information about Incident Participant Behavior Action Attributes.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Application_Display_Order | 6.1.0 | Longint | [From Incident_LU_Code] A user defined value that determines the order in which codes are displayed on the user interface. |
Datatype_Attribute | 6.1.0 | String30 | [From Incident_LU_Sub_Code] Value is used with a code_type of "actionattribute". Valid values of ('Text', 'Number', 'Date', 'Boolean', 'Select'). |
Date_Attribute | 6.1.0 | Date | [From Incident_Action_Attribute] Description of the changes made to the incident. |
ID | 6.1.0 | Longint | [From Incident_Action_Attribute.Incident_Action_Attribute_ID] Unique sequential number generated by the application. |
Incident_Action_ID | 6.1.0 | Longint | [From Incident_Action_Attribute] Internal ID for the Action record to which the record is associated. |
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". |
Is_Police_Reporta ble_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. |
Is_Yes1_No0_Attri bute | 6.1.0 | Integer | [From Incident_Action_Attribute] Description of the changes made to the incident. |
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. |
Number_Attribute | 6.1.0 | Real | [From Incident_Action_Attribute] Description of the changes made to the incident. |
Select_Attribute | 6.1.0 | String2000 | [From Incident_Action_Attribute.Text_Attribute] Description of the changes made to the incident. |
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_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". |
Text_Attribute | 6.1.0 | String2000 | [From Incident_Action_Attribute] Description of the changes made to the incident. |