Employee Queries

Last updated October 28, 2009 11:52:49 AM PDT

Give more feedback

Employee queries give authorized staff a dynamic and flexible way to view employee data.

You can also access employee queries with the Queries button in EmployeeLink.

Note: You must have a Single Sign-On account and authorization to access EmployeeLink. If you do not have authorization, see How to Get Access to UCSD Business Systems.

Click access in each description to see what rights you need for particular results.

Links to the queries	Description	Links to query features and history
Distribution of Payroll Expense	Lists the breakout of all payroll expenses, including a breakout of benefit and payroll information by employee (access)	May 2002
Distribution of Payroll Expense Easy Query	Creates an online version of the current hard copy DOPE for any period or time (more info) (access)	June 2002
Employee	Accesses information about the current population of employees (access)	July 2004
Employee Change History	Lists the history of changes on employee information (access)	July 2004
Employee Code Values Easy Query	Returns the type of code you request, a short and long description, and whether the code is active (access)	August 2001
Employee Monthly Snapshot	Accesses information in snapshot of employee population, taken at the end of each month (access)	July 2004
Employee Nonresident Alien	Allows access to the current population of employees (access)	May 2003
Head Count	Returns counts of the various populations at UCSD (access)	May 2004
Incentive Award Program	Accesses current leave balance for a specified list of employees (access)	May 2004
Leave Activity	Retrieves leave balances by various specifications (more info) (access)	August 2003
Leave Activity Summary Easy Query	Provides an online replacement for the printed LASR (more info) (access)	April 2004
Leave Balance By Employee Group Easy Query	Accesses current leave balance for a specified list of employees (access)	March 2004
Leave Balance By Timekeeper Easy Query	Accesses current leave balances for employees within a timekeeper code (more info) (access)	March 2004
MyTraining Easy Query	Retrieves personal training history of classes taken through UCSD Staff Education and Development.(more info) (access)	January 2004
Permanent Staffing	Current and historical organizational staffing information (access)	February 2004
Telephone and E-mail Lists	Returns phone, fax, and e-mail of anyone in the UCSD phone directory (access)	September 2001
Termination Payment Report Easy Query	Reports DOPE entries for a requested time period to verify termination payments (more info) (access)	July 2003
Training Activity	Lists classes taken through UCSD Staff Education and Development, based on criteria selected (more info) (access)	April 2004
Training Activity by Employee Easy Query	Shows UCSD Staff Education and Development training classes completed by a specific employee. (more info) (access)	April 2004
Vacation Leave Accrual	Presents the data file with the amount of vacation used and accrued by an employee (access)	August 2001

Employee Queries

More queries:

Technology

Access

Departments