PS Query & SQL

 View Only
  • 1.  Entries missing in Balance ID Table for FY 2026

    Posted 07-17-2025 01:49 PM

    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.
    ------------------------------
    Alliance 2026 Registration is Open!


  • 2.  RE: Entries missing in Balance ID Table for FY 2026

    Posted 07-21-2025 09:34 AM

    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.
    ------------------------------

    Alliance 2026 Registration is Open!


  • 3.  RE: Entries missing in Balance ID Table for FY 2026

    Posted 09-03-2025 04:53 PM

    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.
    ------------------------------

    Alliance 2026 Registration is Open!