Paycore Report Assistant

Overview The goal is to make a "first-draft" of a Paycore "shift" spreadsheet based on the date and typical teaching schedules. After making your selection, click on "shifts.csv" and download it to your computer for you to edit.	Today is Sun, Sep 20, 2026 Schedule for next school day: Mon, Sep 21, 2026 Day 4 D 08:23 AM - 09:53 AM F 10:15 AM - 11:45 AM B 12:15 PM - 01:45 PM G 01:55 PM - 02:40 PM
Make Shifts Select Date(s) and Teacher(s) Start Date End Date Choose a teacher: All Teachers Gino Altobelli 23Timothy Anderson 92Glen Appels 14Teresa Baldonado 58Tim Bell 119Jeremy Bourdon 137Deanne Carnighan 138Patrick M. Carroll 139Ted Carroll 88Sylvana Castillo 127Calista Chambers 2080Kristine Chung 156Julie Clemons 1004Edward Corcoran 36James Darling 2083Patrick Davitt 103Richard DiPalma 20Sergio Diaz 94Dirk Dierking 29Joel Doerning 54Patrick Donovan 37Aaron Dorlarque 65Jeffrey Durfee 19Emmanuel Eulalia 17Austin Frank 108Madelyn Frazior 2079Mark Gibbons 16Eric Gleason 27Joshua Godson 40Jordan Griffin 120Eli Hallak 24William Heinen 60Hector Hernandez 2078Jesus Herrera 158Jonathan Jay 104Shaun Kort 132Matthew Kozicz 1002Tony Marinoff 155New Campus Minister 9995Lance Mitchell 2074Selena Mone 129Claudia Montiel 154Ashley Muro 140Jeremy Nelson 142Kyle Ostrom 32Dan Pelletier 34John Michael Perkins 69Kathleen Smith Reichert 107Kendall Rice 157Michael Seidler 56Oralia Snyder 144Chris Thiel 1006Robert Tompson 145Tracy Traver 35Ann Sorrells Wicke 100Todd Wolfson 57 MAKE SHIFTS (Sept 4, 2026 version)
View the Data in the Tables Paycor shifts are made from the information in these four tables: dates courses staff bells duties (sign up) Click to view the table. You can download a csv version of the each table in order to edit or update it with your own computer, and then email it back to Fr Chris to update the information on the server.

Fr C's 26 Hours from June 22-Sept 4, 2026:

1. June 22, 2026 (2 hr) Updated Dates with 2026-7 Schedules and holidays
2. June 23, 2026 (3 hr) Updated Bell schedule for the 4 Friday Sports Rallys, updated the "Make Shifts" of https://mathorama.com/paycor for new year, Changed Shift label to include special bell schedule (like Mass/Assby Schedule, Friday Sports Rally Schedule, and Friday Schedule on a Thursday), updated staff database (4 new 2 removed), and new photos linked for the Sign-Up-For-Points
3. July 7, 2026 (3 hr) Updates Staff database and course database with the best available information.
4. July 8, 2026 (2 hr) More updates to staff and course database, modified the "Choose a teacher" to assure alphabetical listing of teachers. Added a way to change the sort order of courses to aid proof reading new master schedule, or find an available room for a Block, or a what classes are in a room.
5. July 9, 2026 (1 hr) adding sorting of staff.csv to help with seeing sign-up groups by senority. fixed a bug with group sorting
6. July 10, 2026 (1 hr) updated schedule changes in courses.csv, fixed a bug with group sorting
7. Aug 6, 2026 (2 hr) Updated ranks is staff db, changed courses db of paycor 121 to 9996 "New Teacher" Fixed a bug in veiwStaff.php to have the correct headers. Changed the signUp editing using posts, updated at canEdit and startTime
8. Aug 11, 2026 (4 hr) Met with Dr Nelson, Worked on the new duties.csv for 2026-2027 sign-up points, updated the course and staff data bases with new paycor numbers, and changed so each person could be assigned a certain number of hours.
9. Aug 14, 2026 ( 2 hr) Sent Support Ticket at 1am when website was partially functional (php calls to the SQL gave 503 Server errors). When service was restored I updated the data base for several teachers requirements, Sorted the names of the teachers alphabetically by group, rather than rank. Changed that a teacher can submit if they signed up for more than they are required to.
10. Aug 18, 2026 (3 hr) Met with Dr Nelson, got new Paycor templet to import shifts, after some initial success with a tiny csv file, no longer worked, so used an exported shift instead of the templet, finally after had to use payor customer service
11. Aug 19, 2026 (1) Made a "hand-crafted" version that had limited success. Made the "7:33" version to try that would simulate it.
12. Aug 27, 2026 (1) Make Several versions to try to address filling in something into the Pre- and Post- Punch buffer columns
13. Sept 4, 2026 (1) Removed the alternative forms, and made the best version that removes the commas in the the Notes column and includes the four "break" times, but not actually putting any times in them. Also increased privacy by changing GET to POST so names are not in the open when calling makeShifts.php, as well a protecting from errors produced if a bot tries to use makeShifts.php without any dates or teacher information.