PSCB - Custom Reports (Incidents)

View PSCB Plugin Directory

Version 1.1

Description

This plugin is an update to earlier versions created by Michael Moore and Jason Treadwell.

The bundle includes 11 incidents reports organized into two categories.

Note: All reports restrict access based on the Incident Type permissions set in Group Security.

Incidents

    Incident Count By Code
    Incident Count By Code (Demographics Breakout)
    Incident Search
    Incidents with Multiple Offenders
    Incidents with Non-Student as an Offender
    Incidents without an Offender
    Student Incident Count
    Student Incident Summary
    Suspension List

Incident Setup Validation

    Setup Details
    Setup Summary

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

PowerData Solutions Contributors
Jason Treadwell
Brent Johnson
Brian Andle

Version Info

1.0 (2019-02-16)
- Initial Release

1.1 (2021-01-07)
Updated 1 Report

Incident Search
Added Author and Created By to the report results.
The slide out incident details screen now correctly displays the incident description.
For security reasons, PSCB Development has decided not to add an edit incident link to the report results.

Powerschool Compatible Versions

21,x, 20.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources Version 3.6.1
PSCB - Custom Reports (_Home Page) Version 2.1

Installation

Install in System > System Settings > Plugin Management Configuration

Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.

If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Select a school and go to the Powerschool start page.
Click on the PSCB Custom Reports link on the left navigation menu.
Click on the Incidents link to access the Incidents Reports menu.

Tags:

Report Type: 
Web Based Report
Compatible PS Versions: 
21.x, 20.x
Plugin: 
Y
CPM Import Friendly: 
Y

Comments

Is there a plan to upgrade this so we can filter by Grade level and export the incidents with type, data, student, etc or create a parameter to allow for a selection of students?

I have administrators who want to be able to look at a selection of students and run this report.

Which of the Incident reports are you referring to in this request?

--
Rob Staats
PSCB Development

Wondering about the possibility of having the 'Incident Search' report be able to add current selection.

Thanks for all you do!!!

We are currently exploring ways for adding a "Make Current Student Selection" option to the report.

--
Rob Staats
PSCB Development

When running the Incident Count By Code (Demographics Breakout) all Ethnicity values are 0.
Is there a way to may this work to show with the new Ethnicity codes?

The report uses the Scheduling Ethnicity field. You will need to populate that field if you want to see ethnicity totals.

An update using Federal Ethnicity codes has been added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

The report for Incident Count By Code (Demographics Breakout) doesn't report any breakdown for ethnicity. Does anyone have a suggestion for a fix for this issue?

Lucy L. Hall

This report uses the Scheduling Ethnicity field. Field Name: ethnicity.
Confirm that this field has been populated.

--
Rob Staats
PSCB Development

I just installed the plugin and Enabled it but it does not show up anywhere.

Confirm that you have installed and enabled these two plugins.
PSCB - Base Resources
PSCB - Custom Reports (_Home Page)

When completed - a PSCB Custom Reports link will appear on left navigation menu on the Start page.
Click on the link and a list will appear showing you the PSCB report plugins you have installed.

--
Rob Staats
PSCB Development

I've installed the incident reports and I can run them. Those in other roles can run the report, but they get no results for students who do have incidents. I tried modifying the export edit access in the user role to include all incident categories (Start Page > System Administrator > Roles Administration > User Access Roles > Edit User Access Role), but that did not work. I went into the group setup and the group tied to the role does have access to incidents. What am I missing?

Joyce Rand
Antelope Valley Union High School District
Lancaster, CA
(661) 952-2212

Confirm that you given each security group permission to access the Accessible Incident Types you have created.

--
Rob Staats
PSCB Development

In the PowerSchool group permissions, they do have two of four Accessible Incident Types.

Joyce Rand
Antelope Valley Union High School District
Lancaster, CA
(661) 952-2212

If you would like to setup a Zoom session to review this issue, please send your contact information to pscb.development@gmail.com.

--
Rob Staats
PSCB Development

With PowerSchool versions greater than 20.11.3 It seems that the Suspension List report is only looking at local suspensions. PA State reportable suspensions are not being pulled into the report. Since that is a valuable report to make sure any student that was suspended is being reported to the state it would be helpful to include state reportable suspensions in the report. Servers on 20.11.1 and prior pull the correct suspended students for Pennsylvania.

If the suspensions are no longer appearing, this would indicate that state (PA) has moved the storing of this data to a different location (A new Database Extension and field names).

The PSCB Suspension report will not report suspensions stored in this new location.

--
Rob Staats
PSCB Development

When we run this report either for a single student or a group of students it just spins and never returns the data to the screen. Any ideas?

What exactly are these supposed to do? I run them and get no values. Thanks.

This would indicate that you have not completed the Incident Management setup.

At the District Level - Navigate to Start Page > District Setup > Incident Management Setup

View and complete all Incident setups.

