Attendance Information Report

Step 1: Pulling Attendance Information

1. Log into PowerSchool Admin panel.
2. Select School: Elementary School, Middle School or High School
3. Then from Setup > System > Data Management > Direct Database Export (DDE)
4. Select Current Table : Attendance(157) and click “Select all records in this table”
5. In the Search Attendance, put in the Attendance date you wish to pull attendance for and click on “Search all records in this table”
6. It will show the attendance records, post the date that you have put in. Click on “Export Records”
7. Now put in the following fields (in the same syntax as below) to be exported:
   [157]Att_Date
   [157]PeriodID
   [156]description
   [4]course_number
   [1]lastfirst
   [1]Grade_level
   [133]Name
8. It will give you all attendance codes for the all the attendance days for that period.
9. Sort via description field and take off all the attendance code except the one that you require.. in this scenario “Tardy Unexcused”
   After that you can either do “Sorting by Att_Date” or by “lastfirst” to have it by student.
   Note: This report is only allowing for taking the “Course Number”. To get the Course name:

Step 2: Pulling Course Names

1. Go to DDE again and select the table as “Courses(2)”
2. Click on “Export Records” and choose the following fields to export to excel –  “course_name” / “course_number”
3. Save this file for future reference also. You will have to replace the course_number with course_name in the Attendance sheet to get the class student was late in.

Step 3: Pulling Bell Schedules

1. Go to “DDE” and select the table as “Bell_Schedule_Items(134)”
2. Export records via selecting these fields
3. Save the file and open in Excel.

Final Format

In the Attendance Excel file now:

1. Replace Course_number with “course_name
2. Take all of the Attendance codes that you don’t require from the “Description” column.. just keep the one that you want.
3. Align the exported bell schedule item period with the exported attendance period id to get timings of the periods