CHRS Knowledge Base

TL Delivered Queries for CHRS

Updated on

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.

CSU_TL_ADO_BALANCE - ADO Balance and Detail

This query captures employees with ADO balances.

CSU_TL_ADO_DETAIL - ADO Transaction Detail 

This query captures detailed ADO transactions.  Use this query to review ADO activities.

CSU_TL_CTO_BALANCE - CTO Balance and Overage

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.

CSU_TL_CTO_DETAIL - CTO Transaction Detail

This query captures detailed CTO transactions.

CSU_TL_TIMESHEET_SUMMARY - Payable Time Summary

This query captures timesheet summary.  Use this queyr to review CTO activities.

CSU_TL_TIMESHEET_DETAIL - Payable Time Detail

This query captures detailed timesheet transactions.

CSU_TL_TIMESHEET_PEND_APPROVAL - TL Timesheet Pending Approval

This query captures timesheet transactions pending approval.

CSU_TL_WORK_SCHED_OFFDAY  - Audit Off Day Config

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.  

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) TL Troubleshooting Guide
Next Article (job aid) Additional Pay Process Flow
Do you need an article? Contact Us