PSCB - Custom Reports (Attendance)

Submitted by PSCB on Wed, 05/23/2018 - 5:51pm

View PSCB Plugin Directory

Version 2.5

Description

This bundle includes 19 attendance reports organized into 4 categories.

Daily Attendance

    Daily Attendance - Audit
    Daily Attendance - Consecutive Days Absent
    Daily Attendance - Count / Points
    Daily Attendance - Current Date Summary
    Daily Attendance - Selected Date / Date Range
    Daily Attendance - Search by Frequency

Meeting Attendance

    Meeting Attendance - Audit
    Meeting Attendance - Count / Points
    Meeting Attendance - Current Date Summary
    Meeting Attendance - Selected Date / Date Range
    Meeting Attendance - Search by Frequency
    Meeting Attendance - Teachers Missing Attendance

School Attendance

    School Attendance - Daily Attendance Summary
    School Attendance - Daily Attendance Summary by Date/Code

Student Attendance

    Student Attendance - Daily Absences Alert
    Student Attendance - Daily Absent/ADA Summary Totals
    Student Attendance - Daily/Meeting Summary List
    Student Attendance - Daily Absent/Monthly Summary
    Student Attendance - Daily Historical Summary
    Student Attendance - Meeting Dates and Count Summary

The bundle adds 2 reports to the Start/Functions Menu

    Daily Attendance - Selected Date Report (Modify)
    Meeting Attendance - Selected Date Report (Modify)

Note: The Daily Attendance - Audit report requires that the Audit attendance records box is checked on the School Setup > Attendance Preferences page.

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra

Other Contributors
Adrian Carlson - Development of the Student Attendance - Meeting Dates and Count Summary report.

PowerData Solutions Contributors
Jason Treadwell
Brent Johnson
Brian Andle
Tim Scoff
Matt Freund
Roger Sprik
Dean Dahlvang

Version Info

1.2 (2018-05-23)
- Initial Release

1.3 (2018-06-09)
- Updated HTML 5 button links on two reports.

1.4 (2018-06-22)
Updated the # Days link on the Daily Attendance - Consecutive Days Absent report.

1.5 (2018-09-21)
Updated the Student Attendance - Daily Absent/ADA Summary Totals report. The report will now display attendance totals for a selected date range from previous school years.

1.6 (2018-10-18)
Daily Attendance - Selected Date Report (Modify). Home Phone added to the report results.
Meeting Attendance - Search by Frequency. Added Make Current Student Selection button.

1.7 (2018-12-01)
Daily Attendance - Selected Date Report (Modify)
- Added slide out pane for editing a selected daily attendance code.
- Report automatically refreshes after submitting a code change.

Meeting Attendance - Selected Date Report (Modify)
- Added slide out pane for editing a selected meeting attendance code.
- Report automatically refreshes after submitting a code change.

These reports provide an alternative option to the One Stop Attendance plugin previously published on PDS.

1.8 (2019-2-25)
- Fixed an error with the attmtg_edit.html file. Meeting Attendance codes can now be modified correctly.

2.0 (2021-02-07)
- All attendance reports are now school based only. We are currently developing new district based reports.
- Added additional report fields (Including track) and filter capabilities to most reports.
- Added over 15 enhancement requests submitted by the Powerschool community.
- Consolidated the Selected Date and Date Range reports into a single report (Daily and Meeting).
- Added 2 new reports.
Student Attendance - Daily Absent/Monthly Summary
Student Attendance - Daily Historical Summary

2.1 (2021-03-14)
- The Daily Attendance - Selected Date (Modify) and Meeting Attendance - Selected Date (Modify) reports are now 20.x compatible.
- Added Multi-Select attendance code filter option to several reports.
- Added Teacher filter option to the Meeting Attendance Report - Date Range report
- Added collapse/expand window option to several reports.
- Added additional report elements to the Student Attendance - Daily/Meeting Summary List report.
- The Daily Attendance - Consecutive Days Absent report has been temporarily removed from the bundle. This is due to compatible issues with the latest PowerSchool releases. PSCB is working on an update that will published when completed.

2.2 (2021-03-18)
- Added enroll status to 3 student attendance reports.
- Updated Daily Attendance - Consecutive Days Absent report to be compatible with Powerschool 20.x.

2.3 (2021-04-09)
- The Student Attendance - Daily Absent/ADA Summary Totals report now has an option to display grade level totals for a selected group of students.

2.4 (2021-05-16)
- Added new report: Student Attendance - Meeting Dates and Count Summary
- Special thanks to Adrian Carlson for permission to include this report in the PSCB Attendance bundle.

