PCR Educator Data Analytics has a new table called Division Calendar. It exposes each division's current Marking Period, Semester, Academic Year, Admissions Year, Development Year, and Fiscal Year as a single always-current row per school. Saved filters, queries, and notification triggers can reference the current period directly, and the values stay accurate as the calendar rolls over.

What's new

One row per division. Division Calendar returns the current calendar values for every division a school runs, keyed on School Id, with columns for Marking Period, Semester, Academic Year, Admissions Year, Development Year, and Fiscal Year.

Division-aware values. Schools that run different calendars per division (Lower, Middle, Upper, or multi-campus) get the right current value for each division automatically.

Drop-in join for any table. Join Division Calendar to any existing table on School Id to scope a full DAT report or notification trigger to "this division's current marking period," "this division's current academic year," and so on.

Cross-departmental coverage. Academics, Admissions, Business Office, and Development all reference the same shared current-period table, so dashboards stay aligned across roles.

Why it matters

Build a filter once and it keeps working term after term, year after year. A query like "students with 5 or more absences in the current marking period" reads the current value from Division Calendar and stays correct as the calendar advances. Reports and notification triggers stay aligned to the actual calendar each division follows, automatically.

Example queries

• All students with 5 or more absences in the current Marking Period for their division
• Inquiries created in the current Admissions Year, by division
• Giving totals year-to-date for the current Development Year
• AR aging snapshot inside the current Fiscal Year
• Gradebook averages for sections in the current Semester

A few ways to talk about it

• Filters that stay current automatically: build once, reuse across every term and every year.
• One shared source of truth for the current period across Academics, Admissions, Business Office, and Development.
• Division-aware by design: Lower, Middle, and Upper school dashboards each read the right calendar value automatically.

Available now to all PCR Educator schools. Your account team can walk you through Division Calendar whenever you're ready.