--
Rob Staats
PSCB Development

Virginia has recently begin to use the Incident Management module instead of the Log Entry page. We have 14 subcodes under an action called Disciplinary Sanction Code^, but only a handful like STS1^ (Short Term Suspension) are pulling on the list output. A team at Central Office is hoping to use this list to identify students that have been reported with expulsion (EX1 and EX2).

When I run the "Students Incidents Summary" report and click on the link for a particular incident I get the popup window "Incident Details". However, the incident Description box is always blank and does not display the full description. Also, it would be ideal to be able to print the incident detail info as I do not see a way to do so from the built-in Incident Mgmt functionality.

If the description is blank on the popup window, this would indicate that the no description was entered when the incident was created.

Navigate to Student Incident page and determine whether a description was entered for the incident.

--
Rob Staats
PSCB Development

I confirmed that the incident has a full description, not the 1 line title that appears in the search/report results. The description field in the popup that appears when I click on the incident ID link remains blank

This issue will be addressed in the next release of the plugin scheduled for 1/20/22.

--
Rob Staats
PSCB Development

When I click on the incident ID link from the Incident Search report I get the following error.

An error was detected contacting the server. Please contact customer support if this continues to occur.

This issue will be addressed in the next release of the plugin scheduled for 1/20/22.

--
Rob Staats
PSCB Development

Thanks. Will it work like the other Incident reports with the right side popup of detailed info or will it bring up the actual incident in edit mode?

Also, another nice addition to the Incident Search report would be ability to customize the columns listed. One column that I've received requests for is the "Created by" / Author

PSCB Development has no plans provide an option to customize the columns display on the report. "Created By" and "Author" were added in latest release. If you want add or remove fields you will need to use CPM to customize the SQL.

--
Rob Staats
PSCB Development

I understand the reports restrict access based on the Incident Type permissions set in group security, but we mostly use role security, not group. It would be helpful if they worked with role security as well.
Thank you

PSCB will explore options for adding role security.

--
Rob Staats
PSCB Development

The incident reports include Log Type security by group. You can additional security by creating roles and assigning them to the group or individual user.

Role Security is the responsibility of PowerSchool administrator for the district.

--
Rob Staats
PSCB Development

We have updated versions of the base resources and the home page and version 1.1 for these incident reports. We are on PowerSchool 21.11.3, but the Student Incident Count report never loads. This report is perfect for what we need, but it doesn't seem to work. Any ideas? I have checked the security/permissions and they are good. I can get to the report and adjust the filters and click submit, but then it just goes to "loading" and it never actually loads. We eventually get a "This site can't be reached" error page. Thanks for the help!

Are you running the report at the school or district level?

At the district level the report will time out if you have a very large district enrollment.

--
Rob Staats
PSCB Development

Sorry I'm just seeing this reply.
I'm running the report at the school level. I tried it with the whole school enrollment (500ish students), then with one grade level at that school (150ish), then with a gender within one grade level (70ish) and finally with a group of 10 students. I got the same time-out issue in all instances.

Now it seems to be even worse and multiple reports won't generate at the school level. For instance, incident search and incident count reports are coming up that there are no records, but there are incidents at the school for sure. Thank you for any ideas/help.

So I just tested this. The reports run at one school, but won't at another. The school for which the reports do not run is good about entering all discipline events in incidents so they have 300+ incidents this year. I'm wondering if the report can't search that number of incidents? The school where the reports run just fine has less than a third of the incidents so far this year.

I need more information to investigate this issue.
If you would like to schedule a Zoom session to review, I’m available Today, 4/8 at 1:30pm (EST) or Tuesday 4/11 at 1:00 pm (EST)
If this works for you, just select a date and send a Zoom invite to pscb.development@gmail.com.

--
Rob Staats
PSCB Development

Hi Rob,
I figured out why the incident search would not load for the middle school. It looks like we had an incident with a description with 4,772 characters. Once I took the description for the incident out, the incident search report would work.
I'm still trying to figure out the Student Incident Count Report. Thank you for your help!

Could having 10 offenders in one incident cause the suspension list to never load? The report is not loading for one school so I am looking for incidents with a large number of characters and came across one incident with 10 offenders. thanks for anything you can tell me about this issue.

I need more information to investigate this issue.


If you would like to schedule a Zoom session to review, I’m available on Friday, 4/29 at 11:30 am (EST).

If this works for you, just select a date and send a Zoom invite to pscb.development@gmail.com.

--
Rob Staats
PSCB Development

When I run Student Incidents Summary I get no results. Incidents are fully set up.

Peggy Medema

I need more information to investigate this issue.


If you would like to schedule a Zoom session to review, I’m available on Tuesday, 5/10 at 2:00 pm (EST). If this works for you, just send a Zoom invite to pscb.development@gmail.com.

--
Rob Staats
PSCB Development

Subscribe to Comments for "PSCB - Custom Reports (Incidents)"