2.5 (2021-05-23)
- Added new report: Student Attendance - Daily Count/Dates Summary.
Note: The PSCB - Customization (Student Attendance Pages) plugin should also be installed for use with the PSCB – Custom Reports (Attendance) bundle.

Powerschool Compatible Versions

21.x, 20.x, 19.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources
PSCB - Custom Reports (_Home Page)
PSCB - Customization (Student Attendance Pages)

Installation

Install in System > System Settings > Plugin Management Configuration

Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.

If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Select a school and go to the Powerschool start page.
Click on the PSCB Custom Reports link on the left navigation menu.
Click on the Attendance link to access the Attendance Reports menu.

Customization:

Report Type: 
Web Based Report
Compatible PS Versions: 
21.x, 20.x, 19.x
Plugin: 
Y
CPM Import Friendly: 
Y

Comments

dbridgeforth

Sun, 03/24/2019 - 5:49pm

Is it possible to get this report so you can select the attendance codes you need? I need something to show OSS and ISS (Out of School and In-School Suspensions only. I love this report but need to find a way to make sure my log entry suspensions and attendance match. If it isn't possible is there any other reports out there that could do this?

Dana Bridgeforth

PSCB

Sun, 03/24/2019 - 6:19pm

Each column on the report has a filter box above the column heading. Type in the text you are searching for (Ex: ISS or OSS or just SS) and the report will display matching results.

--
Rob Staats
PSCB Development

PSCB

Mon, 03/25/2019 - 6:08am

If you enter ‘SS’ in the filter box, you should see both OSS and ISS results displayed.

--
Rob Staats
PSCB Development

agjohnson

Fri, 09/06/2019 - 7:16am

I am looking for something school wide, like a report where you can specify how many days absent, tardy, early dismissal.
It is a powerful tab for attendance - everything in one place and no more switching terms and schools! Thank you for it!

PSCB

Fri, 09/06/2019 - 9:57am

Thank you for your request. PSCB development has no current plans to create a report of this type. We add your request to the PSCB enhancement list.

--
Rob Staats
PSCB Development

dbridgeforth

Sun, 03/24/2019 - 8:55pm

I want to select two at one time and that’s not an option.

Dana Bridgeforth

dbridgeforth

Tue, 03/26/2019 - 9:22am

I am very sorry - I was using the old custom reports. Thank you for responding. Just switched over to your new reports.

Dana Bridgeforth

tbelej

Thu, 06/13/2019 - 7:18am

Hi,

I have a user that doesn't see export buttons. I do with my login. I checked security settings on both accounts and they are both the same. Any suggestions?

Thanks

Ted

ablazey

Tue, 09/03/2019 - 11:14am

Hi,
I am putting this back on the table to add Homeroom attendance data cuts, not just grade level . Right now we cannot use many of these reports because leadership wants to see how indivual classes are doing. If we could have this on some of the reports it would help our schools tremendously.

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

rpenman

Fri, 09/20/2019 - 1:08pm

When I run the Meeting Attendance Audit, it reports no attendance changes when I know that there have been numerous changes. It ran fine last year. Any ideas?

PSCB

Sat, 09/21/2019 - 3:18pm

For each school navigate to:

Start Page / School Setup / Attendance / Preferences

Confirm that the Audit attendance records box is checked.

--
Rob Staats
PSCB Development

rpenman

Mon, 09/23/2019 - 9:55am

That was it. Thank you.

astetson

Thu, 09/26/2019 - 1:55pm

I cannot select a school when running the attendance reports. Version 1.8, PS SIS 19.4. Is this an issue with PS 19?

Thanks!

PSCB

Thu, 09/26/2019 - 2:40pm

The attendance reports are all school based. The reports automatically use the student population of the school you are currently viewing.

--
Rob Staats
PSCB Development

antonecchia.julie

Mon, 10/28/2019 - 2:29pm

Hi are there any issues with the Daily Attendance - Audit report? I extracted the modified records for a specific day on DDE and there are 13 modified records by a specific user, but the report is only showing that one student attendance record was modified.

antonecchia.julie

Mon, 10/28/2019 - 2:31pm

FYI, Audit attendance records is checked on Attendance Preferences

AmandaHynes

Wed, 11/06/2019 - 8:12am

First, thank you for all you do to help make our jobs easier
I love the Student Attendance Plug in reports
The two I've been using are:
Daily Absent/ADA Summary totals - It would be helpful to be able to sort the columns after the report runs so it's easier to see who is chronic without have to copy and sort in Excel.
Quick question - If I do a *as_of= search on the start page to make my current selection will the report pull all the students as of that date and their attendance even if they have transferred out or have gone to another school. It looks like it does, I just want to be sure?

Daily Absences Alert - It would be helpful to be able to make the results your current selection so we can review each of the student's reasoning and then go right into print reports.

Thank you so much for your time and consideration

Amanda Hynes
PowerSchool Database Administrator

PSCB

Wed, 11/06/2019 - 2:09pm

Column sorting and HTML selection buttons are already included in all PSCB reports. You need to install and enable the PSCB - Custom Base Resources 2.4 plugin to active these options.

--
Rob Staats
PSCB Development

ablazey

Thu, 11/07/2019 - 4:05pm

Hi team,
Today I had a request to run all of the names of students with 3 or fewer of a specific attendance code. When I used the search by frequency report, and kept minimum blank, students that did not recieve to code did not populate on the report. It may be how the report is intended to be used, but it would be helpful to have the students not receiving the code run when you type in 0 or leave it blank. Is that possible? Thank you!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

PSCB

Thu, 11/07/2019 - 8:13pm

This not an error. The report will not include a student with a “0” count of the attendance code you are searching for. If the student has not be assigned any instance of the code, no attendance record is created. Thus the student is excluded from the report results because there were no records of the that code in the student’s attendance history.

This is how the report was designed. We will add your request to our enhancement list.

--
Rob Staats
PSCB Development

ablazey

Fri, 11/08/2019 - 6:05am

ok, thank you!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

ablazey

Thu, 11/21/2019 - 9:43am

Hi,
It would be great if when you are selecting a date range, each different date pulled as a new row. For school lunch, we need to provide how many students were in attendance by day and having that listed out as individual days would be super helpful. Thank you!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

PSCB

Thu, 11/21/2019 - 10:51am

This request has been added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

JCORCORAN

Mon, 11/25/2019 - 2:04pm

Hi,
I just added these reports to our system. I am able to run both the Daily and Meeting Attendance - Counts/Points in our Middle School and High School. However, when I try to run the Daily Attendance-Counts/Points (we don't use Meeting Attendance at our elementary schools) at our elementary schools, the total points is not accurate. If I set the minimum to 0, I see students with 5 or more absences. If I set the minimum to 5, the report comes back blank. What am I missing?
Thanks!
-Jeanne Corcoran
Coordinator of Data Assessment and Accountability
South Orangetown Central School District

PSCB

Wed, 11/27/2019 - 9:30am

The fact that the report works correctly for the MS/HS would indicate a setup issue with the elementary schools.

For each Elementary School:

- Navigate to Start Page > PSCB Custom Reports > PSCB Custom Report Settings - Daily Attendance Codes.
Confirm that you have entered the daily attendance codes you want included in the Daily Attendance - Counts/Points report.

- Navigate to Start Page > School Setup > Attendance Codes.
Confirm that the attendance points have been entered correctly for the Daily Attendance codes.

What FTE conversion are you using. Code to Day or Meeting to Day?

--
Rob Staats
PSCB Development

JCORCORAN

Mon, 12/09/2019 - 11:40am

I checked both of those and they are set up correctly. The FTE conversion is Code to Day .
It is the "Total Abs Points" that is incorrect. It will list 2 under an absence code and then Total Abs Points is 0. Any other suggestions where I should look?
Thanks,
Jeanne Corcoran

PSCB

Mon, 12/09/2019 - 2:38pm

This would indicate that no attendance points were assigned to this code in your Attendance Codes setup.

Navigate to Start Page > School Setup > Attendance Codes
Click on the Attendance Code.
Check the number of attendance points assigned to the code.

--
Rob Staats
PSCB Development

JCORCORAN

Wed, 12/18/2019 - 9:10am

That was it. Thank you!

gosenl

Wed, 12/11/2019 - 8:28am

I have a student whose attendance was changed from Absent to Tardy yesterday. This attendance change does not show up on the "Attendance Changes" tab for this student, nor does it show up on the Daily Attendance Audit report, although other students' changes do.

The last change that does show up on "Attendance Changes" tab for this student was in October. However, this student had 2 attendance changes in November in addition to the one yesterday. This student has been enrolled since the beginning of the year and has a valid attendance conversion. When I look at the attendance table, it says that yesterday's change was made by a specific school secretary. However, she insists that she did not make the change.

I've run the Refresh Premier Attendance Views function but it didn't help. Where else should I look?

Thank-you.

-- Lisa Gosen

PSCB

Wed, 12/11/2019 - 8:59am

At each school, navigate to Start Page > School Setup > Attendance Preferences.

Confirm that the 'Audit attendance records' box is checked.

--
Rob Staats
PSCB Development

gosenl

Wed, 12/11/2019 - 9:55am

That box is checked.

PSCB

Wed, 12/11/2019 - 11:20am

I'm not sure we can assist you with this issue. We have not be able to duplicate the issue. The fact that it is occurring with a single makes it difficult to investigate without access to the server.

--
Rob Staats
PSCB Development

trishb

Fri, 12/20/2019 - 1:52pm

Our District really likes the "Student Attendance - Daily Absent/ADA Summary Totals" report but would like it to have an additional column that could include the previous years? Is that possible? Or is there already a report that I'm missing.

Some like this:
18-19 19-20
96.8 97.2

PSCB

Fri, 12/20/2019 - 2:46pm

This request has been added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

creswellamy

Mon, 12/30/2019 - 8:06am

I really appreciate this report! Any chance you could add the Home_room field?

PSCB

Mon, 12/30/2019 - 9:02am

This request will be added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

gjorgenson1@san...

Wed, 01/22/2020 - 12:59pm

Is this plugin compatible with the current version of PS, which I believe is 19?

PSCB

Wed, 01/22/2020 - 1:04pm

This customizations is compatible with PowerSchool 19.x.

--
Rob Staats
PSCB Development

cacreel

Wed, 01/22/2020 - 1:40pm

Would it be possible to add the Term ID to Meeting and Daily Frequency Attendance Reports?
Thanks

PSCB

Wed, 01/22/2020 - 6:17pm

Sorry - PSCB has no plans to add Term ID to these reports.

--
Rob Staats
PSCB Development

ablazey

Wed, 01/29/2020 - 8:51am

Hi,
Can we add a period to the report filters? It would be helpful to be able to pull this quickly to see if certain periods are areas of tardy or absent. Thank you!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

PSCB

Wed, 01/29/2020 - 3:41pm

PSCB has no plans to add a Period(s) filter to the report.

The Expression column filter is available to to select the period(s) you want to view.

--
Rob Staats
PSCB Development

jward

Thu, 01/30/2020 - 12:34pm

When we run the "Daily Attendance - Current Date Summary" with YTD, we don't get any Tardy info.
Not sure what I am missing.

PSCB

Thu, 01/30/2020 - 1:20pm

Navigate to attendance code settings. Confirm that all the tardy codes have the Tardy Category checked.

--
Rob Staats
PSCB Development

jward

Mon, 02/03/2020 - 8:06am

Rob, They are marked as Tardy. I can run a tardy report and get the numbers but the Current Date Summary shows 0 even when the student is tardy that day.
Thanks for the response.

PSCB

Tue, 02/04/2020 - 2:20pm

The Attendance totals on that report are reflect the totals from the Premier Attendance Views Data table, which is updated nightly.

If you enter new attendance records on the current date, you need to Refresh Premier Attendance Views Data to see updated totals.

From the start page Navigate to Functions/Attendance Functions/Refresh Premier Attendance Views Data.

--
Rob Staats
PSCB Development

jward

Wed, 02/05/2020 - 7:19am

Thanks, I get why they don't show up for the same day, but why don't the YTD figures show?
When I run a frequency report for Tardy I get results. Does that come from a different table?

PSCB

Wed, 02/05/2020 - 3:39pm

There are two methods PSCB uses to to include calculations in our attendance reports.

Method 1: The sql report retrieves the requested values and the calculation totals are generated in real time.

Method 2: On some reports generating calculation totals in real time is not a feasible option because of the amount time it would take to render the report.

This is why PowerSchool created the Premier Attendance Views Data table.
Attendance totals are calculated and stored nightly. These totals can be quickly retrieved and added to the sql report.

The Daily Attendance - Search by Frequency report generates real time calculations.

All attendance calculation totals on the he Daily Attendance - Current Date Summary are retrieved from Premier Attendance Views Data table.

PSCB uses the real time calculation method whenever possible.

--
Rob Staats
PSCB Development

ablazey

Thu, 02/13/2020 - 10:48am

Hi,
I ran the consecutive absent report and we have some students showing up twice in the report, any troubleshooting ideas? Thanks!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

PSCB

Thu, 02/13/2020 - 1:25pm

This indicates that the student had "x" number of absences on two different occasions during the school year.

Example for 5 consecutive absences.
Instance 1: 10/1-10/5
Instance 2: 11/10-11/14

--
Rob Staats
PSCB Development

Pages

Subscribe to Comments for "PSCB - Custom Reports (Attendance) "