OK Incident Management Query
Contents
Introduction
The Incident Management Query provides a mechanism to search the discipline incident data entered in the Incident Management module based on criteria specified by the district. It includes general items like behaviors or actions and also state-specific items like IDEA or Title 1. It also provides the ability to export these search results into comma-separated value (CSV) files. The results are context sensitive and therefore vary if you run the report at the district or school level.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
By default, this export includes all incidents for the currently selected school and currently selected school year.
Navigation
- On the Start Page, click System Reports. The Reports page appears.
- Click the State tab.
- Under Oklahoma Miscellaneous Reports, click OK Incident Management Query. The Incident Management Query page appears.
Incident Query
| To search by... | Select... |
|---|---|
| Incident ID | Incident ID field from the pop-up menu. Enter the ID number of the incident you want included in the query. |
| Incident Type | Incident Type field from the pop-up menu. Enter the incident type you want included in the query. |
Incident Date | Incident Date field from the pop-up menu. Enter the date of the incident you want included in the query |
| Incident Location | Incident Location field from the pop-up menu. Enter the Location of the Incident or incidents you want to include in the query. |
| Incident Title | Title search text field from the pop-up menu. Enter the title of the incident or incidents you want included in the query. |
| Prepared By | Prepared By field from the pop-up menu. Enter the name of the user who prepared the incident reports you want included in the query. |
| Participant Role | Participant Role field from the pop-up menu. Enter the participant roles you want included in the query. |
| Behavior Code | Behavior Code field from the pop-up menu. Enter the behavior code you want included in the query. |
| Action Code | Action Code field from the pop-up menu. Enter the action code field you want included in the query. |
| Object Code | Object Code field from the pop-up menu. Enter the object code field you want included in the query. |
| Operators | |
| Relational Operators | The pop-up menu between the Field Name pop-up menu and the Value box contains the relational operators that exist in core PowerSchool: =(equal), <(less than), >(greater than),>=(greater than or equal to), <=(less than or equal to), # (does not equal too), contains (is the search argument contained in the [field], !contains (is the search argument not contained in the [field]. |
| Value | The value pop-up menu will be pre-populated with the appropriate values corresponding to the student field selected in the Field Name pop-up menu. The user is able to select multiple values in the pop-up menu by holding down the shift key to select contiguous values or holding down the Control key while selecting random values in the pop-up menu. |
| Comparison | The comparison pop-up menu will be populated with 'AND' and 'OR' as values. "AND" is the default. |
Student Query
| To search by... | Select... |
|---|---|
| State Specific Fields | Select any additional state specific fields to search by from the pop-up menu. Options include:
If English Learner (EL) is selected, choose from the following subset to indicate student's level of English proficiency.
|
| Last Name | Select the Last Name field from the pop-up menu. Enter the last name of the student you want included in the query. |
| First Name | Select the First Name field from the pop-up menu. Enter the first name of the student you want included in the query. |
| Grade Level | Select the Grade Level field from the pop-up menu. Enter the grade-level of the student or students you want included in the query. |
| Gender | Select the Gender field from the pop-up menu. Enter the gender of the student or students you want included in the query |
| Fed Ethnicity | Select the Fed Ethnicity field from the pop-up menu. Enter the ethnicity of the students you want included in the query. |
| Race Code | Select the Race Code field from the pop-up menu. Enter the race code of the student or students you want included in the query. |
| Entry Date | Select the Entry Date field from the pop-up menu. Enter the school entry date of the student or students you want included in the query. |
| Exit Date | Select the Exit Date field from the pop-up menu. Enter the school exit date of the student or students you want included in the query. |
| Enrollment Status | Select the Enrollment Status field from the pop-up menu. Enter the enrollment status of the student or student's you want included in the query. |
| Student Number | Select the Student Number field from the pop-up menu. Enter the student number of the student you want included in the query. |
| Relational Operators | The pop-up menu between the Field Name pop-up menu and the Value box contains the relational operators that exist in core PowerSchool: =(equal), <(less than), >(greater than),>=(greater than or equal to), <=(less than or equal to), # (does not equal too), contains (is the search argument contained in the [field], !contains (is the search argument not contained in the [field]. |
| Value | The value pop-up menu will be pre-populated with the appropriate values corresponding to the student field selected in the Field Name pop-up menu. The user is able to select multiple values in the pop-up menu by holding down the shift key to select contiguous values or holding down the Control key while selecting random values in the pop-up menu. |
| Comparison | The comparison pop-up menu will be populated with 'AND' and 'OR' as values. "AND" is the default. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
| Position | Field | Description | [Table]Field Name |
|---|---|---|---|
| 1 | Student Number | ID number of student | [Students]Student_Number |
| 2 | StudentLastName | Last name of student. | [Students]Last_Name |
| 3 | StudentMiddleName | Middle name of student. | [Students]Middle_Name |
| 4 | StudentFirstName | First name of student. | [Students]First_Name |
| 5 | Gender | Gender of student | [Students]Gender |
| 6 | Ethnicity | Ethnicity of student | [Students]Fedethnicity [StudentRace]Racecd |
| 7 | Grade Level | Grade level of student | [Students]Grade_Level |
| 8 | IDEA | Indicates student's IDEA status | [S_OK_STU _X]IDEA |
| 9 | Section 504 | Indicates student's disability status under Section 504 | [S_OK_STU _X]Section504 |
| 10 | Title 1 | Indicates if student meets the state’s definition for Title 1. | [S_OK_STU _X]Title1 |
| 11 | Alternative Education | Indicates if the student meets the state’s definition for Alternative Education. | [S_OK_STU _X]AltEdInd |
| 12 | Incident ID | Incident ID number | [Incident]ID |
| 13 | School Number | ID number of school | [Schools]School_Number |
| 14 | Incident Date | The date that the incident occurred. | [Incident_Detail]Incident_TS |
| 15 | Incident Title | Title of the incident | [Incidents]Incident_Title |
| 16 | IncidentDescription | Brief description of the incident. Note: End of line characters are removed if present. | |
| 17 | Incident Prepared By | Maker of the incident report | [Incidents]Entry_Author |
| 18 | Incident Attribute Code | ||
| 19 | Role Code | Code describing role of student in the incident. | [Incident_LU_Code]Code_Type=personcode [Incident_LU_Code]Incident_Category |
| 20 | Object Code | The code for any object involved in the incident. | [Incident_LU_Code]Code_Type=objectcode [Incident_LU_Code]State_Aggregate_RPT_Code |
| 21 | Action Code | Code describing general action taken against the student as result of the incident. | [Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code]State_Aggregate_RPT_Code |
| 22 | Action Sub Code | Code describing specific actions taken against the student as result of the incident | [Incident_LU_Sub_Code]State_Detail_Report_Code [Incident_LU_Sub_Code]Is_State_Reportable_Flg = 1 (True) |
| 23 | Action Begin Date | The beginning date of the action taken against the student as a result of the incident | [Incident_Action]Action_Plan_Begin_Dt |
| 24 | Action End Date | The end date of the action against the student as a result of the incident. | [Incident_Action]Action_Plan_End_Dt |
| 25 | Action Assigned Duration | The intended duration of the action taken against the student as a result of the incident | [Incident_Action]Duration_Assigned |
| 26 | Behavior Code | Code describing the general category of behavior causing the incident. | [Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code]State_Aggregate_RPT_Code |
| 27 | Behavior Sub Code | Code describing the specific behavior causing the incident. | [Incident_LU_Sub_Code]State_Detail_Report_Code [Incident_LU_Sub_Code]Is_State_Reportable_Flg = 1 (True) |