Historical Student Attendance DDE

[maierada]

What is the easiest way to export annual attendance information for all students in a district from previous school years? For example, how can I get information like DaysAttended from the StudentAttendanceSummary table? (Because that table is temporary I don't think it maintains historical data.)

I know there is some attendance information in the CC table and in the Attendance table but these both contain many records that exceed the export limits so was hoping there was a simpler way to get a student-level record of attendance from previous school years.

[KritiS]

Hi @maierada 

You need to use the report and make sure to refresh the data for the dates you want. We recommend reaching out to the Technical Contact of your district who should be able to access this article: How-to-refresh-attendance-views-in-PowerSchool and assist you further. 

[julielewisMIPS]

Hi @KritiS Thats acutally not what she was asking. I have the same question...we want to export attendance for a student(s) from previous years. I'll keep looking for an answer...

[B_Brock]

Here's one way you could do it.

Get the Student ID Number (not the student_number) by selecting the student, then go to Academic Records > Teacher Comments

Note the number at the bottom center of the page, just above the dropped classes link.  This is the student's internal id number.

Go to DDE

Set the current table to Attendance

Search for 

  StudentID = xxx (value from above)

  YearID = YY

Click the Search All...  button

For the YearID, you'll use the two digit yearid value that corresponds to the year in which you need the records.  35 = 2025-2026;  34 = 2024-2025; 33 = 2023-2024; etc...

The page will refresh, and you'll see a number of currently selected records. These are the records that matched your two search criteria.

Click the Export Records button.

In the large white field, enter data points you'd like to have included in the export file.  I use the following:

ID
^([students]student_number)
^([students]last_name)
^([students]first_name)
^([students]grade_level)
StudentID
SchoolID
YearID
CCID
^([CC]Course_Number)
^([CC]Section_Number)
^([CC]TermID)
^([CC]DateEnrolled)
^([CC]DateLeft)
^(DECODE;^([CC]SectionID;substring=1,1);-;Dropped; )
^([CC]SectionID)
PeriodID
^([Period]Name)
^([Period]Period_Number)
^([CC]Expression)
Att_Date
^([Attendance]Att_Date;dateformat=DDD)
Att_Mode_Code
Attendance_CodeID
^([Attendance_Code]Att_Code)
^([Attendance_Code]Description)
Att_Comment

Click the Submit button.

When the file downloads, it will have a file suffix of .text which may or may not open when you double click on it. If it does not open, change the suffix from .text to .tsv or .csv. One of those will likely work.

Hope this helps!

Brian