The sample request below provides a count of active positions at your campus as of March 1, 2005. It is generated using the Employment History (EH) extract file. The EH extract process can be used to create a current status file for any point in time back to January 1, 1976 or when your campus came up on PIMS, whichever is later.
active and on-leave positions
as of march 1, 2005
eh:position
group count
----- -----------
faculty 952
mgmt 112
staff 1277
total 2341
Step 1: Create An EH Current Status File
From the main ad hoc reporting menu, press the F12 key and select the Employment History Extract process screen. Make the following selections and press enter to submit your extract job. Note: The FROM and TO dates must be equal. For more information, refer to the topic: Create An EH Current Status File.
SSN Selection: ALL
Effective Dates: from 050301 to 050301
File Type: CURRENT STATUS
A98 trans: EXCLUDE
sEPARATions: EXCLUDE
Step 2: Confirm Your Extract Job
After submitting your extract job, confirm the job completed successfully. You can do this either by using the F1 key to check status, or by noting the system notification message. For more information, refer to the topic System Messages.
Step 3: Report Using Your EH File
After confirming a successful extract, you can use the file for reporting. Below is a sample report request.
EX EH
define file eh add
group/a10 = if eh:cbid eq 'r03' then 'faculty' else
if eh:cbid eq 'm80' or 'm98' then 'mgmt' else 'staff';
end
TABLE FILE EH
heading center
"active and on-leave positions"
"as of march 1, 2005"
" "
COUNT EH:position COLUMN-TOTAL
BY group
END