Sample Request: Position Count On A Specific Date

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