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 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).
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 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 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 multple rows have invalid enrollment. The cleanup must done at least once a month and before month-end close.
This query captures year-end vacation forfeitures.
This query captures PH not used and invalid PH balances.
End of Article
0 Comments
Add your comment