Is there a database view built for student's bell schedules

Scott_Hansen — Tue, 11 Mar 2025 19:02:07 GMT

I'm creating a report that compares our "Right Choices" (program) attendance with the home schools attendance records.

However, I've run into an unexpected snag. It's only going to work if the school enters an attendance entry into the attendance table.

I think I need to fold the bell schedule into my query. I was wondering if there was a view already in PS that already existed?

I'm attaching my code incase that helps.

Re: Is there a database view built for student's bell schedules

Scott_Hansen — Tue, 11 Mar 2025 19:18:33 GMT

I'm reattaching the code with comments to explain what each virtual tables is doing.