PSRW_IncidentParticipantObject (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.

Created_By

String30

[From Incident_Object_Person] The username of the session that created the record.

Created_TS

Date

[From Incident_Object_Person] The date and time when this record was created.

ID

Longint

[From Incident_Object_Person.Incident_Object_Person_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_Object_Person] 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.

Last_Modified_By

String30

[From Incident_Object_Person] The username of the session that last updated the record.

Last_Modified_TS

Date

[From Incident_Object_Person] The date and time when this record was last updated.

Long_Desc

String256

[From Incident_LU_Sub_Code] 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.

Object_Desc

String2048

[From Incident_Object] The description of the object.

Object_Quantity

Longint

[From Incident_Object] The number of this particular object.

Short_Desc

String80

[From Incident_LU_Sub_Code] 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

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

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.