LDPR - Identifying Code for Employees with Overrides

Area(s) of Analysis: 
Agency Detail - Employee
Microsoft Office document icon Download (92 KB)
Date Submitted: 
Contact Full Name: 
Randall Hutton
Office of Administration
Phone Number: 

This query builds a table of employees who have ldpr or work cycle overrides on AGYS. This query uses an agency view of SNAP_EMPLOYEE, and an agency view of BKG_ASGN. The result table includes the employee id, appointment id, last name, first name, asignment effective date, asignment expiration date, employment status code, workcycle code on agys, ldpr override description on agys, ldpr code on agys, and accounting information on agys. A sample of the result table is included with the source listing.


The Office of Administration has not tested the source code for any of these Access or FOCUS AdHoc Reports. The Office of Administration is providing the source code as a service and will not accept responsibility for any inaccuracies. The Office of Administration will also not support the code. Please contact the developer of the code for further information.