PS Query & SQL

We have PS queries that are referencing PS_PAY_CAL_BAL_ID table, which currently lacks entries for FY 2026.
It appears that the Balance ID table was not updated prior to the last payroll run, which likely prevented the process from generating the necessary entries for FY 2026.
We would like to understand if there is a supported way to populate PS_PAY_CAL_BAL_ID table for FY 2026. Our Fiscal Year 2026 starts from 7/1/2025.
Thanks for the help.

------------------------------
Kura Reddy
PeopleSoft Application Developer
New Jersey City University
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

I might be missing some information, but if your pay confirm process did not update your balances, you should open an SR because it is supposed to.  Our FY starts on May 1st and we never had any problem with opening the new FY or missing balances as far as I know... 

------------------------------
Camille Potvin
Senior Business Analyst
HEC Montreal
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Hi Camille,

The issue is that the Balance ID setup for the new fiscal year had not been done before the payroll was confirmed. So the process must have skipped inserting in the table PS_PAY_CAL_BAL_ID. 

Ritu

------------------------------
Ritu Shastri
Director- Application Development and Analytics
New Jersey City University
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Original Message:
Sent: 07-21-2025 09:34 AM
From: Camille Potvin
Subject: Entries missing in Balance ID Table for FY 2026

I might be missing some information, but if your pay confirm process did not update your balances, you should open an SR because it is supposed to.  Our FY starts on May 1st and we never had any problem with opening the new FY or missing balances as far as I know... 

------------------------------
Camille Potvin
Senior Business Analyst
HEC Montreal
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------