Campuses can create their own private queries; however, they should first review the delivered queries to see if an existing one meets their needs before creating a new one.
Please note that not all delivered queries may be documented or identical, as modifications and ongoing development may result in differences.
This query identifies employees whose absence usage exceeds their available balance and reflects cases where the campus has resolved the issue, resulting in the employee no longer appearing in the query results.
This query identifies absence events where an approval workflow was not attached after it was submitted. The workflow status will be blank and the transaction numbers will be "0". These events will need to be deleted and resubmitted.
This query captures employees who have not used sufficient vacation time per CFA's annual vacation usage requirement. Any employees who used less than 40 hours at year-end will require a balance adjustment to reduce their vacation balance to account for the missed usage.
This query displays anyone with CSU_SCKAE from the Calendar_ID prompt of any closed pay period if they are in the list of selected job codes.
This query captures employees who are not enrolled in the correct AM Eligibility Group. Review the results and correct the employee(s) AM enrollment in Job Data, as appropriate. Note that more than one Job row may require correction if multiple rows have invalid enrollment. The cleanup must be done at least once a month and before month-end close.
This query captures dock transactions, including docks that cross periods as long as the date of the transactions fall within the prompted period. For example, the user prompts for docks between 07/01/25 to 7/31/25 and the dock dates are 06/30/25 to 07/15/25 (single transaction) with 06/30/25 being part of the 06/2025 cycle, the 06/30/25 dock day will be captured.
Utilized by CHRS Operations to identify and address absence errors before the calendar is finalized.
This query captures employees who have not reported absences - including CTO, ADO, Holiday CTO, and Holiday Credit-- or No Leave Taken (NLT). Review and ensure that all employees captured in this audit report their monthly absences or report No Leave Taken, as applicable.
This query captures PH not used and invalid PH balances based on the Year (YYYY) entered.
This query captures absences that are pending approval and routed to the wrong email. This is to temporarily address the known PeopleSoft workflow limitation Campuses are to review this output on an on-going basis and reroute absences to the correct approver for those approvers, specifically those who have more than one Operator ID (multi campus employee).
A Retro Trigger query that retrieves triggers currently in process or unprocessed, based on the provided Empl ID.
This query is designed to identify employees who may have incorrect state service month accruals during the AM cycle. Users will be prompted to enter two dates and should ensure they are consecutive months. For example, do not enter dates like 2025-01 and 2025-05.
FROM (YYYY-MM): This is the cycle being compared (e.g. 2025-03)
TO (YYYY-MM): This is the cycle being compared (e.g. 2025-04)
Intentional state service adjustments made by campuses will also appear in the results.
This query captures year-end vacation forfeitures.
End of Article