The sample request below can be used to identify employees who have an anniversary date in the current month. The report lists employees alphabetically by lastname and contains one row for each active position an employee holds. This is a very simple report that can be used by anyone with basic ad hoc writing skills. The complete report request is available in the CIRS common library as FOC5013.
EMPLOYEES WITH AN ANNIVERSARY DATE IN THE CURRENT MONTH DATA AS OF 11/23/2005 EMPLOYEE SSA POSITION ANNI DATE -------- --------- --------- --------- BABOON, KATHY 234-56-7890 000-079-1035-001 122005 DUCK, LAURIE 123-45-6789 000-270-1032-001 122005 FROG, MICHAEL 789-01-2345 000-753-0440-009 122005 COMMON REQUEST: FOC5013 EXECUTED: 11/30/2005 |
The Active Current Status file is used for this request because it contains a snapshot of active and onleave positions for your faculty, staff and management employees as of the prior Friday. Since the AC file does not contain students, special consultants or separated employees, the only screening statements required is for the desired timeframe. Note: Anniversary date (AN:ANNIDATE) is not a 'smart' date so it cannot be typed with a slash (e.g., 12/2005).
EX AC
TABLE FILE AC
HEADING CENTER
"EMPLOYEES WITH AN ANNIVERSARY DATE IN THE CURRENT MONTH"
"DATA AS OF <AC:DAO"
PRINT AC:POSIT16 AS 'POSITION'
BY AC:WNAME AS 'EMPLOYEE'
BY AC:SSA AS 'SSA'
IF AC:ANNIDATE EQ 122005
FOOTING
"COMMON REQUEST: FOC5013"
"EXECUTED: &DATE"
END
Last Updated: March 1, 2024