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)