PSRW_ParticipantBehavior (ver6.1.0)

Application_Display_Order

Longint

[From Incident_LU_Code] A user defined value that determines the order in which codes are displayed on the user interface.

ID

Longint

[From Incident_Person_Detail.Incident_Person_Detail_ID] Unique sequential number generated by the application.

Incident_Category

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

Longint

[From Incident_Person_Detail] Internal ID for the Incident_Person_Role record to which the record is associated.

Is_Police_Reportable_Flg

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

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

String256

[From Incident_LU_Sub_Code.Long_Desc] A more detailed description.

Lookup_Code_Desc

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_Indicator

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

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

String80

[From Incident_LU_Sub_Code.Short_Desc] A short description.

State_Aggregate_Rpt_Code

String20

[From Incident_LU_Code] A user defined value used for aggregated reporting

State_Detail_Report_Code

String20

[From Incident_LU_Sub_Code] A user defined value used for detailed reports.

Sub_Application_Display_Order

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

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

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

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_Lookup_Code_Desc

String512

[From Incident_Detail.Lookup_Code_Desc] If a comment is enabled for a code/ subcode combination, then the comment entered by the user will be stored in this field.