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 employees with ADO balances.
This query captures detailed ADO transactions. Use this query to review ADO activities.
This query captures employees with CTO balances, including those who have balances that exceed the allowable amount and exempt employees whose balance needs to be paid down.
This query captures detailed CTO transactions.
This query captures detailed timesheet transactions.
This query captures detailed timesheet transactions.
This query captures timesheet transactions pending approval.
This query captures work schedules that are not correctly defined for off days. The Off Shift indicator must be turned on for day(s) where the employee is not scheduled to work (e.g. 0 hour days). Campus should only correct employees who are assigned to “personal schedules” and report any issues discovered for predefined schedules via ServiceNow ticket.
The result will display all days that require correction, and thus, the same employee may appear more than once on the list.
This query captures employees on alternative work schedule.
Active employee being assigned into a work group that belongs to another campus
Active employee with no TRD assigned. Excluding Immediate Pay. Action Date is set to a specific date.
End of Article
0 Comments
Add your comment