Sample Request: Employee Search

A new report request is available in the common library to obtain employee information (e.g., SSN, position number, status, etc.) for your active or separated employees, when only the employee name is known. The name of the request is: EESEARCH.

It searches the Transaction Data (TR) file for any faculty or staff employee whose first and last name contains the characters supplied. Partial last names and/or initials are acceptable for searches. The system will return transaction data for the most recent effective date for each position sequence the employee has at your campus. Note: This report contains prompts, so it can only be executed in the online FOCUS environment. A sample of the report EESEARCH is shown below:

PSN time

SEQ EFF DATE sTATUS cAMPUS POSITION NUMBER Class TITLE base SALARY

--- -------- ------ ------ --------------- ------------ ------ --------

999-99-9999 SNAKE, ANN B

01 12/07/1980 SEPARATED chiCO 000-111-2905-995 LIB AST II-A FT $1,560.50

02 01/31/2003 ACTIVE chiCO 000-111-2355-916 GRAD AST B/AS 001002 $410.00

An similar report is also available in the common library that searches the Active Current Status (AC) file for current employees. A sample of the report SEARCH is displayed below:

time

SOC-SEC-NUM CAMPUS POSITION NUMBER Class TITLE base SALARY

----------- ------ --------------- ------------ ------ ---------

SNAKE, ANN B

999-99-9999 sonoma 00-111-2355-916 GRAD AST B/AS 001002 $410.00

If you have any questions about the reports, refer to your FOCUS documentation or call the CIRS Hotline.