PSRW_IncidentAction (ver6.1.0)

Action_Actual_Resolved_DT

Date

[From Incident_Action] The actual date the action ended.

Action_Change_Reason

String80

[From Incident_Action] A short description of why the duration of this action was changed.

Action_Plan_Begin_ DT

Date

[From Incident_Action] The date when an action began.

Action_Plan_End_DT

Date

[From Incident_Action] The date when the action is expected to end.

Action_Resolved_Desc

String256

[From Incident_Action] Documentation of any details surrounding the resolution of the incident.

App_Display_Order

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

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

String30

[From Incident_Action] The username of the session, which created the record.

Created_TS

Date

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

Duration_Actual

Real

[From Incident_Action] If a duration was changed, the actual duration.

Duration_Assigned

Real

[From Incident_Action] The assigned duration for this incident action.

Duration_Incident_Detail_ID

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

String256

[From Incident_Action] Comments regarding why the duration was changed.

ID

Longint

[From Incident_Action.Incident_Action_ID] Unique sequential number generated by the application for the Incident_Action record.

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_ID

Longint

[From Incident_Action] Unique identifier for the school. 0 if the incident is associated with the District.

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_Action] The username of the session that last updated the record.

Last_Modified_TS

Date

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

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_App_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".