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.