Suspension/Expulsion report bugs

[Kyle Schneider]

Yesterday the advisory group met with PowerSchool State reporting and reported a couple bugs related to Special Ed logic. I also reported 3 bugs with the Suspension/Expulsion report to PowerSchool this morning. The first four affect everyone, but the last bug only affects school districts where students transfer between schools - single site districts are not affected by the final bug.

• A disability code is currently being reported for all suspensions for a student regardless of whether the suspension happened after they transferred to general education. I’ve already added a rule to the AK Data Validation plugin to surface these errors so you can correct them.

• The Special Ed indicator is likewise not respecting the transfer to general education flag. I’ll be adding a rule to the AK Data Validation plugin this morning to surface these errors. I’ve already added a rule to the AK Data Validation plugin to surface these errors so you can correct them.

• Hearing Officer/Unilateral removal should only be populated if students have a disability. It populates as N on the report if the field is blank, so you’ll have to clear these from your spreadsheet. I’ve added a rule to the AK Data Validation plugin to surface these errors so you can correct them. However, the simplest way to deal with this is to sort your extract by disability code and clear the values for all entries with 00 as the disability code.

• Educational services should not be tied to special education status. It needs to be reported for any student who has an original or modified consequence of expulsion along with any students with a disability suspended for more than 10 days. However, the field doesn’t show unless they’re flagged as Special Ed - meaning your expulsions won’t have this set. I’ve updated the rule in the AK Data Validation plugin to better find these errors so you can correct them.

Here is the big one:

• The report is determining the school to report a suspension at by the last school the student was enrolled in, instead of the school the student was enrolled in at the time of the suspension. This means that any students who transfer schools during the school year, will have all their suspensions reported at their final enrolled school, not the school they were actually suspended from.

- For those of you with the AK Data Validation plugin, I’ve written a rule to surface these errors, but since the school number is determined when the report is run, you can’t fix them in the user interface - you’ll have to edit the spreadsheet and adjust them manually.

- For those of you who do not have the AK Data Validation plugin, but can run SQL queries, I’ve written a query you can use to find these students, and what the correct school should be for each suspension. You’ll need to hand enter these corrections to the spreadsheet if you’d like them done before PowerSchool State Reporting releases a fix (unlikely until late June or early July and the report is due on June 30th).

WITH discipline AS (

SELECT

s.lastfirst,

TO_CHAR(ak.incident_date,'MM/DD/YYYY') incident_date,

ak.incidentid,

s.schoolid stu_schoolid,

log.schoolid AS log_schoolid,

log.consequence,

ak.discipline_mod_consequence AS mod_consequence,

(SELECT pse.schoolid FROM ps_enrollment_all pse WHERE pse.studentid=s.id AND ak.incident_date BETWEEN pse.entrydate AND pse.exitdate) trueschoolid

FROM s_ak_log_x ak

JOIN log ON log.dcid=ak.logdcid

JOIN students s ON s.id=log.studentid

WHERE

ak.incident_date>=TO_DATE('07/01/2025','MM/DD/YYYY')

AND log.consequence IN ('S','ISS','E') OR ak.discipline_mod_consequence IN ('S','ISS','E')

)

SELECT

lastfirst,

incident_date,

incidentid,

stu_schoolid,

log_schoolid,

consequence,

mod_consequence,

trueschoolid

FROM discipline

WHERE discipline.stu_schoolid!=trueschoolid OR log_schoolid!=trueschoolid

ORDER BY lastfirst,incident_date

--

Kyle Schneider

GSD Educational Services

Phone: 907-917-4149

ky...@gsded.com

­