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.
CSU_AM_ABSENCE_OVER_USAGE - Used Excess of Balance
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.
CSU_AM_ABS_WORKFLOW_ISSUES
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.
CSU_AM_CFA_VACATION_40HRS - CFA 40-hour vac required
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.
CSU_AM_ELIGIBILITY_GROUP_AUDIT -AM Elig Group Audit-Active EE
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.
CSU_AM_DOCK - Dock Transactions
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.
CHRS_AM_PAYEE_MESSAGES - Payee error Messages - Absence
Utilized by CHRS Operations to identify and address absence errors before the calendar is finalized.
CSU_AM_PEND_ABS_REPORTING - Pending Absence Reporting
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.
CSU_AM_PH_USAGE_BAL_AUDIT - PH Usage & Balance Audit
This query captures PH not used and invalid PH balances based on the Year (YYYY) entered.
CSU_AM_ROUTE_WRONG_EMAIL - Abs Pend Appr Routed to Email
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).
CSU_AM_RETROTRIGGERCHECK - Retro Trigger Check
A Retro Trigger query that retrieves triggers currently in process or unprocessed, based on the provided Empl ID.
CSU_AM_STATE_SVC_ACCRUAL - Incorrect state serve accrual
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)
CSU_AM_VACATION_FORFEITURE- Year-End Vacation Forfeiture
This query captures year-end vacation forfeitures.
End of Article