Provide Teacher Pay Data to Accounting

Procedure should be run on the first day of each month after 12:00AM EST


Run query TeacherPay.sql

The query produces three result tabs (TeacherPay2223, TeacherPay2324, and TeachPay2425)


Between December 2022 and May 2023:

Open the TeacherPay22-23 Google workbook: https://docs.google.com/spreadsheets/d/1VBfcgeUnCVbxQuWrbP92w14GygM8-k5efXJGOomaNmw

Copy the field names and data from result tab TeacherPay2223 into the tab(cell A1) corresponding to the current month



In the month of June 2023:

We need to report data in two Google workbooks, both have a Jun23 tab:

We report the 2022-2023 data in the TeacherPay22-23 Google workbook

Open the TeacherPay22-23 Google workbook: https://docs.google.com/spreadsheets/d/1VBfcgeUnCVbxQuWrbP92w14GygM8-k5efXJGOomaNmw

Copy the field names and data from result tab TeacherPay2223 into the Jun23 tab(cell A1)


We also report the 2023-2024 data in the TeacherPay23-24 Google workbook

Open the TeacherPay23-24 Google workbook: https://docs.google.com/spreadsheets/d/1rDAprVlPuVfFriIIr3sXRS4TF1Mc2WA2nE_JqQXElPI

Copy the field names and data from result tab TeacherPay2324 into the Jun23 tab(cell A1)



From July 2023 through May 2024:

Open the TeacherPay23-24 Google workbook: https://docs.google.com/spreadsheets/d/1rDAprVlPuVfFriIIr3sXRS4TF1Mc2WA2nE_JqQXElPI

Copy the field names and data from result tab TeacherPay2324 into the tab(cell A1) corresponding to the current month



From July 2024 through May 2025:

Open the TeacherPay24-25 Google workbook: https://docs.google.com/spreadsheets/d/1wJmS30C0yXP6BtZOb05nFGbhJKBy07SG2KpeZwRuUDA/edit#gid=0

Copy the field names and data from result tab TeacherPay2425 into the tab(cell A1) corresponding to the current month



After entering data in the Google workbook(s) send an email to finance@veritaspress.com to inform the task has been completed. Please include a link to the Google workbook(s) in the email message.



Query:


-- NAME:TeacherPay2223

SELECT lastname,firstname,Enrolled,CourseName,Section,SeatType,Term

FROM v_rpt_Teacher_Schedule_With_Enrollments_2022_2023

WHERE Term IN ( '2022-2023 School Year', '2022 Summer A', '2022 Summer B' )

ORDER BY lastname, firstname ASC;


-- NAME:TeacherPay2324

SELECT lastname,firstname,Enrolled,CourseName,Section,SeatType,Term

FROM v_rpt_Teacher_Schedule_With_Enrollments_2023_2024

WHERE Term IN ( '2023-2024 School Year', '2023 Summer A', '2023 Summer B' )

ORDER BY lastname, firstname ASC;


-- NAME:TeacherPay2425

SELECT lastname,firstname,Enrolled,CourseName,Section,SeatType,Term

FROM v_rpt_Teacher_Schedule_With_Enrollments_2024_2025

WHERE Term IN ( '2024-2025 School Year', '2024 Summer A', '2024 Summer B', '2024 Summer C' )

ORDER BY lastname, firstname ASC;






NOTE: Procedure will require maintenance in June of 2024: creation of new query with new view v_rpt_Teacher_Schedule_With_Enrollments_2024_2025, new Google workbook TeacherPay24-25