Discipline Log Entries
I don't know whether all the schools use the Log Entry option of PowerSchool to keep a log of who threw spitballs and such, and there are a bunch of fields and I would imagine the schools might use them differently, so YMMV. I know Ray uses this, so the specifics of these instructions were tailored to them.
In either case, you can get a selection of kids first, or search across the whole school.
Method 1: (Quick and easy, but minimal detail) There is a custom report I must've gotten somewhere, I don't remember. To use it, go to:
1. Start page -> System Reports -> "Engine" tab -> Discipline Log Entries (7) (I don't know what the 7 means.)
2. Plug in a date range, make sure "Entry text" is checked, and submit:
The result will be a list of all the entries in that date range, and will include the kid's name, grade, ID number, date, and the actual text of the entry, but nothing else.
Method 2: (more steps, but much more detail/configurable)
1. Start page -> Special Functions -> Search Log Entries
2. From the Log Type dropdown, choose "Discipline" and plug in a date range. Leave everything else blank and click submit:
3. Select "Quick Export":
4. Paste in (some or all of) the following lines:
^([1]LastFirst)
^([1]Grade_Level)
^([1]Home_Room)
^([8]Entry_Date)
^([8]Entry_Author)
^([8]Discipline_IncidentType)
^([8]Discipline_IncidentDate)
^([8]Discipline_IncidentLocation)
^([8]Discipline_Offender)
^([8]Discipline_ActionTaken)
^([8]Discipline_ActionTakenDetail)
^([8]Discipline_ActionDate)
^([8]Entry)
Get that into a spreadsheet. The output will look something like this (names blurred to prevent embarrassment):
Note that there are a bunch of other fields you can include; the ones above *seemed* to be the most relevant ones at least for Ray, but here's the complete list:
Category
Consequence
Custom
Discipline_ActionDate
Discipline_ActionTaken
Discipline_ActionTakenDetail
Discipline_ActionTakenEndDate
Discipline_AdministratorID
Discipline_AlcoholRelatedFlag
Discipline_DrugRelatedFlag
Discipline_DrugTypeDetail
Discipline_DurationActual
Discipline_DurationAssigned
Discipline_DurationChangeSource
Discipline_DurationNotes
Discipline_FelonyFlag
Discipline_GangRelatedFlag
Discipline_HateCrimeFlag
Discipline_HearingOfficerFlag
Discipline_IncidentContext
Discipline_IncidentDate
Discipline_IncidentLocation
Discipline_IncidentLocDetail
Discipline_IncidentType
Discipline_IncidentTypeCategory
Discipline_IncidentTypeDetail
Discipline_LikelyInjuryFlag
Discipline_MoneyLossValue
Discipline_Offender
Discipline_PoliceInvolvedFlag
Discipline_Reporter
Discipline_ReporterID
Discipline_SchoolRulesVioFlag
Discipline_Sequence
Discipline_VictimType
Discipline_WeaponRelatedFlag
Discipline_WeaponType
Discipline_WeaponTypeNotes
Entry
Entry_Author
Entry_Date
Entry_Time
ID
LogTypeID
SchoolID
StudentID
Student_Number
Subject
Subtype
TeacherID
Note that you would need to reference them with the carat and the "8" (the underlying ID number of the Log Entries table in the database) as shown above.
You can also include any field from the students table as long as you reference it with the carat and the "1" as shown above, e.g.
^([1]Gender)