This series of two queries generates a table of terminated employees with active direct deposit, fringes, or deductions. These queries use an agency view of SNAP_EMPLOYEE, an agency view of BKG_DEDO, and a current day view of REF_DEDT. The result table includes the employee id, appointment id, last name, first name, deduction type code, deduction type long description, deduction option effective date, and deduction option expiration date for deductions which are effective today for employees who have no current active appointments with the agency. A sample of the result table is included with the source listing.
Terminated Employees with Active Deductions
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.