Discipline Report

1. Login to PowerSchool
2. Go to DDE
3. Select Log table
4. Search Log
1. Entry_date >= 'start of current year date'
5. Click Export Records and use the following fields:

[1]State_StudentNumber
[1]student_number
[1]lastfirst
[1]gender
[1]Last_Name
[1]First_Name
[1]dob
ID
Entry_Date
LogTypeID
SchoolID
Subtype

1. Open the file in Excel
2. Filter the logs by LogTypeID
1. Every School will have their own LogtypeID. Make sure to identify the correct ID for discipline template and filter based on that ID.
2. Legal Prep uses LogTypeID=630 for Discipline (or suspension) logs.
3. Copy and paste the columns in the template.
4. Some columns such as School Numbers and discipline codes are entered manually - Refer to previously created files or contact supervisor for more details.